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
When working with financial data, efficiency matters. Traders, analysts, and data scientists rely on various storage formats—CSV, Parquet, and SQLite—for backtesting trading strategies. But which format offers the best performance? In this post, I benchmark three widely used storage formats while backtesting Apple Inc. (AAPL) stock data. The goal? To determine which format provides the fastest execution time while ensuring accuracy across different trading strategies. The Experiment I…
I wanted to show how you could create a python screener using yahoo finance data with TA-Lib. A link to the notebook can be found on my GitHub. Sample Code Sample Output Next Steps
Introduction Key Points To Call Out
This is a continuation in a series to show working examples of trading bots using Alpaca. A link to the notebook can be found on GitHub. This trading bot streams websocket data, calculates Bollinger Bands for signals, and then buys/sells accordingly. It also logs the data so you can review what’s going on too. An alternative version of this can be found here where the main difference is…
This is a continuation in a series to show working examples of trading bots using Alpaca. A link to the notebook can be found on GitHub. This trading bot streams websocket data, calculates Bollinger Bands for signals, and then buys/sells accordingly. It also logs the data so you can review what’s going on too. An alternative version of this can be found here where the main difference is…
This is the second post in a series to show working examples of trading bots using Alpaca. A link to the notebook can be found on GitHub. First I am going to provide a high level overview of the bot and then show a few key parts of the code. The bot does the following: RSI & Signal Calculations Get Data & Orders Running It Output In Terminal
This is the first post in a series to show working examples of trading bots using Alpaca. A link to the notebook can be found on GitHub. First I am going to provide a high level overview of the bot and then show a few key parts of the code. The bot does the following: Assets, Buy Wait Time, Cycles Code: Run All, Trading Strategy (ie when to…
You can leverage websockets and stream data for stocks, crypto, and options using Alpaca. Below, I’ll show the stock websocket example in full and then show the different code to use for crypto and websockets. The main difference between each is the uri used and the symbols. Copies to each py file can be found on my GitHub. In later posts/videos, I’ll build upon these examples and show…
I wanted to create a few posts/videos working towards a well thought out algorithmic trading framework. It will start off quite basic and then build over a series of a few examples of different trading bots using Alpaca. None of these should be taken as trading advice. This is purely to show working examples that can be used for inspiration. The following trading bots have been created and…
All rights are reserved.
