|
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 -----
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
<[EMAIL PROTECTED] > 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 [email protected] ,
"Rakesh Sahgal" <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
>
Date: Mar 7, 2006 10:28 AM
> Subject: Re: [amibroker] Re: DDE
Server
> To: treliff <[EMAIL PROTECTED]>
>
> THANKS VERY
MUCH(caps for added emphasis). Am most grateful for your
kind
>
help.
>
>
> Best Regards
>
>
>
>
Rakesh Sahgal
>
>
>
> On 3/7/06, treliff
<[EMAIL PROTECTED]> 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
<[EMAIL PROTECTED] >* 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
<[EMAIL PROTECTED]> 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 [email protected],
"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 [email protected] ,
"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 [email protected],
"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 [email protected] ,
"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 [email protected],
"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 [email protected],
"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 [email protected],
"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:
> > >
[EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
> >
> > > - 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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*>
Your email settings:
Individual Email |
Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo!
ID required)
<*> To change settings via
email:
mailto:
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*>
To unsubscribe from this group, send an email
to:
[EMAIL PROTECTED]
<*>
Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
__._,_.___
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
![]()
SPONSORED LINKS
__,_._,___
|
