Alpaca Trading Tool: Excel + PyXLL

This tool allows Excel to be the main interface for trading through the Alpaca broker

• This builds upon the Alpaca RTD Streaming example and adds additional functionality giving you the ability to trade and manage your portfolio within Excel
• PyXLL is a paid library/add in/tool that enables you to integrate python into Excel. While there are other tools that one could use for python+excel, I found this to be the only one that supported Real Time Data (RTD)
  • This means data is constantly pushed to excel and the values in excel update automatically
  • Use the code ROSSAUTOMATEDSOLUTIONS10 to get 10% off the first year with PyXLL

Below are two demo videos of the tool

• Video link of tool (non crypto)
• Video link of tool (crypto)

This tool allows the following to be done via Excel

• Streaming data per the above
• Place trades
• Get trade updates (open, partially complete, etc)
• Pull order history
• See key account information

Some aspects of the tool that can be customized are

• Crypto or Non Crypto streaming
• Live Account or Play Money Account
• RTD refresh frequency

Known Limitations

• Ticker limit imposed by Alpaca. You can upgrade if you need to stream more tickers
• RTD refresh rate can’t be faster than 3 seconds

Please note: this has only been tested on windows based machines

Link to tool for purchase