Hello everybody, I really really hope that someone could help me with this.

The problem is, I am using maybank online trading platform which display a real time stock price data feed from the data provider via an .ocx file.

I wanted to import this live stock data into excel so that I could manipulate with the price real-timely and not just had them displayed in the online platform only.

How can I do it?

I hope I had make myself clear and hereby express my gazillion thanks in advance~

you mean a software demanding you to convert .ocx to excel or you want an idea on how to program that software?

Thanks for your reply~

I mean isn't that excel can import external data into the spreadsheet?

I want to know how to import the live data from maybank platform into excel.

So means i want an idea on how to program that software~

This post has been edited by swlim9999: Sep 24 2012, 01:32 PM

ocx is an activex control.

depending on what platform, you need to create a separate standalone application which pulls data out from OCX into some format such as xml or just raw data in table row column..

and use excel to read the data as datasource.

you can even write that application so that it output to excel file / csv ..

something for you to start
http://stackoverflow.com/questions/2881103...ows-application

Thanks...but the link...is not actually making any sense to me now...do you mean that excel can't directly use the ocx file to import the data?

What I am trying to achieve is make the excel use the .ocx file to get and display data in spreadsheet just like my internet explorer use the same .ocx file to get and display data in internet explorer.

An OCX is basically a program file. It is not a data file that you can open using Excel. Unless it has built in function that can export data to Excel, there's nothing that you can do to get the data out.

you need an actual documentation of the OCX file and how to OCX file works.

depending on which language you are using, and hopefully you are using something like .net, try adding the OCX as reference.. if there's an error, try registering the OCX file via the link i gave it to you.

oh, If you're able to extract the data from ocx file then you can re-output the data into a csv file. Microsoft excel can read csv file, it became a spreadsheet like excel file. Google csv for more information, it's very simple.