Get live stock price data on Google sheets

Have a excel file with all the interested/listed companies with their nse code. If you don't find it online, I have 1000 big company list. Message me from contact form. Example, Reliance Industries Ltd., Code name: RELIANCE. Excel make it NSE: RELIANCE using formula, 'NSE:'&"cell no containing RELIANCE".

So, code name column is ready. NSE: RELIANCE, which is assumed to be located in E2 cell.

% ----------------------------

Stock Name: 

=GOOGLEFINANCE(E2,"name")

>> Reliance Industries Limited

Current market price: 

=GOOGLEFINANCE(E2,"price")

>>2228

P/E: 

=GOOGLEFINANCE(E2,"pe")

>> 33.07

30 day previous values:

=(GoogleFinance(E2, "price", TODAY()-30, TODAY())) 

Plot time series:

=SPARKLINE(GoogleFinance(E2, "price", TODAY()-30, TODAY()))

1 day change in percentage: 

=GOOGLEFINANCE($E2,"CHANGEPCT")

>> 0.76

30 day change in percentage:

=ROUND( ( GOOGLEFINANCE($E2,"price") / index(GOOGLEFINANCE($E2,"open", datevalue(today()-30) ) , 2,2) - 1 ) * 100 ,2)

% ------------------

Those are starting and then you can search internet and add others and play with it.

----------------------------------------

Disclaimer: Stocks mentioned (if any) here are not recommendation. We may have already invested in some of the name mentioned here. Read full disclaimer here

       

----------------------------------------