The code below does the following A copy of the jupyter notebook can be found here The code below is the libraries used, the function to get stock data, and the ticker_list Below are the summarizing and plotting functions And the code to run this all Resulting summary will look like this
This tool allows Excel to be the main interface for trading through the Alpaca broker Below are two demo videos of the tool This tool allows the following to be done via Excel Some aspects of the tool that can be customized are Known Limitations Please note: this has only been tested on windows based machines Link to tool for purchase
Video link of tool: YouTube Link Please note: Link to tool for purchase
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 add the Simple Moving Average calculation and indicator. Here is a link for the Simple Moving Average https://www.investopedia.com/terms/s/sma.asp. The below code has 2 functions: SMA and pullOHCL_Signals Output
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...
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...
I am going to show how to create a python screener that pulls OHLC data from Yahoo Finance and then calculates buy/sell signals for the following indicators. Please note: the three bullets below are Investopedia links should you need more information Link to github code Pull OHLC Data From Yahoo Finance & Calculate Indicators Show The 5 Most Recent Days Per Symbol
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...
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...
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...
All rights are reserved.
