|
PureBytes Links
Trading Reference Links
|
Hello Rakesh,
Could u please send me the the word file. I am trying to connect
excel data to ab but not successful .
Thanks in advance
Regards
-sanjayt
--- In amibroker@xxxxxxxxxxxxxxx, "Rakesh Sahgal" <rakeshsahgal@xxx>
wrote:
>
> This is for those having problems in making Excel talk to AB via
DDE. I have
> been able to solve the problem with the help of our friend Treliff
from the
> group. I can email you the graphics showing the setup screen shots
in a word
> file should you require.
>
> All you have to do is give the cells containing the various fields
names
> which are combos of the field and the ticker. Then in the DDE setup
> dialog/box in AB do the following
>
> 1. Server name should be indicated as - Excel.
>
> 2. Field names are equal to - sheetname(not Excel file name
REPEAT not
> Excel filename just the name of the sheet in the file which is
recieving the
> data) and {ticker} and field name combined with the ticker name in
> Excel e.gsheetname=data and last field=ls therefore in the DDE
dialog
> box the entry
> for last will be data!{ticker}_ls.
>
> 3. Now add the tickers in AB from the Symbol--->New dialogue.
>
> Thats all there is to it.
>
>
> Regards
>
>
> R
>
> ps: Even if there is no data streaming into your worksheet but the
> connection is succesfully established between Excel and AB , the
connection
> status will change from "wait" to "connected" and the connection
will show
> the green colour instead of the yellow.
>
>
>
> ---------- Forwarded message ----------
> From: Rakesh Sahgal <rakeshsahgal@xxx>
> Date: Mar 7, 2006 10:28 AM
> Subject: Re: [amibroker] Re: DDE Server
> To: treliff <treliff@xxx>
>
> THANKS VERY MUCH(caps for added emphasis). Am most grateful for
your kind
> help.
>
>
> Best Regards
>
>
>
> Rakesh Sahgal
>
>
>
> On 3/7/06, treliff <treliff@xxx> wrote:
> >
> > sure.
> >
> > i would do it like this:
> >
> > set up a new AB intraday database acc. to
> >
> > http://www.amibroker.com/dde.html
> >
> > instructions but with my DDE config
> >
> > Name your excel SHEET: "Tickers"
> >
> > In excel find ONE cell where you actually see data flowing in
(quickly
> > updating) from your source and name this CELL: "testcell"
> >
> > In AB enter a symbol called "testcell"
> >
> > That should at least get you connected.
> >
> > Let me know.
> >
> > -treliff
> >
> >
> > *Rakesh Sahgal <rakeshsahgal@xxx >* wrote:
> >
> > Hi Treliff,
> >
> > If it is not a bother can you please email me a screenshot of yr
dde
> > config menu/box from AB?
> >
> > Thanks and Regards
> >
> >
> > Rakesh
> >
> > On 3/5/06, treliff <treliff@xxx> wrote:
> > >
> > > R, if you wish I can email you the DDE configuration box as I
use it.
> > >
> > > The Tickers! part simply refers to the name of the excel sheet
(in my
> > > previous post this was referred to this as Sheetname!). So
should you
> > > name your sheet MySheet then the Last field in the box should
be:
> > >
> > > MySheet!{ticker}
> > >
> > > I'm not sure but it might be that the yellow light turns green
only
> > > when your excel sheet is actually connected to the data source
so
> > > data is flowing in. I'm not sure. I don't know what you have
tried so
> > > far but I'd first make sure that data is updating in excel and
then
> > > try to connect to AB.
> > >
> > >
> > > -treliff
> > >
> > > --- In amibroker@xxxxxxxxxxxxxxx, "rakeshsahgal" <rakeshsahgal@>
> > > wrote:
> > > >
> > > > Hi Treliff,
> > > >
> > > > Thanks for responding.
> > > >
> > > > What is the exact syntax you are using?
> > > >
> > > > A few examples I have come across use the format
> > > > [XLfilename.xls]sheetname!cellname for topic!item.
Instructions
> > > posted
> > > > by you indicate sheetname(filename?)!cellname. I have tried
both
> > > but the
> > > > yellow light just wont turn green. Numerous emails on this
i.e.
> > > using
> > > > Excel as DDE server, to AB support have not elicitied a
response
> > > as yet
> > > > , lets see if they respond. If anyone is aware of a 3rd party
> > > product
> > > > that picks up DDE feed from Excel reliably and without the
headaches
> > > > please be kind enough to post a link. I will spend the money
and
> > > just
> > > > get on with my trading.
> > > >
> > > > Regards
> > > >
> > > >
> > > >
> > > > R
> > > >
> > > > --- In amibroker@xxxxxxxxxxxxxxx , "treliff" <treliff@> wrote:
> > > > >
> > > > > R., it's been awhile since I posted this setup which aims
> > > > > specifically at pulling in bid/ask data, which may not be
what you
> > > > > are looking for. But it should at least get you
communicating with
> > > > > excel.
> > > > >
> > > > >
http://finance.groups.yahoo.com/group/amibroker/message/76038
> > > > >
> > > > > -treliff
> > > > >
> > > > > --- In amibroker@xxxxxxxxxxxxxxx, "rakeshsahgal"
<rakeshsahgal@>
> > > > > wrote:
> > > > > >
> > > > > > Further to my message below I have found a detailed note
on how
> > > to
> > > > > > prep an Excel w/sheet for DDE server use with AB, by Fred
Denys
> > > in
> > > > > > message #82264 . However inspite of following all the
> > > > > > steps/instructions given in the note nothing seems to be
> > > happening.
> > > > > AB
> > > > > > is JUST NOT communicating with EXCEL. Has anyone else
> > > experienced
> > > > > such
> > > > > > hiccups and found a work-around?
> > > > > >
> > > > > > TIA for any input.
> > > > > >
> > > > > > Regards
> > > > > >
> > > > > >
> > > > > >
> > > > > > R
> > > > > >
> > > > > > --- In amibroker@xxxxxxxxxxxxxxx , "Rakesh Sahgal"
> > > <rakeshsahgal@>
> > > > > > wrote:
> > > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > >
> > > > > > > Has anyone used Excel to stream data into AB using the
> > > universal
> > > > > dde
> > > > > > plug-in
> > > > > > > provided with AB? If so can they share how they did it?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > TIA
> > > > > > >
> > > > > > >
> > > > > > > Regards
> > > > > > >
> > > > > > >
> > > > > > > R
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > > --- In amibroker@xxxxxxxxxxxxxxx, "treliff" <treliff@> wrote:
> > > > >
> > > > > R., it's been awhile since I posted this setup which aims
> > > > > specifically at pulling in bid/ask data, which may not be
what you
> > > > > are looking for. But it should at least get you
communicating with
> > > > > excel.
> > > > >
> > > > >
http://finance.groups.yahoo.com/group/amibroker/message/76038
> > > > >
> > > > > -treliff
> > > > >
> > > > > --- In amibroker@xxxxxxxxxxxxxxx, "rakeshsahgal"
rakeshsahgal@
> > > > > wrote:
> > > > > >
> > > > > > Further to my message below I have found a detailed note
on how
> > > to
> > > > > > prep an Excel w/sheet for DDE server use with AB, by Fred
Denys
> > > in
> > > > > > message #82264 . However inspite of following all the
> > > > > > steps/instructions given in the note nothing seems to be
> > > happening.
> > > > > AB
> > > > > > is JUST NOT communicating with EXCEL. Has anyone else
> > > experienced
> > > > > such
> > > > > > hiccups and found a work-around?
> > > > > >
> > > > > > TIA for any input.
> > > > > >
> > > > > > Regards
> > > > > >
> > > > > >
> > > > > >
> > > > > > R
> > > > > >
> > > > > > --- In amibroker@xxxxxxxxxxxxxxx, "Rakesh Sahgal"
> > > <rakeshsahgal@>
> > > > > > wrote:
> > > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > >
> > > > > > > Has anyone used Excel to stream data into AB using the
> > > universal
> > > > > dde
> > > > > > plug-in
> > > > > > > provided with AB? If so can they share how they did it?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > TIA
> > > > > > >
> > > > > > >
> > > > > > > Regards
> > > > > > >
> > > > > > >
> > > > > > > R
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > 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
> > >
> > >
> > >
> > >
> > >
> > > SPONSORED LINKS
> > > Investment management software<http://groups.yahoo.com/gads?
t=ms&k=Investment+management+software&w1=Investment+management+softwar
e&w2=Real+estate+investment+software&w3=Investment+property+software&w
4=Software+support&w5=Real+estate+investment+analysis+software&w6=Inve
stment+software&c=6&s=200&.sig=_XXUzbE9l5lGlZNcMu4KNQ> Real estate
investment software<http://groups.yahoo.com/gads?
t=ms&k=Real+estate+investment+software&w1=Investment+management+softwa
re&w2=Real+estate+investment+software&w3=Investment+property+software&
w4=Software+support&w5=Real+estate+investment+analysis+software&w6=Inv
estment+software&c=6&s=200&.sig=5_sgDczz3ArKGMtJ9tFSJA> Investment
property software<http://groups.yahoo.com/gads?
t=ms&k=Investment+property+software&w1=Investment+management+software&
w2=Real+estate+investment+software&w3=Investment+property+software&w4=
Software+support&w5=Real+estate+investment+analysis+software&w6=Invest
ment+software&c=6&s=200&.sig=_N6zcwefgp4eg5n6oX5WZw> Software
> > > support<http://groups.yahoo.com/gads?
t=ms&k=Software+support&w1=Investment+management+software&w2=Real+esta
te+investment+software&w3=Investment+property+software&w4=Software+sup
port&w5=Real+estate+investment+analysis+software&w6=Investment+softwar
e&c=6&s=200&.sig=MJ2jP31F3n64RDZkDadU8w> Real estate investment
analysis software<http://groups.yahoo.com/gads?
t=ms&k=Real+estate+investment+analysis+software&w1=Investment+manageme
nt+software&w2=Real+estate+investment+software&w3=Investment+property+
software&w4=Software+support&w5=Real+estate+investment+analysis+softwa
re&w6=Investment+software&c=6&s=200&.sig=GmF8PlAJASx0wrSaX5-Zlw>
Investment software<http://groups.yahoo.com/gads?
t=ms&k=Investment+software&w1=Investment+management+software&w2=Real+e
state+investment+software&w3=Investment+property+software&w4=Software+
support&w5=Real+estate+investment+analysis+software&w6=Investment+soft
ware&c=6&s=200&.sig=aMgGsKT4w29dMAYUzQUKzg>
> > > ------------------------------
> > > YAHOO! GROUPS LINKS
> > >
> > >
> > > - Visit your
group "amibroker<http://groups.yahoo.com/group/amibroker>"
> > > on the web.
> > >
> > > - To unsubscribe from this group, send an email to:
> > > amibroker-unsubscribe@xxxxxxxxxxxxxxx<amibroker-
unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
> > >
> > > - Your use of Yahoo! Groups is subject to the Yahoo! Terms
of
> > > Service <http://docs.yahoo.com/info/terms/>.
> > >
> > >
> > > ------------------------------
> > >
> >
> >
> > ------------------------------
> > Yahoo! Mail
> > Use
Photomail<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=38867/*http:
//photomail.mail.yahoo.com>to share photos without annoying
attachments.
> >
> >
> >
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/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/
|