Read values from now without excel

josh1

Well-Known Member
#24
Thank. But the code is too complicated and time consuming:

Here is a better way and much easy for coding and work from .net4 onward.


C# Amibroker Script Draft:

- Convert the Export.js to Export.cs

Thank you KelvinHand,

We are trying to develop COM client for RTD server. Since rtd was specifically made for Excel, we will have to replicate the calls made by Excel to obtain data. That is the reason it is a bit complicated.

i am going to try it in Autohotkey_l. The language is easy to learn and lot of help is available.
 
#27
I think you do not need this - CLSID.createFromProgID("NOW.ScripRTD"),
I have already given you the Server Name which is CLSID.
I have also given the six methods/interfaces of the server.

Anyway this should have given you the CLSID - System.out.println("ClassID = " + clsid);

I think it is to be used along with braces. Just Create Instance of the server, 'ServerStart(CallbackObject)' andfollow up with 'ConnectData' method. Return value of ConnectData will be two dimentional array.
Say - ConnectData(TopicID, Strings, GetNewValues)
e.g. - ConnectData(1, nse_fo|NIFTY14JAN6200CE, True)
e.g. - ConnectData(2, nse_fo|NIFTY14JAN6100CE, True)
and see what you get.
I am just back from vacation. I will look into this and get back to you
 
#28
Josh,
Now I am getting following error and when I googling it looks like server is not registered with registry? Do you have any clue about it? thanks

COM object method returns error code: 0x80004002; E_NOINTERFACE
 

josh1

Well-Known Member
#29
Josh,
Now I am getting following error and when I googling it looks like server is not registered with registry? Do you have any clue about it? thanks

COM object method returns error code: 0x80004002; E_NOINTERFACE
When do you get the error? It may mean server not registered or it may also mean that the requested interface is not implemented/found.
 

josh1

Well-Known Member
#30
Hello guys,

I am a PHP coder but have little knowledge about java as well. Would it be possible to implement the same system using PHP?
If no, I would request you to let me help you guys with whatever knowledge I have. May be with backtesting or anything.
Thank you.

P.S. In need of software which can be used with NEST/Pointer to transfer data RT data to amibroker.
P.P.S Apologies if it looks like thread hacking.
Welcome Abhig10,

Any contributions on the subject of the thread are welcome. You may read thru the code and other info I have given in this thread. The code is in C# and VB. It was collected from various sources. I do not know much about PHP or JAVA. However, Bala is comfortable with JAVA.

As I said earlier in this thread, language is not important, result is. Basically Microsoft had developed COM/DCOM technology before .NET. Hence most material is availble in C++. That is the problem. I am not a professional programmar and Learning C++ is a steep curve.

An RTD server is a COM object exposing certain interfaces which are queried by excel to obtain real time streaming quotes. If we have to develop a client it will have to emulate the calls made by excel.

However, I am studing Autohotkey now. It is easy. That forum has lot of info on COM. If you are willing to learning it, you should be able to do it. It is awesome. It will make backfil also easy.
 
Last edited:

Similar threads