Free Stock Quote Tool

Document created by Bob Gill on Mar 5, 2018Last modified by Bob Gill on Mar 6, 2018
Version 2Show Document
  • View in full screen mode

About the Solution/Project: 

While learning more about BOARD, I wanted to experiment with the Yahoo Finance API and understand how I can pull public financial data into a model to show a simple stock quote and chart. I wanted to be able to show a quote and chart on a screen, or possibly use the data for KPI calculations. Very quickly, I realized that the Yahoo Finance API is no longer available. It's not a major loss though. There are a number of other providers of free data. Google provides free stock data. I'm sure there are limits to access, but for my purposes it works fine. I also wanted to experiment with loading a HTTP file, rather than using a connector for a web service. Again, the Google service seems to work well with it. The database and capsule file are attached at the end of this document for anyone to investigate and reuse.

 

Warnings

This is not intended for production purposes. This is for training and education purposes, but you can reuse any piece of this, if you choose, at your own risk. I did read about other data providers being better than Google's free service. If data quality is a concern, please investigate which provider is the best fit for your needs.

 

Outline

There is a simple screen to show a quote and chart. There is only one data reader that would be scheduled to run nightly. If you would like to get quotes for multiple ticker symbols, just clone the datareader and adjust the querystring to query for a different ticker symbol. There are some spreadsheet functions in use in the ETL screen to handle date formats and hard code the ticker symbol for a particular datareader.

 

Stock Quote Screen

Entities

      ...there are no relationships

Cubes

 

Datareader - GetQuote

The datareader looks at a specific URL for the data. This URL returns a CSV formatted file, with headers in the first row. One challenge I had to address was the format of the date from the Google service was not automatically recognized by BOARD as a date. I had to rearrange the date in to YYYYMMDD format to load the data.

Lessons Learned

  • BOARD can accept a variety of web datasources
  • Google is a simple source for stock quotes
  • The ETL screen is very handy for getting around small data conversion challenges

 

Links to Supporting Resources

Sample Query URL - https://finance.google.com/finance/historical?q=AAPL&startdate=01-Jan-2018&output=csv 

Bye Yahoo, and thanks for all the fish – The Financial Hacker 

Has Yahoo suddenly today terminated its finance download API? - Stack Overflow 

 

4 people found this helpful

Attachments

Outcomes