HomeEducationLinking Open Source API to Google Spreadsheets to Track Investment: GOOGLEFINANCE, IEX and Alpha Vantage
Linking Open Source API to Google Spreadsheets to Track Investment: GOOGLEFINANCE, IEX and Alpha Vantage
October 5, 2018
What is API
API stands for Application Programming Interface. According to Google, API is a set of functions and procedures that allow the creation of applications which access the features or data of an operating system, application, or other service. In simple terms, it means a specification of remote calls for a program to interact with another software. API calls are required to retrieve data from the sources, such that you do not have to manually key in the data from the source to update your investment tracker. The data is being refreshed via the feed, freeing up your time for analysis instead of doing data entry.
In this article, I will share the basics of setting up simple API calls from GoogleFinance, IEXand Alpha Vantage.
Reason for my preference for Google Sheets is because the file is stored on cloud, meaning I can access it anywhere I want to. If you are a seasoned Excel user, you may find Google Sheets inconvenient to use as their user interface is slightly different and some functions are not available.
Another reason will be the GOOGLEFINANCE function that I use. As a tech noob person, I prefer simplicity to writing the codes so that I can spend more time doing analysis (which is what I prefer) instead of figuring out bugs and editing the script. (if you’re into coding and would like to showcase/ share your talent, please beep me and I would be glad to speak with you)
No set up for this is required, hence it is easy to use. However, the variety of data set and stock exchange data available are limited which calls for the other open source API’s to complement GOOGLEFINANCE. For my case, data from the Singapore exchange (SGX) is unavailable.
Syntax will be:
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])where ticker = ticker symbol for the security
[ ] = optional attributes; “price” by default
For full list of attributes available on GOOGLEFINANCE, please refer to link.
Andronika is borderline mental. To prevent causing distress to those around her, she has decided to set up this personal blog as an outlet and connect to like-minded people. When she is not working on her blog, you can find her with catching up on her never-ending summer reading list, working on her barre moves or taking a siesta.
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.