Stock Market & Finance

  • All
  • Articles
  • Blog Post
  • General Business Automation
  • Portfolio
  • Stock Market & Finance

July 31, 2023

This tool is comprised of a few parts. All of the code used in these posts can be purchased in a single spreadsheet if you’d like link to SMA Screener in store We are going to pull OHLC (open, high, low, close) data using Yahoo Finance for a list of tickers. The code below pulls the data for the past 10 days by ticker. This code will leverage...

July 31, 2023

This tool is comprised of a few parts. All of the code used in these posts can be purchased in a single spreadsheet if you’d like link to SMA Screener in store I’ll provide two examples of how to pull ticker data by leveraging Wikipedia. We will pull the tickers in Both of these functions will leverage the IMPORTHTML function. In addition, we will also use the QUERY...

May 29, 2023

I’ll demonstrate the following tasks: Background information on FTDs and the site we will be using can be found below A copy of the notebook can be found here: Github This shows the data/structure of the data and how the website is organized Download FTD Data Open Each Zipped Folder & Extract Add Each Extracted File To A Dataframe Review The Dataframe Note that price in this exploration...

May 26, 2023

This is an example of using Python to read a table. In this instance, the code will read all the symbols on a Wikipedia page for the S&P 500. This code can be part of a larger process. Maybe you need a list of tickers to then run through some filtering program. GitHub Link In addition to using the S&P 500 link you could also use the following...

May 23, 2023

Viewing the options chain can be a useful exercise when determining the right options to consider for your strategy. The purpose of this post is to share how to pull the option chain using python + TD Ameritrade. The code that is being shared is part of a larger project, which identifies potential arbitrage opportunities while looking at the option chain. Will demonstrate Reference Links A link to...