|
PureBytes Links
Trading Reference Links
|
Rekesh - I've found the DDE server running when I shut my machine off and I have to handle it as an exception.
In other words, once called, it does not exit when all programs calling it are shut down and will stay up during a system shut down.
Is there a way to kill it when you no longer need it in APL?
Best regards
Joe
----- Original Message -----
From: Rakesh Sahgal
To: amibroker@xxxxxxxxxxxxxxx
Sent: Friday, November 03, 2006 1:48 AM
Subject: Re: [amibroker] Re: DDE Server
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
|