|
PureBytes Links
Trading Reference Links
|
Am sorry for the delayed response. File with graphics enclosed as requested.
R
On 10/31/06, jocz75 <jocz75@xxxxxxxxx> wrote:
>
> Hello Rakesh,
>
> Would you be able to send me the screen shots of how you set up the
> Amibroker database to access data in an Excel spreadsheet?
>
> This would help me very much.
>
> Thanks for any help you can provide.
>
> -John
>
>
> --- 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+software&w2=Real+estate+investment+software&w3=Investment+property+software&w4=Software+support&w5=Real+estate+investment+analysis+software&w6=Investment+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+software&w2=Real+estate+investment+software&w3=Investment+property+software&w4=Software+support&w5=Real+estate+investment+analysis+software&w6=Investment+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=Investment+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+estate+investment+software&w3=Investment+property+software&w4=Software+support&w5=Real+estate+investment+analysis+software&w6=Investment+software&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+management+software&w2=Real+estate+investment+software&w3=Investment+property+software&w4=Software+support&w5=Real+estate+investment+analysis+software&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+estate+investment+software&w3=Investment+property+software&w4=Software+support&w5=Real+estate+investment+analysis+software&w6=Investment+software&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.
> > >
> > >
> > >
> >
>
>
>
>
>
>
> 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.1.409 / Virus Database: 268.13.27/517 - Release Date: 11/3/2006
|