Some advice & ideas sought....

Mo06

Mo06

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.
 
MONEYAM%20PRICE%20FEED_zpsjx8foxfy.jpg


This is the data feed.
 
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.
 
Mo06 said:
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 .....?
More...

auto-it
also google "web scraper"
 
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.

2w370c2.jpg
 
You must log in or register to reply here.
Back
Top