|
PureBytes Links
Trading Reference Links
|
Hi Finn,
Attached is what you want :
I created the DDE link with a VBA macro.
When opening this Worksheet, a dialog box will pop up (There's an auto open
macro).
You only have to fill in the TextBoxes
You can then add some sheets and copy the Last, Change, High, Low, Volume...
into another sheet and make the calculations and graphs you want.
You can recall the dialog box any time by pressing Ctrl +Shift +O.
Because it exists too many Symbols, I did not create a code to write the
Symbol Name automatically, you'll to enter it by hand.
You can use this program either with TS4 (with the OMEGA_SERVER) or TSY2K if
you have DBC (WINROS).
I use Excel 2000.
Hope this helps.
Greetings from Paris,
Philippe
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
philippe_lhermie@xxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
----- Original Message -----
From: Finn Larson <larson@xxxxxx>
To: <omega-list@xxxxxxxxxx>
Sent: Monday, August 23, 1999 5:12 PM
Subject: TS4.0 + DDE -> Excel
Hello Omega users,
I want to use TS4.0 as historical data server
and access this data from Excel via DDE.
I use formula similar to:
=OMEGA_SERVER|LIVECHART!'SP U9,08/23/99,1,3,60'
However this formula is "hardcoded" to SP U9.
I want to replace SP U9 with some kind of
variable and then in Excel script dynamily
change it to ES, DJ, ND etc.
Another idea is to use something like
=OMEGA_SERVER|LIVECHART!$A$1
and then dynamicly change contents of cell á:1
to 'SP U9,08/23/99,1,3,60' or other values.
But all these attempts fails. Excel does not
understand that this is variable or cell reference
and transmit this $A$1 directly to TS server as
instrument name.
Anyone has experience with this? Where am I wrong?
Regards,
Finn
|