I would avoid Excel (or any proprietary system) at all costs. I have learned this from bitter experience... Python has a lot of powerful scrapping tools. For example, to extract the data in json format use the requests library: req=requests.get(url,headers=headers,params=params) s=req.content The url is your HTML data feed. Convert the HTML to csv format using the Python reader object. You can perform the entire operation in about 5 lines of code.
If you use Excel for order entry and position monitoring then that is silly. Why would anyone want to introduce a potential brick wall in the most important part of trading. If, however, you want to set up customized layouts that help you make better trading decisions for your trade executions, then Excel is hard to beat, especially if you are not a programmer.
If you use Excel you are locking yourself into Windows and Microsoft, which is risky. If you decide switch to Linux for example all your Excel spreadsheets will have to be redone. It is much better to invest your time in developing a system that is durable in the long term. Most of the functionality of Excel is in Office Libre or Open Office...
You are setting yourself up for a *ferocious* Bad Day. "Repent! Repent, Sinner! While there's yet time!" And all that and more......
OK a couple of developments - I have installed Linux on one of my machines and I'm getting up to speed with using Libra Calc. BUT... none of the macros I have spent time refining in Excel works in Libre Calc. Now I am wondering if I can bypass Libre Calc and construct someting in Python (another learning curve, but I was a developer in the City so I can handle that). What I want is simply a customisable front end to display my data feed data in a better format than through a web browser (I use Firefox). I DONT need to enter any data into it or use it to trade (that's running on another machine). Any suggestions....