Monday, April 10, 2017

Off topic - How to add keyboard shortcut to macro in your excel sheet?



Following are the easy steps to add a keyboard short cut to you vba/macro in an excel sheet:
1. Open the excel sheet
2. Go to View - menu
3. Click on Macros
4. Click on View Macros    

5. Enter the macro name in the box and click on Options

6. Enter the keyboard shortcut that you want to use for this macro to run in the Shortcut Key   "Ctrl + " box and provide description (optional) and click on OK.


               
 That's it. Your now your keyboard shortcut to run the macro in excel file is ready. Whenever you would like to run the macro in the excel file, all that you have to do it press the shortcut key along with the Control (Ctrl) button.



Did you like this help? If yes please share it with others.

Sunday, March 26, 2017

Success mantra


Do not Strike when Angry


Yashiko was a wealthy samurai warrior in ancient Japan. He cut a fine figure; his armour and sword were of the finest workmanship. His ornaments were of the finest variety: silver, copper, gold and bronze. Even the toggles on his tunic were priceless netsuke: masterfully carved figures of animals, insects, dragons and fishes, made of the purest ivory. He lived with his wife and elderly mother in an elegant tiled house in the best quarter of the town. He frequently drank the rarest and finest of teas, and often dined in the most expensive restaurants. His wife Ayako was considered the most beautiful woman in the kingdom, and his aged mother was much celebrated for her wisdom and learning.
Life was good for Yashiko. He had a handsome salary from the emperor, regular revenue from his many properties, and a hefty stake in a porcelain trading business. But even all this wealth was not enough for a man like Yashiko. To keep from getting bored (which was uncomfortably often) the proud and greedy samurai decided to start a moneylending business for poor people.
“After all, it takes money to make money,” thought Yashiko. “You never know when a rainy day or a water flood or the wind dragons may come and wipe everything away. Life is at best uncertain. A day is bound to come when more money will be needed than what is presently being returned to me by my investments. The poor are always with us, and the poor always need money. I can charge them a high rate of interest and not have to lift a hand. What a clever way to make some extra cash! I wish I had thought of it long ago. Why, moneylending is practically a licence to mint money! I shall begin my new enterprise, at once! At once!”
Down at the docks, Michiko, a poor fisherman, had experienced an unlucky year with his business. Regretfully, he took out a sizeable loan from Yashiko so he could feed his wife and
children. A year later, the loan had not been repaid. The proud samurai strapped on his deadly sword and strode off to find the fisherman and collect what was his due.
“I’ll show him who’s boss,” thought Yashiko. “One look at me and my sword and he’ll come running with the money.”
Upon seeing Yashiko marching forcefully towards him, full of his own importance, the ragged fisherman bowed humbly before the proud samurai.
“O Revered Sir! Great Samurai! Noble Warrior! It has been a very bad year again for me. I do not have sufficient funds to repay you.”
“What!” shouted Yashiko furiously. “After all this time! You scoundrel! After all the time and patience I have shown you! A whole year has gone by and you cannot even show me a single yen in repayment! Now I am going to kill you!” Menacingly, he drew his sword.
Fearing his life was about to end, the fisherman spoke up loudly.
“Revered sir, for sometime now I have been studying martial arts. One of the lessons my master has taught me is that you should never strike another when you are angry.”
“Hmmmmm,” thought Yashiko. “This is a clever fellow.” Just to be on the safe side, he lowered his sword.
“Your master is wise,’ said Yashiko carefully. “And I myself, as a student of the art of the sword, have heard that lesson many times. To be honest with you, O fisherman, I have such a temper that I often act without thinking. I tell you what I will do. You shall have another year to repay your debt. If you do not repay me in one year, I will come and take your life away with this sword.”
“Thank you, kind sir,’ murmured Michiko, bowing low.
Yashiko composed himself and walked away, his honour intact. By the time he had dined out at his favourite restaurant and arrived home it was nearly midnight. Seeing no lights in his house, he crept in quietly, not wishing to wake the servants or disturb his wife and aged mother. As he entered the house he lit the bronze oil lamp in the hallway. There he saw his wife whispering secretly to a strange man in the darkened living room at the end of the hall. “What is the meaning of this insult!” shouted Yashiko. Swiftly he drew his sword, ready to kill them both instantly. Just then the words of the fisherman echoed in his fevered brain.
“Never strike when you are angry.”
Yashiko paused and took a deep, laboured breath. Then his wife lit a candle. To his amazement, he found himself face to face with not only his wife, but his beloved mother too, who was dressed like a man in his warrior clothing.
“What is the meaning of this? Are you both completely crazy? Is this a joke? I almost killed the two of you! I demand an explanation—immediately!”
“O Revered Husband,” murmured Ayako, “You, my lord, as a samurai, are the guardian and sole protector of this house. Because you had not returned by dark, Mother and I were afraid. We decided to dress Mother up in your clothes to keep away intruders.”
“Oh, my God! Oh, my ancestors!” wept Yashiko. He shivered at the thought that because of his terrible temper, he had nearly killed what he loved most in the world - his beloved wife and his adoring mother.
A year later, Yashiko went to see the poor fisherman down at the docks. Michiko, upon seeing the samurai walking towards him, bowed humbly before him.
“It has been an excellent year’s fishing, my Lord! Please accept the money I owe you, plus interest.” “Keep your money, dear man,” replied Yashiko gently. “You don’t know it, but your debt was paid long ago.”
Bhagawan says on the subject of anger:
One's anger is one’s greatest enemy and one’s calmness is one’s own protection. One’s joy is one’s heaven and one’s sorrow is one’s hell… assume silence when you are invaded by anger.
Or remember the name of the Lord. Do not try to remind yourself of things which will inflame the anger more... That will do incalculable harm. A man consumed by anger can never be free of misery. For the decline in human qualities today, pride and anger are primarily responsible.

