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: 2091
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: Mon July 15, 2024 3:06 PM CFBB v1.2.0 11 ms.
© AderSoftware 2002-2003