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)




"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
"For anyone considering using DTN.IQ for a data feed, my experience with the quality of data and the tech support has been very positive." - Comment from Public Forum
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat
"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
"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 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
"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post
"I'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei
"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
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: 2093
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: Sun September 24, 2023 2:42 PM CFBB v1.2.0 11 ms.
© AderSoftware 2002-2003