I always thought of doing a series of posts showing how Google finance and Google sheets have replaced my other expensive tools that were used for screening my intraday picks and finding the intraday trend.
I was reliant on tradingview.com earlier for their alert services but had stopped subscribing their Pro subscription after setting my own google sheets that do their job for me. I use that site only for analysis now.
In this post I will show how to pull the Google Finance backfill data onto a Google sheet. This bakcfill data is used to populate the google finance website with varying degrees of delays depending on the exchanges, which can be checked at Google Finance disclaimer
Google Sheets supports javascript based apps scripts. To know more you can check this article.
To know about backfill data configurations check http://www.marketcalls.in/database/google-realtime-intraday-backfill-data.html
The function that I am using for this particular task is given below,
This function can be called from the spreadsheet as a formula
=getGoogleBackfillData("ACC","NSE",300,1)
The parameters being used by the function are :
stockname - ACC in this example
exchange - NSE in this example
interval(sec) - 300 to pull 5 minute data
days - 1 retrieves one day data
See the result set below:
The timestamp shown is a unix timestamp with successive rows adding minutes to the previous row. How to use this data? I will do a separate posting on this.
We will see another screener that uses the google finance function in the google sheets to pull data in the next article.
I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you...
Join the fabulous Steemit Blogger Discord community:
https://discord.gg/e5XFZKa
Cheers,
dbdecoy
