Check monthly high and low of all stocks

rajeshmskrp · February 3, 2019, 11:48am

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

ashitvora · February 4, 2019, 5:41pm

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

SANJIVVASHISHT · February 5, 2019, 4:27am

Sir any code for this if any please provide

rajeshmskrp · February 9, 2019, 10:11am

Sir can u plss send formula to do it

ashitvora · February 12, 2019, 1:56pm

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.

ashitvora · February 12, 2019, 2:04pm

=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.

rajeshmskrp · February 13, 2019, 3:15pm

Thank you sir