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 ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob
"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
"I am very happy I changed. I love the product, but more so I am thrilled with Tech Support. You are knowledgeable, polite, pleasant and professional." - Comment from Pat
"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum
"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
"You are much better than lawyers or the phone company because you answer the phone when I call! I just love your customer service." - Comment from Isreal
"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
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"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.
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
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
»Forums Index »Archive (2017 and earlier) »IQFeed 3rd Party Software Support »Symbol Syntax in Excel
Author Topic: Symbol Syntax in Excel (6 messages, Page 1 of 1)

T333
-Interested User-
Posts: 2
Joined: Oct 1, 2006


Posted: Oct 1, 2006 11:37 AM          Msg. 1 of 6
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

DTN_Steve_S
-DTN Guru-
Posts: 2095
Joined: Nov 21, 2005


Posted: Oct 2, 2006 09:52 AM          Msg. 2 of 6
I am not an "expert" with Excel, but to my knowledge, what you are wanting to do is not possible with Excel/DDE.

As a result, we have provided a sample worksheet In the download for IQFeed that contains a macro which builds the DDE formulas for you without having to enter in each one individually.

T333
-Interested User-
Posts: 2
Joined: Oct 1, 2006


Posted: Oct 2, 2006 12:35 PM          Msg. 3 of 6
Thanks for your reply


T333

optrader
-Interested User-
Posts: 1
Joined: Nov 16, 2006


Posted: Nov 16, 2006 11:03 AM          Msg. 4 of 6
steve,
i'm trying to learn VBA for excel. is there a way i could
see your dde module code thats in your sample worksheet?
ty

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Nov 16, 2006 11:21 AM          Msg. 5 of 6
I will send the information you requested to the email you have on your account.

Thanks for the interest.

TLikins
-Interested User-
Posts: 32
Joined: Jul 11, 2005

Howdy


Posted: Nov 16, 2006 06:48 PM          Msg. 6 of 6
please try this VBA code.


Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells(1, 2).Formula = "=iqlink|" + Cells(1, 1).Value + "!last"
End Sub

Good luck

Thanks for your help!
 

 

Time: Sat June 3, 2023 11:33 PM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003