Check monthly high and low of all stocks


#1

Dear all,

Please help me to find a way to get the high and low of all stocks in a single excel file.

Regards,
Rajesh


#2

You can easily do that using Google Spreadsheet. You can use .Google Finance API as a function in Google Spreadsheet.


#3

Sir any code for this if any please provide


#4

Sir can u plss send formula to do it


#5

I need to check that but I used to use it to track current price and hence P&L.
You can use that not just for Direct Stocks but Mutual Funds as well.


#6

=GOOGLEFINANCE(“INFY”, “HIGH”, TODAY()-30,TODAY())

This will give you HIGH price of INFY of last 30 days. Now run MAX over this to get Highest of last 30 days.

Please refer this document for more details - https://support.google.com/docs/answer/3093281?hl=en


#7

Thank you sir