|
PureBytes Links
Trading Reference Links
|
I agree Fred, I got everything to work except the volume. Maybe
someone can show us what we are doing wrong. But anyway thanks for
your help. This did it as far as streaming data. Now if I could
figure out a way to use daily data already in a static excel sheet it
would be great.
Thanks
Rusty
--- In amibroker@xxxxxxxxxxxxxxx, "fred" <f.denys@xxxx> wrote:
> To create an Excel dde link with AB do the following:
>
> 1) Make an Excel worksheet with the name "Data" (or whatever you
wish)
> 2) In this Excel "Data" sheet all your "streaming" data (close,
volume etc)
> should be collected from your broker or internet etc
> 3) Now "Name" the cells which contain the data you wish to send to
AB, for
> instance if you wish to send "IBM" "Last Price" and "Volume" data
to AB:
>
> a) Name cell containing "IBM" last (current) price for
instance "IBM_LAST"
> b) Do the same for cell "IBM" volume and name respective
cell "IBM_VOL"
> Note: To name a cell put cursor on the cell and select in Menu:
Insert >
> Name > Define and enter "IBM_Last"
>
> Now in your AB database settings enter as "DDE Server" : "Excel"
> Under "Last" enter "Data{Ticker}_LAST" (Data stands for the Excel
sheet
> "Data", so change if required)
> Under "Volume" (or "Last Size") enter Data{Ticker}_VOL
> (Note: I believe there is a bug in the AB-dde application...if that
will not
> work try the "last_size" fielld instead)
> I cannot make it work in my application under "volume" field.
> Hope this helps,
>
> Fred
>
>
>
>
>
>
>
>
>
> ----- Original Message -----
> From: "iascool" <sai20_2000@xxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Wednesday, May 11, 2005 4:29 AM
> Subject: [amibroker] Re: Excel DDE PLugin
>
>
> > Thanx Rusty
> > Lets see if any solution crops in in future
> >
> > Regards
> > --- In amibroker@xxxxxxxxxxxxxxx, "kandrstocks" <kandrstocks@xxxx>
> > wrote:
> > > I have tried this also just trying to get it to talk to just
> > > Excel alone. Ab doens't even want to connect, but the help file
> > > is real sketchy on what it takes. Does not say what the
variables
> > > need to be as far as format and such. Is open high low close
volume
> > > the column header as in most files? Where is the ticker supposed
> > to
> > > be in the file and things like this. I did email tech support
last
> > > Thursday or Friday and still not even a I am working on it
> > message. I
> > > had to bother them again to even find out if they had started.
The
> > tech
> > > said he would give it to Thomasz sometime and see if he could
get
> > it to
> > > work. We will just wait and see.
> > >
> > > I would think the excel link would be the easiest to get working
> > since
> > > it is a direct working of a Micorsoft product.
> > >
> > > Rusty
> > >
> > > --- In amibroker@xxxxxxxxxxxxxxx, "iascool" <sai20_2000@xxxx>
> > wrote:
> > > > Hi
> > > > My broker supports DDE to excel, I had tried using DDE
Universal
> > > > plugin with excel as server.BUt AB doesnt recognise it. IS
dde
> > with
> > > > server as excel the right way to bring in my brokers data in
AB.
> > Pls
> > > > advise
> > > >
> > > > Regards
> >
> >
> >
> >
> >
> > 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 other support material please check also:
> > http://www.amibroker.com/support.html
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 05-05-
09
> >
> >
------------------------ Yahoo! Groups Sponsor --------------------~-->
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
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 other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|