PureBytes Links
Trading Reference Links
|
Hi DonC ,
I think you need to do what you want.
I can do it for you if you send a sample Spread sheet to precise what you
need.
Otherwise, If you're interested I can send you my Excel sheet in which I
added a macro which automatically creates all the DDE links (Last, High,
Low, Bid, Ask etc...) of the symbol you want in the line you want.
Regards,
Philippe
°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°
philippe.lhermie@xxxxxxxxxxx
°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°
----- Original Message -----
From: DonC <countach@xxxxxxxxxxxxxxxx>
To: <omega-list@xxxxxxxxxx>
Sent: Wednesday, November 10, 1999 6:01 PM
Subject: DDE - Excel
> I am creating an Excel spreadsheet as a portfolio tracker.
> I did this a few years ago, but lost the spreadsheet.
>
> I wonder if it is possible to use a cell address in the
> quote formula, so that a symbol could be entered in one
> cell, and that symbol then be inserted into the formulas
> for other cells. I have tried several things but always
> get an error.
>
> The formula is basically:
>
> =OMEGA_SERVER|LIVEQUOTE!'symbol,fieldlist'
>
> Does anyone have an idea how to insert a cell address
> in place of the 'symbol ?
>
> donc
>
>
|