Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
I am finally ready to automate a futures strategy and am exploring different ways to do so. I am not a developer and currently use Excel (without macros) for different parts of the strategy. My goal is to eventually be fully black box, knowing that iterating from gray box will most likely be my path.
The variables I'm weighing are:
- Upfront costs
- Time to market
- Degree of independence from 3rd parties
For example, I could hire a developer to get exactly what I need, though the upfront costs and necessity for an ongoing relationship would be significant. On the other hand, I could achieve "gray box status" relatively quickly doing this myself, in Excel.
My question is, what are the LIMITS of Excel? From my research it seems to be something most traders have moved on from. Is this because the tools available to non-coders today are more powerful, or something else? Additionally I'm looking into options with more features than Excel, such as TradeStation, TT's ADL, Sierra Chart's Sheets etc.
I'm trying to weigh all options before committing my time and energy to a course. All perspectives are appreciated.
Regards.
Can you help answer these questions from other members on NexusFi?
I have used Excel for basic data crunching quite a bit, using no macros or VB. I've used a bit of pivot tables, creating dashboards, etc. But I have never connected it to any live market data, and am far from an excel expert.
I think as to your question... it just depends on what you're trying to do? If you are just crunching basic info using OHLC prices, or something pretty simple, Excel can be fine.
But if you're trying to connect excell to live data, that might be more of an issue, and it may be easier to just use a typical trading platform.
SO, I think you might need to provide a bit more info on what you're trying to do.
So you may or may not know that it is fairly easy to have real time equity, option and futures data populate into an excel spreadsheet, by using the export to Excel from TOS and Pasting into a blank Excel spread sheet.
The way it was explained to …
apparently the data that are imported into excel are not realtime so I am not sure you can actually trade in realtime using excel.
If you like to trade through excel I suggest to look into sierrachart, that uses a spreadsheet system to implement trades, it doesn't need any programming knowldge.
I've quite a bit of experience with excel and google sheets, there was a time not too long ago where I had programs running to scrape option chain data from NSE website to do my own calculations on it.
But to keep long story short so you can get more precise answer to your question >>
While excel and google sheets are good for moderate data processing, maybe a good EOD tool or a tool if you are okay with delayed processing. But its a quite a headache if you make it interact with live data, be it exporting directly from platform or use API to route orders to platform from excel.
And no jokes, I've spent weeks figuring out what went wrong and how to solve it. But maybe I had too much of a complicated system on excel.
Now compare that to a trading platform like Trading view, I can achieve much more with much less effort.
I think technology has just moved on, I feel its just case of much better options being out there and ease of access for non-programmers and data scientists that has changed fortunes for excel for worst.
Choice is still yours though, till the day you feel you need something better than excel, you are perfectly fine even if you use excel. Trading is very private affair.
Back around 2008 (or so), I used Excel with eSignal. Bringing in real-time, streaming data to Excel was no problem. Automating order entry/exit was no problem. But you had to be able to code in VBA to pull it off. Biggest negative was the price. It cost a small fortune (to me, anyway). I think I was paying something like $120/month for real-time future's data and something like an additional $60/month to use their API. Not sure what they charge today (probably much less due to the additional competition), but knowing eSignal, it still probably won't be cheap.
I would never go that route again, though. As far as I'm concerned, the best bang-for-the-buck is Sierra Chart/ACSIL... especially if it's a complicated trading strategy (not that you can't build anything complicated in Excel).
Thank you all for your responses! I've been looking into this for over a week and information overload is happening.
I am indeed planning on running functions on streaming data and sending orders directly from Excel. Sending orders from Excel is possible, though the process is different depending on the provider one is using. Given I'd be running this strategy on multiple products it seems like Excel issues could arise quickly, and be a pain to find and deal with if they can be addressed at all. Currently I'm testing out Rithmic/Excel on their free trial.
Support for Excel so far seems soft, with most saying look elsewhere (+2 for Sierra Chart).
I would like to add that many systematic traders are not programmers themselves. Most platforms offer pseudo programming languages that are very easy to understand.
Concerning programming, I think that people that have never programmed in their life, think it's a big deal....it's not.
I am a telecom engineer and I programmed in Java and C in the past. Basically you take 2 or 3 courses at university and you learn. It is really easy, so you can learn it in a couple of months. Basically it's trial and error.
So don't be too afraid to learn. I learnt when there was no YouTube and not many online resources, nowadays it will be easier and faster.
Edit: I think it is excellent for any trading task, automated or not, but it does involve some definite programming, and there is a learning curve for the platform and its programming requirements.
When one door closes, another opens.
-- Cervantes, Don Quixote