0

I can fetch the price of a stock using this:

=INDEX(GOOGLEFINANCE("GOOG","price","12/13/2020"),2,2)

However how to I query price at a particular date and time. I am open to use anything: GOOGLE, EXCEL etc. etc. I am looking at NSE and BSE exchange.

CuriousDev
  • 1,255
  • 1
  • 21
  • 44

1 Answers1

0

GOOGLEFINANCE, and other free sites (e.g Yahoo, etc.) only presents daily data (e.g. Open, High, Low, Close) so it is not an option.

Specific/Timely stock prices as far as I know are not free and you will have to buy that information.

Quoting from this page,

Commercial Historical Data

Higher resolution and more complete datasets are generally not available for free.

Unless you can provide a site that shows that data, include the site on your post and I'll provide you a formula/script to fetch/scrape that data.

NightEye
  • 10,634
  • 2
  • 5
  • 24
  • I have CSV files which contains date and time of a symbol. How do I query that in Google sheets? For eg: this is the data for the 1st of July stored in a folder called '01JUL' and in a file called ACC.txt ACC,20210701,09:08,2021.80,2021.80,2021.80,2021.80,465,0 – CuriousDev Aug 03 '21 at 23:15
  • Hi @CuriousDev, you might need to post it as another question as that is unrelated to the original question here. But to give you idea, I do think that if the file is not in google drive or not accessible online, then it would be impossible to import that data automatically (via formula or script) to sheets. – NightEye Aug 04 '21 at 15:25
  • Oh I can add these files to a google drive, no problem. Here's my question https://stackoverflow.com/questions/68659608/how-do-i-query-a-bunch-of-csv-files-in-google-sheets – CuriousDev Aug 05 '21 at 01:36
  • Did you get the chance to check my question? – CuriousDev Aug 10 '21 at 17:09