No One is Born a Great Trader, One Learns by Trading.

1. Go to Gmail account >> Click on google apps icon besides setting icon >> Click on Drive icon app 2. Click on New button >> Google Sheets >> Blank Spreadsheet 3. Fill out the first row as shown below:- Scrip Name LTP OPEN HIGH LOW PREV CLOSE CHANGE CHANGE PCT OHL 4. Get the scrip name list from the NSE website >> Click on the below link and download the latest date excel sheet All Companies based on Market Capitalisation 5. Copy the symbols from the excel sheet and past them to the newly created excel sheet. 6. Put down the formulas as per column name below:- LTP :   = GOOGLEFINANCE ( "NSE:" & A3 , "PRICE" ) OPEN :   = GOOGLEFINANCE ( "NSE:" & A3 , "priceopen" ) HIGH :   = GOOGLEFINANCE ( "NSE:" & A3 , "High" ) LOW :   = GOOGLEFINANCE ( "NSE:" & A3 , "Low" ) PREV CLOSE :   = GOOGLEFINANCE ( "NSE:" & A3 , "closeyest" ) CHANGE :...

While starting with the share market we all do some common mistakes and these are quite common around new folks and as well as old ones too. Hence it can be avoided if we act in a logical way and think of it as a long-term game. Let's see some of the common mistakes we all do once we are in the share market. 1. Running behind the perfect setup: - We all run behind a perfect setup so that we would make money out of it in all market conditions or make money in every trade we took since this is a myth. We should all focus to find a high probability setup whose success rate should be 70-80% since it will also depend upon market condition and volatility. 2. Taking more Leverage and take a loan for Trading: - We all have a fantasy of taking a loan and leverage and then double or triple or even make 10 times of it and then pay our dues to the respective parties than live happily after that, sound interesting right. But this doesn't happen and people who came with 1-2 lakhs end up payi...

1. William Delbert Gann (6 June 1878 - 18 June 1955) WD Gann is a mysterious trader who used to give the exact price of commodities by following his own methods based on astrology, geometry, and ancient mathematics. Even today Gann followers try to predict the market by his technical tools like Gann angles and the Square of 9. 2. Jesse Livermore (26 July 1877 - 28 November 1940) Jesse Lauriston Livermore was an American stock trader.  At the age of 14, he secured employment as a board boy posting stock quotes at a Boston. At the age of 16-17, Livermore's nickname was 'The Boy Plunger'. In 1907, took huge short positions and made $1 million in a single day. Livermore shot himself since he had lost most of his money by 1934. 3. George Soros (12 August 1930) He is a Hungarian-born American net worth of $8.6 Billion. He is also known as 'The Man  Who Broke the Bank of England' because of his short sale of $10 billion worth of pounds sterling and makes a profit...