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've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"I am very pleased with the DTNIQ system for quotes and news." - Comment from Larry
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"I had always used ******* but for the past 2 weeks have been trying DTN IQFeed. Customer support has been extraordinary. They call just to make sure your problem hasn't recurred." - Comment from Public Forum
"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"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
"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
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - 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
»Forums Index »Product Support »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: 2086
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: Wed May 18, 2022 2:01 AM CFBB v1.2.0 32 ms.
© AderSoftware 2002-2003