Serving the Quantitative Finance Community

 
andysinclair
Topic Author
Posts: 2
Joined: September 18th, 2019, 4:29 pm

Excel Price Feed Add-in

September 18th, 2019, 4:36 pm

Hey everybody,

I’ve built an Excel Add-In which feeds live financial data to cells via simple formulas. I currently have data from Yahoo Finance and IG Index, I am working on other data providers.

For example to populate a cell with the latest Apple stock price: =EPF.Yahoo.Price(“AAPL”)

I have some users using it to automatically keep track of the value of their portfolio across different brokers and I also helping one guy working on an automated trading system in Excel.

Here's a tutorial on using it to build a realtime investment portfolio

You can try it free for 10 days at https://www.excelpricefeed.com

Hope it helps somebody!
 
User avatar
tags
Posts: 3162
Joined: February 21st, 2010, 12:58 pm

Re: Excel Price Feed Add-in

September 30th, 2019, 9:12 pm

I also helping one guy working on an automated trading system in Excel.
Can you please provide with details on this project? I mean Excel is not the trading API one would think of nowadays. Good luck with your endeavor anyways. Thanks.
 
andysinclair
Topic Author
Posts: 2
Joined: September 18th, 2019, 4:29 pm

Re: Excel Price Feed Add-in

October 2nd, 2019, 5:24 am

I also helping one guy working on an automated trading system in Excel.
Can you please provide with details on this project? I mean Excel is not the trading API one would think of nowadays. Good luck with your endeavor anyways. Thanks.
I should have said semi-automated. Every 5 minutes the spreadsheet updates with the latest market data, various formulas on the sheet are recalculated and a trading signal is generated (long/short/no trade). The trade is then executed manually.

Excel is great for prototyping but I don't think I would ever build a full automated trading system using it.
 
User avatar
ikicker
Posts: 30
Joined: June 8th, 2011, 12:19 am

Re: Excel Price Feed Add-in

November 11th, 2019, 3:06 am

I would recommend that you use SMF add-in if you are dead set on doing that with VBA in Excel. It's free and works with multiple data sources. It's pretty comprehensive: http://ogres-crypt.com/SMF/
  • You are probably going to have the same issue that they had, which is data sources getting
I would recommend rewriting your code in Python - it's faster and reliable packages already exist for scraping data, like this: https://www.linkedin.com/pulse/python-mass-downloading-equities-prices-corley-mba-lssbb-cpm/
  • Once you learn Python, you won't go back.
  • You can do all of the same things to excel files in Python that you can do with VBA.
  • You can have the entire S&P 500's historical prices in like 5 seconds.
----
Undergraduate: accounting, finance, information systems; Graduate: MBA/finance; Graduate certificates: data science, applied statistics, advanced valuation; PhD candidate - data science

Blog: Www.ThinkerTinkerSolutions.com