Read values from now without excel

B

balasoft80

Active Member
#1
#1
Hi All,

Below is the command which reads value from now to excel. Is there any way we can read this value without excel using VB script or something like that. Because using excel hangs some times. thanks in advance

=RTD("now.scriprtd",,"MktWatch","nse_cm|AUROPHARMA-EQ","Last Traded Price")
 
Last edited:
josh1

josh1

Well-Known Member
#2
#2
balasoft80 said:
Hi All,

Below is the command which reads value from now to excel. Is there any way we can read this value without excel using VB script or something like that. Because using excel hangs some times. thanks in advance

=RTD("now.scriprtd",,"MktWatch","nse_cm|AUROPHARMA-EQ","Last Traded Price")
Click to expand...
Yes. However, it is difficult. You will have to create RTD client in some language.
 
josh1

josh1

Well-Known Member
#6
#6
Server name is this - {A04A3240-D051-4b4c-B004-CA92151F11E5}

Use java if you want to. Means are not important but the result is.
We can create an RTD client that collects streaming quotes and push into Ami. There can be two ways to do this.
1. Accumulate quotes for multiple scrips in single Array. Save them in batches of (say 20) into ASCII files. Thereafter import into Ami asynchronusly. This will ensure that no quotes are missed. Ami is quite efficient at importing ASCII files.
2. Store quotes in multiple Arrays and push into Ami when quotes in array reach threshold.
Both can be done thru COM calls.
 
B

balasoft80

Active Member
#7
#7
josh1 said:
Server name is this - {A04A3240-D051-4b4c-B004-CA92151F11E5}

Use java if you want to. Means are not important but the result is.
We can create an RTD client that collects streaming quotes and push into Ami. There can be two ways to do this.
1. Accumulate quotes for multiple scrips in single Array. Save them in batches of (say 20) into ASCII files. Thereafter import into Ami asynchronusly. This will ensure that no quotes are missed. Ami is quite efficient at importing ASCII files.
2. Store quotes in multiple Arrays and push into Ami when quotes in array reach threshold.
Both can be done thru COM calls.
Click to expand...
Thanks Josh. I will check it and get back to you
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
R How much commission is reasonable for no spread account? General Trading & Investing Chat 0
R Put calendar spread. Options 0
R What is bid spread in Forex trading? Forex 5
S A book about Level 2 and Reading the tape Books 1
B AFL for read the Bolinger Lower and Higher band values AmiBroker 4

Similar threads