Holidays for the calendar year 2017 : Equities

NSE trading holidays 2017
 

Sr. No.DateDayDescription
126-Jan-2017ThursdayRepublic Day
224-Feb-2017FridayMahashivratri
313-Mar-2017MondayHoli
404-Apr-2017TuesdayRam Navami
514-Apr-2017FridayDr.Baba Saheb Ambedkar Jayanti/ Good Friday
601-May-2017MondayMaharashtra Day
726-Jun-2017MondayId-Ul-Fitr (Ramzan ID)
815-Aug-2017TuesdayIndependence Day
925-Aug-2017FridayGanesh Chaturthi
1002-Oct-2017MondayMahatama Gandhi Jayanti
1119-Oct-2017ThursdayDiwali-Laxmi Pujan*
1220-Oct-2017FridayDiwali-Balipratipada
1325-Dec-2017MondayChristmas
*Muhurat Trading will be conducted. Timings of Muhurat Trading shall be notified subsequently.
The holidays falling on Saturday / Sunday are as follows:
Sr. No.DateDayDescription
109-Apr-2017SundayMahavir Jayanti
202-Sep-2017SaturdayBakri ID
330-Sep-2017SaturdayDasera
401-Oct-2017SundayMoharram
504-Nov-2017SaturdayGurunanak Jayanti
Market Timings
Trading on the equities segment takes place on all days of the week (except Saturdays and Sundays and holidays declared by the Exchange in advance). The market timings of the equities segment are:
A) Pre-open session
Order entry & modification Open : 09:00 hrs
Order entry & modification Close : 09:08 hrs*
*with random closure in last one minute. Pre-open order matching starts immediately after close of pre-open order entry.
B) Regular trading session
Normal / Limited Physical Market Open : 09:15 hrs
Normal / Limited Physical Market Close : 15:30 hrs
Block deal session is held between 09:15 hrs and 09:50 hrs
C) The Closing Session is held between 15.40 hrs and 16.00 hrs
Note: The Exchange may however close the market on days other than the above schedule holidays or may open the market on days originally declared as holidays. The Exchange may also extend, advance or reduce trading hours when its deems fit and necessary.

Saturday, March 25, 2017

Ashok Leyland has formed inverted hammer in daily chart

Ashok leyland has formed inverted hammer in the daily chart. Though this is not the lowest candle in the near vicinity, it is still near the lower end of the move. Though it is not very strong signal, any move above 87.55 can take it towards 88.30, 89.15, 92.85.

Daily cahrt:


30 min chart:


LIC housing finance - Price action analysis

LIC housing finance has moved down from the high of 623 to 470 swiftly. This is followed by a weak retrace which is taking months to move up to 600 range. Now in the daily chart we can observer that this formed an inverted hammer rejecting the price above 600. We need to observe the further move. If the down move gathers momentum then we need to see a move towards 578, which should be strong. Then it should be followed by a weak retrace upwards. Again a move down breaking the low of the swing. That will confirm the down trend and an entry in to short postion.

