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

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.

Thanks for your reply


T333

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

I will send the information you requested to the email you have on your account.

Thanks for the interest.

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!