
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!
|