Recent content by andysinclair

I thought I would write up an explanation of what is currently going on with GameStop, in what could be a defining moment for the world of finance. I hope some of you find it interesting and informative: https://blog.excelpricefeed.com/2021/01/28/gamestop-wall-st-vs-main-street/ (here's the...

I suggest building your own spreadsheet (or using a template, there are a lot on the internet). Then find a way to download your historic trade data into the sheet, ideally through some kind of Excel/API integration. Having your own spreadsheet means you can tweak it, add whatever performance...

I've built an Excel Add-in which enables streaming and retrieval of live prices from IG Index and Yahoo Finance (I'm working on adding other data providers). The Add-in currently provides live and streaming prices to Excel cells via simple formulas such as: =EPF.Yahoo.Price("AAPL")...

Before you speak to any programmers or try to do it yourself, have a think about what your requirements are, for example: 1. On what time-frame would you like it to run? i.e. does it need check the market daily/hourly etc. 2. How resilient does it need to be? What happens if, for some reason...

I know this is a very old thread but I've built an Excel Add-in (Excel Price Feed Add-in) which enables streaming and retrieval of live prices from IG Index. The Add-in currently provides live and streaming prices to Excel cells via simple formulas such as...

I agree, using Excel to automate a system can be problematic. I suggest a custom piece of software running 24/7 with full monitoring/logging etc. Contact me via private message if you would like me to help you.

Hi, I can help you. I am a programmer and have experience of connecting Excel to various brokers, including automating Excel based strategies (via the IG Index API). I also have experience of FIX/Bloomberg and have just started looking at the IB API (for C#). I would probably start by building...

Hi, Andy Sinclair here, just signed up, been lurking for several years! I'm a computer programmer, interested in automated trading, currently building my own automated trading system (for spot FX) and here to help others with technical/programming issues. I can take your trading idea or Excel...