|
PureBytes Links
Trading Reference Links
|
Essence is to NAME your cell the same as the ticker in AB (using the
NAME box in the formula bar, not the cell content/value/formula
etc.).
Just to get things going:
set up a new AB intraday database acc. to
http://www.amibroker.com/dde.html
instructions with this DDE config:
http://img232.imageshack.us/img232/6687/ddeconfigboxmn8.png
Name your excel SHEET: "Tickers" (without quotes)
In excel name your dynamic cell: "testcell" (without quotes)
In AB enter a symbol called "testcell"
That should get you connected (yellow to green) and start plotting
data.
-treliff
--- In amibroker@xxxxxxxxxxxxxxx, "amkh995" <amkh995@xxx> wrote:
>
> HI TO ALL:
> For more than one week so far, I have been trying to setup AB
> database so that AB can plot a dynamic Excel cell (changing in time)
> against time. The cell is found in a DDE Excel worksheet that
> receives market data from a local vendor. The cell is a result of
> some computations and I need to plot its value in AB as time
> progresses.
>
> The cell I am trying to plot its value in time has the following
> form (when pasted in another Excel sheet):
>
> ---------------------------------------------------
> =Excel.Sheet.8|'C:\Documents and Settings\Hatim\My
> Documents\Stocks\StreamingPrices-2.xls'!'!Sheet1!R89C5'
> -----------------------------------------------------
>
> I need to setup the server and the other Ticker/Field spaces in the
> dialog box for Database settings. I have been trying to do so but
> always get the WAIT yellow word in AB.
>
> Could you please help me with this subject. I very much appreciate
> your help.
>
> Kind Regards:
> AMKH995
>
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.13/632 - Release Date: 1/16/2007 4:36 PM
|
