Other Interests

The Viz I submitted is unfortunately gone. I hosted the dash on my graduate school webpage and my site went away after graduation. 


Dashboards

I make financial and data dashboards and reports using Tableau, Power BI, Google Data Studio, Google Sheets, Excel, and even Perl/Python-> text. I blogged a few of these that you can find under the Blogging section.

 
Mention / thank you on the 2021 Independent Redistricting Commission Final Report

Acknowledgement of my contribution to the work of the County Redistricting Commission. (Page 4 / PDF Page 16)


Google Finance option chain data (Web Scraping)

x. 20200420. This no longer works because Google has also followed Nasdaq and Yahoo in making its data difficult to scrap. If you use the URL "https://www.google.com/finance/option_chain?q=MSFT&output=json", this is what you will probably see:

Google datablock. Sorry not sorry.
My code for downloading option chain data form Google Finance.


Scraping historical stock prices from Nasdaq.com, up to 3 months (Web Scraping)

x. 20200418. This no longer works because Nasdaq has followed Yahoo in making its data difficult to scrap. The historical data is now generated on-the-fly and does not show up in the HTML.
My code for downloading price data from Nasdaq. Yahoo has made it increasingly difficult to download financial data from their website (in the old days there were even API from Yahoo that aids with data download), so web data scrapers have to turn to other sources. This code scraps the html data of the stock's historical data page from the Nasdaq website. These types of code are prone to break because companies love to keep their site fresh and make changes to the underlying html code. If the code no longer works, please email me or leave a comment at the Matlab Central page.