Hi, I am using the below formula in quote centre to get data in excel. Is there a way that instead of referring to ticker, I can reference to cell in excel which has the tickers and it gives me the results.

Instead of writing IBM in formula below, can I reference to a cell which has IBM written and it give me the results.

This can be done in Reuters station, and have been using it but is it possible to do in quote centre also.

=BDDE|TKR!'\\\IBM/LS,LTM'

In Excel you have to use a worksheet event to programmatically write (VBA) the destination cell formula; it cannot read an array in the cell formula for DDE.


Hope this helps.

wabbit

---

"The question of whether a computer can think is no more interesting than the question of whether a submarine can swim."
Edsgar W. Dijkstra

 

MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC & MDK
For custom MetaStock programming : http://www.wabbit.com.au
My SkyPE status :
My SkyPE account : wabbit.com.au

Is there any resource available where I can learn on how to do it.

The VBA help files are the best option, then google.

You want to use the Worksheet_Change event, or similar to initiate the function, then Range(x,y).Formula to write the information to the destination cell.


wabbit

---

"The question of whether a computer can think is no more interesting than the question of whether a submarine can swim."
Edsgar W. Dijkstra

 

MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC & MDK
For custom MetaStock programming : http://www.wabbit.com.au
My SkyPE status :
My SkyPE account : wabbit.com.au

Additionally, Reuters Station has many tools that QuoteCenter does not.  Reuters Station has access to BExtra.XLA which has additional DDE functionality that BTools.XLA does not.

Edit - Just to add, you can write the ticker symbols into a column (i.e. A2, A3, A4 -- be sure to leave A1 empty) and then you can put column references along the 1st row of each other column (i.e. B1, C1, D1).  After that, click onto A1 to make it the active cell, then click Reuters Tools-->Symbol Table.

I know that is not quite what you are asking for, but just wanted to point out there are a few different ways to pull the data into Excel.