Have a problem/project and maybe somebody can give me some ideas. Right now, I have an Excel spreadsheet, and use links to MT4 via DDE to update it in real time with stock price data. What I want is to replicate this BUT using my subscription stocks feed as a data source, and be able to include calculated cells based on the prices from the feed. The feed is HTML based. What I'm wondering is, is there a way to scrape this data in real time...? I'm a pretty decent VBA programmer (previous life was doing this in the City of London). Years ago I built a little app using a 3rd part add on to VB called 'Data Widgets' - that's the sort of interface I want, just a simple grid of cells showing OHLV data PLUS a few calculted values which I will add. https://www.componentsource.com/product/data-widgets So any ideas .....?
I should have added that I don't need an excel based solution - just something I can run & will show me live data from the data feed, in a nice grid format.
"I'm not understanding how you don't have what you want in front of you." Well, I have the live price feed, but what I really want is the data... PLUS several calculated values, based on the price data. Short of getting my data feed provider to modify their data to include these values, I have to calculate them myself. I can do in this Excel via MT4 & DDE, but my current data provider doesn't provide an MT4 platform.
So, if I read this correctly, you *have* a feed, but it's html. 1) I *believe* Excel is perfectly happy accepting live html (or xml). I use OpenOffice, so I don't know the particulars, but my memory says you're good to go. 2) FWIW, OpenOffice is perfectly happy accepting (real-time) xml, and an instance of Calc would be much smaller load on your resources, *and* more stable. If your needs are little more than a couple of prices and some quick/dirty calculations, you would probably be up*running with OpenOffice in no time.
You can do about anything with auto-it. I once had auto-it doing about 40 percent of my job on one contract.
It all depends on what you want to see, and how much customization you want for your trading approach. I think it is hard to beat Excel for almost anything to do with customizing trading data, so I do not look elsewhere.