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)




"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"I started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike
"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
"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
"I will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
"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
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart
"I "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum
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 21199 total posts (0.01%) in 6,427 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: Sun May 5, 2024 6:08 PM CFBB v1.2.0 8 ms.
© AderSoftware 2002-2003