Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe
"Thank you so much - awesome feed, awesome service!" - Comment from Greg via Email
"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"Just a thank you for the very helpful and prompt assistance and services. You provided me with noticeably superior service in my setup compared to a couple of other options I had looked at." - Comment from John
"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"Excellent datafeed !!!" - Comment from Arely
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"Just a quick one to say I'm very impressed so far :) The documentation for developers is excellent and I've quickly managed to get an app written to do historical downloads. The system is very robust and pretty quick considering the extent of data that's available. The support guys have been very helpful too, in combination with the forums it's been plain sailing so far!" - Comment from Adam
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
Home  Search  Register  Login  Recent Posts
Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
Viewing User Profile for: T333
About Contact
Joined: Oct 1, 2006 11:11 AM
Last Post: Oct 2, 2006 12:35 PM
Last Visit: Oct 3, 2006 03:58 AM
Website:  
Location:
Occupation:
Interests:
AIM:
ICQ:
MSN IM:
Yahoo IM:
Post Statistics
T333 has contributed to 2 posts out of 21191 total posts (0.01%) in 6,424 days (0.00 posts per day).

20 Most recent posts:
IQFeed 3rd Party Software Support » Symbol Syntax in Excel Oct 2, 2006 12:35 PM (Total replies: 5)

Thanks for your reply


T333

IQFeed 3rd Party Software Support » Symbol Syntax in Excel Oct 1, 2006 11:37 AM (Total replies: 5)

I would be grateful if someone could help me with the correct syntax to use when using the sample DDE spreadsheet. I wish to be able to receive a quote in one field by referencing the symbol name in another field.

So for example if I have the symbol MERQ in the A1 position of the DDE spreadsheet and wish to receive a quote for this in position B1 for the last traded price I have not been able to get this to work. I know that you would use the syntax

=IQLink|MERQ!last

to get this for just the one symbol but I would like to be able to quickly type in another symbol such as AMGN and not have to type in the whole line above. I have tried using something like
=IQLink|'A1'!last and also =IQLink|&'A1'&!last and also =IQLink|"A1"!last as well as others but I cannot get it to work.

Any advice would be most welcome

Thanks


T333


Time: Thu May 2, 2024 2:27 PM CFBB v1.2.0 12 ms.
© AderSoftware 2002-2003