[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: DDE - Excel



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
>
>