Monthly chart:




Weekly chart:



Daily chart:

BPCL price action analysis

Another inline with the companies in the same industry :
1. HPCL
2. IOC 
3. BPCL -  follows below:

Monthly chart:




Weekly Chart:



Daily chart:

IOC Indian Oil Corporation - Price action analysis

Stock price of companies in the same industry generally move in the same direction in normal market conditions.
Today when I analysed the price action move of HPCL, I was curious to watch IOC. The movements are similar!

IOC Monthly chart:




Weekly chart:



Daily chart;

Hindustan Petroleum price action analysis

Hindustan Petroleum chart analysis:

Monthly chart:
Hind Petro made a high at 583 and a swing low of 410. The range seems to be set in here for next couple of months.





Weekly chart:
If the current weeks low 498.60 is protected then it may move up for sometime. There may be a strong support near 490, from where the quick up move started.



Daily chart:
There is a doji and next candle is having lower high & lower low. So there is still a downward bias. It may re-test the 490 zone before moving up again.



Piramal Enterprises Limited - follow up

Earlier I had noted a possible 'B' wave correction as a triangle, ending near the high of 1920 for Piramal Enterprises Limited.

So far the development after that is indicating weakness in the up move. If we observe the price action movements, the down move though not gathered momentum yet but indicates the downwards bias. Large bearish engulfing candle formed yesterday indicates the same. Move below 1800 will increase the downward momentum.






From the price action movement in PEL it appears that the earlier view of B wave ending near 1920 is valid.

United Spirits Limited - Follow up

I had written a possible opportunity in United Spirits Limited on 23-03-2017, following it up with yesterday's move.

Opened at 2193. Open and low are same. Opened above the half of the previous candle. These all indicate the stock is currently in the up trend. Another minimum requirement for the up trend is higher high and higher low for the subsequent candles. This is also meet.

Here is the daily chart of United Spirits Limited :

Thursday, March 23, 2017

Aurobindo Pharma

I had analysed Aurobindo Pharma on 22-07-2016 when there was a news about its buy of Teva Pharmaceutical. This post shows how I label (Elliott Wave) the moves. Since then I have been following its movements.

There are two possibilities that I can see:
1. The down move which ended in December 2016 might have completed the 'C' and started the next up move.
2. Wave 'C' is still not over but a correction to the down December down move is going on. There might be another down move probably near 580 zone.

As of now the minor movements in daily chart shows weakness in the up move. There might be few days of down move expected.

Aurobindo Pharma weekly chart with Elliott wave labels:




Aurobindo Pharma with support and resistance marked for price action trading:




United Spirits - is giving a long opportunity?

Yesterday (22-03-2017) United Spirits Ltd (USL) has formed a doji candle. This is indicating the indecisiveness, where both sellers and buyers are trying their best to move the stock in their direction but no one is able to gain an upper hand. This is followed by a large green candle which opened above yesterday's closing. The low was above the mid of the Doji. The close of this candle has engulfed the last two candles indicating the strong come back of the buyers.

USL United Spirits Limited daily chart:


List of FnO stocks in NSE

I'm capturing some useful links, information in this post. These info will be handy for screening or analysis.
1. List of FnO stocks in NSE (as on 23-03-2017)

