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)




"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 just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim
"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
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 21193 total posts (0.01%) in 6,435 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: Mon May 13, 2024 1:21 AM CFBB v1.2.0 6 ms.
© AderSoftware 2002-2003