Technical Indicator data feed straight into Excel?

Ya gotta watch out using excel for trading because it's easy to overload it.
Too many formulas, too much data and the software can freeze and/or get buggy.

Also live data, trading futures, hmmmm, this could get very difficult, perhaps someone can comment, is it possible to trade futures live with Excel, I've not heard on ET anyone doing it.
 
One other suggestion, at the bottom of ET page is list of sponsored ET vendors, perhaps email them and ask if they have suggestions.
Now Norgate data, there's a guy there by name of Richard, been in this game forever, he's very helpful, maybe start there..... support@norgatedata.com
 
One other option for you - Refinitiv's Eikon (retail version Xenith is just fine) has had an eye-watering amount of money thrown at it, so it's pretty stable relative to most excel implementations and you can granular to tick data updates if you so wish. Same problem as all the others, you can't call indicator data (some exception apply to stocks) but every raw data field is available, and they've pre-made templates of some basic TA indicators plus you can import live charts and a lot of other fancy-ass stuff
 
Think it just depends what you're up to. As a non-coder I can whip through a lot in Excel that would take me aeons to commission/test/refine, and some data that I can only access in a useful format via a data call so does the job.
 
I love Excel but it is just not designed for this. There is just really no reason to not use Pandas in python and/or a Jupyter notebook.

Pandas was practically designed to handle trading data and is like Excel without a GUI. It can do pivot tables or plot table data, anything you could do in Excel and way more.

I would say Python is easier too than VBA/complicated Excel formulas. The best part though is that chatGPT is the Pandas master. Anything you could want to do in Pandas, chatGPT will basically write the code for you and it will just work.
 
You must log in or register to reply here.
Back
Top