UnderlyingSymbol
INDIA VIXINDIAVIX
Nifty CPSENIFTYCPSE
Nifty 50NIFTY
Nifty ITNIFTYIT
Nifty BankBANKNIFTY
Nifty Midcap 50NIFTYMID50
Nifty PSENIFTYPSE
Nifty InfrastructureNIFTYINFRA
Dow Jones Industry AverageDJIA
S&P 500S&P500
FTSE 100FTSE100
Derivatives on Individual Securities
ADITYA BIRLA NUVO LIMITEDABIRLANUVO
ACC LIMITEDACC
ADANI ENTERPRISES LIMITEDADANIENT
ADANI PORT & SEZ LTDADANIPORTS
ADANI POWER LTDADANIPOWER
AJANTA PHARMA LIMITEDAJANTPHARM
ALLAHABAD BANKALBK
AMARA RAJA BATTERIES LTD.AMARAJABAT
AMBUJA CEMENTS LTDAMBUJACEM
ANDHRA BANKANDHRABANK
APOLLO HOSPITALS ENTER. LAPOLLOHOSP
APOLLO TYRES LTDAPOLLOTYRE
ARVIND LIMITEDARVIND
ASHOK LEYLAND LTDASHOKLEY
ASIAN PAINTS LIMITEDASIANPAINT
AUROBINDO PHARMA LTDAUROPHARMA
AXIS BANK LIMITEDAXISBANK
BAJAJ AUTO LIMITEDBAJAJ-AUTO
BAJAJ FINANCE LIMITEDBAJFINANCE
BANK OF BARODABANKBARODA
BANK OF INDIABANKINDIA
BATA INDIA LTDBATAINDIA
BHARAT ELECTRONICS LTDBEL
BEML LIMITEDBEML
BHARAT FIN INCLUSION LTDBHARATFIN
BHARAT FORGE LTDBHARATFORG
BHARTI AIRTEL LIMITEDBHARTIARTL
BHELBHEL
BIOCON LIMITED.BIOCON
BOSCH LIMITEDBOSCHLTD
BHARAT PETROLEUM CORP LTBPCL
BRITANNIA INDUSTRIES LTDBRITANNIA
CADILA HEALTHCARE LIMITEDCADILAHC
CAIRN INDIA LIMITEDCAIRN
CANARA BANKCANBK
CASTROL INDIA LIMITEDCASTROLIND
CEAT LIMITEDCEATLTD
CENTURY TEXTILES LTDCENTURYTEX
CESC LTDCESC
CG Power and Industrial Solutions LimitedCGPOWER
CIPLA LTDCIPLA
COAL INDIA LTDCOALINDIA
COLGATE PALMOLIVE LTD.COLPAL
CONTAINER CORP OF IND LTDCONCOR
CUMMINS INDIA LTDCUMMINSIND
DABUR INDIA LTDDABUR
DCB BANK LIMITEDDCBBANK
DEWAN HOUSING FIN CORP LTDHFL
DISH TV INDIA LTD.DISHTV
DIVI'S LABORATORIES LTDDIVISLAB
DLF LIMITEDDLF
DR. REDDY'S LABORATORIESDRREDDY
EICHER MOTORS LTDEICHERMOT
ENGINEERS INDIA LTDENGINERSIN
EXIDE INDUSTRIES LTDEXIDEIND
FEDERAL BANK LTDFEDERALBNK
GAIL (INDIA) LTDGAIL
GLENMARK PHARMACEUTICALSGLENMARK
GMR INFRASTRUCTURE LTD.GMRINFRA
GODREJ CONSUMER PRODUCTSGODREJCP
GODREJ INDUSTRIES LTDGODREJIND
GRANULES INDIA LIMITEDGRANULES
GRASIM INDUSTRIES LTDGRASIM
HAVELLS INDIA LIMITEDHAVELLS
HCL TECHNOLOGIES LTDHCLTECH
HDFC LTDHDFC
HDFC BANK LTDHDFCBANK
HOUSING DEV & INFRA LTDHDIL
HERO MOTOCORP LIMITEDHEROMOTOCO
HEXAWARE TECHNOLOGIES LTDHEXAWARE
HINDALCO INDUSTRIES LTDHINDALCO
HINDUSTAN PETROLEUM CORPHINDPETRO
HINDUSTAN UNILEVER LTD.HINDUNILVR
HINDUSTAN ZINC LIMITEDHINDZINC
INDIABULLS REAL EST. LTDIBREALEST
INDIABULLS HSG FIN LTDIBULHSGFIN
ICICI BANK LTD.ICICIBANK
INDO COUNT INDUSTRIES LTDICIL
IDBI BANK LIMITEDIDBI
IDEA CELLULAR LIMITEDIDEA
IDFC LIMITEDIDFC
IDFC BANK LIMITEDIDFCBANK
IFCI LTDIFCI
INDRAPRASTHA GAS LTDIGL
THE INDIA CEMENTS LIMITEDINDIACEM
INDUSIND BANK LIMITEDINDUSINDBK
BHARTI INFRATEL LTD.INFRATEL
INFOSYS LIMITEDINFY
INDIAN OIL CORP LTDIOC
IRB INFRA DEV LTD.IRB
ITC LTDITC
JET AIRWAYS (INDIA) LTD.JETAIRWAYS
JINDAL STEEL & POWER LTDJINDALSTEL
JAIN IRRIGATION SYSTEMSJISLJALEQS
JAIPRAKASH ASSOCIATES LTDJPASSOCIAT
JSW ENERGY LIMITEDJSWENERGY
JSW STEEL LIMITEDJSWSTEEL
JUBILANT FOODWORKS LTDJUBLFOOD
JUSTDIAL LTD.JUSTDIAL
KOTAK MAHINDRA BANK LTDKOTAKBANK
KPIT TECHNOLOGIES LTDKPIT
KAVERI SEED CO. LTD.KSCL
KARNATAKA BANK LIMITEDKTKBANK
L&T FINANCE HOLDINGS LTDL&TFH
LIC HOUSING FINANCE LTDLICHSGFIN
LARSEN & TOUBRO LTD.LT
LUPIN LIMITEDLUPIN
MAHINDRA & MAHINDRA LTDM&M
M&M FIN. SERVICES LTDM&MFIN
MARICO LIMITEDMARICO
MARUTI SUZUKI INDIA LTD.MARUTI
UNITED SPIRITS LIMITEDMCDOWELL-N
MINDTREE LIMITEDMINDTREE
MOTHERSON SUMI SYSTEMS LTMOTHERSUMI
MRF LTDMRF
NCC LIMITEDNCC
NHPC LTDNHPC
NIIT TECHNOLOGIES LTDNIITTECH
NMDC LTD.NMDC
NTPC LTDNTPC
ORACLE FIN SERV SOFT LTD.OFSS
OIL INDIA LTDOIL
OIL AND NATURAL GAS CORP.ONGC
ORIENTAL BANK OF COMMERCEORIENTBANK
PAGE INDUSTRIES LTDPAGEIND
PC JEWELLER LTDPCJEWELLER
PETRONET LNG LIMITEDPETRONET
POWER FIN CORP LTD.PFC
PIDILITE INDUSTRIES LTDPIDILITIND
PUNJAB NATIONAL BANKPNB
POWER GRID CORP. LTD.POWERGRID
PTC INDIA LIMITEDPTC
RELIANCE COMMUNICATIONS LRCOM
RURAL ELEC CORP. LTD.RECLTD
RELIANCE CAPITAL LTDRELCAPITAL
RELIANCE INDUSTRIES LTDRELIANCE
RELIANCE INFRASTRUCTU LTDRELINFRA
RELIANCE POWER LTD.RPOWER
STEEL AUTHORITY OF INDIASAIL
STATE BANK OF INDIASBIN
SIEMENS LTDSIEMENS
SINTEX INDUSTRIES LTDSINTEX
THE SOUTH INDIAN BANK LTDSOUTHBANK
SRF LTDSRF
SHRIRAM TRANSPORT FIN CO.SRTRANSFIN
STRIDES SHASUN LIMITEDSTAR
SUN PHARMACEUTICALS IND.SUNPHARMA
SUN TV NETWORK LIMITEDSUNTV
SYNDICATE BANKSYNDIBANK
TATA CHEMICALS LTDTATACHEM
TATA COMMUNICATIONS LTDTATACOMM
TATA ELXSI LIMITEDTATAELXSI
TATA GLOBAL BEVERAGES LTDTATAGLOBAL
TATA MOTORS LIMITEDTATAMOTORS
TATA MOTORS DVR 'A' ORDTATAMTRDVR
TATA POWER CO LTDTATAPOWER
TATA STEEL LIMITEDTATASTEEL
TATA CONSULTANCY SERV LTTCS
TECH MAHINDRA LIMITEDTECHM
TITAN COMPANY LIMITEDTITAN
TORRENT PHARMACEUTICALS LTORNTPHARM
TORRENT POWER LTDTORNTPOWER
TV18 BROADCAST LIMITEDTV18BRDCST
TVS MOTOR COMPANY LTDTVSMOTOR
UNITED BREWERIES LTDUBL
ULTRATECH CEMENT LIMITEDULTRACEMCO
UNION BANK OF INDIAUNIONBANK
UPL LIMITEDUPL
VEDANTA LIMITEDVEDL
VOLTAS LTDVOLTAS
WIPRO LTDWIPRO
WOCKHARDT LIMITEDWOCKPHARMA
YES BANK LIMITEDYESBANK
ZEE ENTERTAINMENT ENT LTDZEEL