Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/18/2009(UTC)
Posts: 3
|
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'
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
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 [:D]
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/18/2009(UTC)
Posts: 3
|
Is there any resource available where I can learn on how to do it.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
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 [:D]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
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. 
|
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
