|
PureBytes Links
Trading Reference Links
|
I export the eod explore results to a spreadsheet that converts this
to a form to copy back to my intraday alert scan afl
I paste to a certain spot on the spreadsheet from the AB report
using concatenate system (actually use & ampersand) pull what I want
into for AFL formula
="Iif(name()=="""&G18&""","&V18&","
="Iif(name()=="""&G19&""","&V19&","
becomes
Iif(name()=="AZA",0.75,
Iif(name()=="CLO",0.56,
hope this helps
On Fri, 25 Mar 2005 18:12:28 -0000, mikelaurataylor
<mikelaurataylor@xxxxxxxxx> wrote:
>
>
> Thanks...but...
>
> The issue is that I don't want to keep months of intraday data in
> one database and I also don't want to run through a large set of
> calculations for every minute or 3 minute timeframe during the day,
> so I was planning on having one database w/ EOD data to calcualte
> Longer terms statistics - and then a seperate database w/ minute by
> minute data to compare to real time. Therefore, I need to calculate
> the stats out of the one system, store them somewhere by ticker,
> then use them during the minute to minute real time scanning.
>
> I think I need to store the stats somewhere and wasn't sure if it
> would be better to write to an external file or use the
> adtocomposite?
>
> Thanks
>
> --- In amibroker@xxxxxxxxxxxxxxx, Terry <MagicTH@xxxx> wrote:
> > Just compute your indicators in code. They will be recomputed on
> the fly
> > and available each day. For example:
> > Vol60 = MA(V,60); //creates array of 60 day volume for every day
> of data.
> >
> > To use yesterday's value today:
> > VolYesterday = ref(Vol60,-1);
> >
> > Hope that's what you wanted.
> >
> > Terry
> >
> > mikelaurataylor wrote:
> >
> > >Hi:
> > >
> > >I'd like to run a scan each evening to find which stocks meet
> > >certain criteria and add them to a watchlist. I've seen the
> > >categoryaddsymbol can do this for me.
> > >
> > >I'd also like to calculate 5 to 10 numbers from historical EOD
> data
> > >for each symbol. As a simplified example, 60 day average
> volume,
> > >90 day average volume, etc. I'd then like to store these EOD
> > >calcualtions to use the next day as part of a daily real-time
> minute
> > >by minute scan of the watchlist that got created.
> > >
> > >What is the best way to store some extra data from an EOD scan
> for
> > >use during the next trading day? I was originally thinking of
> > >writing a small text file for each stock that met the critiera
> and
> > >seperating the fields with a delimiter - but then I noticed the
> > >addtocomposite function and thought I might be able to use this.
> > >
> > >Any suggestions?
> > >
> > >Thanks -
> > >
> > >Mike
> > >
> > >
> > >
> > >
> > >
> > >
> > >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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
>
>
> 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
>
>
>
>
>
--
Cheers
Graham
http://e-wire.net.au/~eb_kavan/
------------------------ Yahoo! Groups Sponsor --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/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/
|