|
PureBytes Links
Trading Reference Links
|
Tomasz, thanks for your ref. to ODBC plugin, I have to look into
this, am unfamiliar with this right now.
Re. DDE the reason for using Excel in between External Data and
AmiBroker (by 2 DDE links) is that by connecting directly:
External Data ->>DDE (plugin)->>AmiBroker
there would be no room for bid and ask to be "stored and
plotted" as arrays (forgive my amateur speak, I am no programmer).
The only price field in the DDE plugin configuration that is actually
stored is "Last" (next to Volume, I think).
I cannot use any of the other fields like Open, High etc, to pull in
bid and ask because these are not stored tick-wise: I need "tick" bid
and ask plots for the complete current day from market open
(IB's "snapshot ticks" are ok for me).
I don't think this is a DDE plugin limitation; it is just not part of
the program's structure to provide space for bid and ask to be
stored. For that reason GetRTData also won't do the job for me.
Consequently the only way to do this is to define bid and ask as
separate tickers. And that is where, until now, Excel seems
indispensable.
If I'm missing something and you have any additional advice for me
this would be highly appreciated. Thanks very much.
-treliff
--- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@xxx>
wrote:
>
>
> Hello,
>
> For your specific case.
>
> Use IB plugin
> http://www.amibroker.com/ib.html
>
> and GetRTData
> http://www.amibroker.com/f?getrtdata
>
> GetRTData("Bid") GetRTData("Ask")
>
> Also orignal enquiry was not about storing data but
> about communication.
> If you want to store any "extra" data it is much better
> choice to use SQL database and ODBC plugin to read data
> from SQL database:
> http://www.amibroker.com/odbc.html
>
> Excel is NOT a database management system.
>
> For general case:
> if you pull data from external source to EXCEL via DDE
> and then from Excel to AmiBroker it makes no sense
> because you can connect to external source directly.
>
> Look:
>
> Instead of
>
> External Data ->>DDE->> EXCEL ->>DDE (plugin)->> AmiBroker
>
> Just take shorter path:
>
> External Data ->>DDE (plugin)->>AmiBroker
>
> Best regards,
> Tomasz Janeczko
> amibroker.com
> ----- Original Message -----
> From: "treliff" <treliff@xxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Wednesday, January 10, 2007 10:03 PM
> Subject: [amibroker] Re: DDE Excel
>
>
> > --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@>
> > wrote:
> >
> >> Frankly I see NO reason connecting via excel.
> >
> >
> > TJ, a very bold statement indeed!
> >
> > Can you back that up and explain how to store bid/ask data in AB
> > without using Excel?
> >
> > The way I've been doing this for years is to create separate
tickers
> > IBM_bid, IBM_ask etc. and use DDE to:
> >
> > - pull provider data into Excel (I'm using IB)
> > - then pull Excel data into AB
> >
> > If there's any way to cut out Excel I'd be very happy to hear.
> >
> > Thanks very much for an excel-less solution!
> >
> > -treliff
> >
> >
> >
> > Please note that this group is for discussion between users only.
> >
> > To get support from AmiBroker please send an e-mail directly to
> > SUPPORT {at} amibroker.com
> >
> > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> > http://www.amibroker.com/devlog/
> >
> > For other support material please check also:
> > http://www.amibroker.com/support.html
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.9/622 - Release Date: 1/10/2007 2:52 PM
|