[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] Constant price from a specific date



PureBytes Links

Trading Reference Links

> It provides a perfectly aligned rate of change (absolutely no drift) 
> for the last one year of trading (updated daily).  Furthermore,
> implementing MetaStock's "Security" function now allows MetaStock to 
> display charts of as many indexes and ETFs as I wish all in one
> chart with values that are comparable to one another (apples to
> apples).

There is just one snag:

If the charts you are comparing have different last data dates, the 
whole comparison(s) will be out of step.  This can happen often with 
security/index Relative Strength Comparative studies.


jose '-)
http://www.metastocktools.com



--- In equismetastock@xxxxxxxxxxxxxxx, "Larry Carhartt" <lc@xxxx> 
wrote:
> Roy,
>  
> Thank you again for the code on finding the price of a specific time 
period
> ago and setting it as a constant.  I added one more simple line of 
code so
> this is what it looks like:
>  
> {Price 1 Year OLD}
> Sm:=LastValue(Month());
> Sd:=LastValue(DayOfMonth());
> Sy:=LastValue(Year()-1);
> Start:=(DayOfMonth()>=Sd AND Month()=Sm AND
> Year()=Sy) OR Year()>Sy OR (Year()=Sy AND Month()>Sm);
> Date:=Cum(Start)=1; {Date}
> YearAgoPx:=LastValue(ValueWhen(1,Date,C));
>  
> ((C-YearAgoPx)/YearAgoPx)*100
>  
> It provides a perfectly aligned rate of change (absolutely no drift) 
for the
> last one year of trading (updated daily).  Furthermore, implementing
> MetaStock's "Security" function now allows MetaStock to display 
charts of as
> many indexes and ETFs as I wish all in one chart with values that 
are
> comparable to one another (apples to apples).  Prior to the one year 
ago
> date, prices are still comparable, the one year ago price being zero 
for any
> index or ETF compared (of course this would work with individual 
securities
> also).  This comparability opens up numerous possibilities.
>  
> I try to put as much calculation into MetaStock as possible (as 
opposed to
> my plug-in) and your code did the trick in this case.  You never 
cease to
> amaze me.  I will make certain that you (and your site) receive 
credit for
> your assistance on my web site.  Thank you again.
>  
>  
> Best,
> 
> Larry Carhartt
> 
> MasterDATA
> The Only Source for Index & ETF Composite/Breadth Reports, Charts & 
Data
>  <http://www.masterdata.com/> www.MasterDATA.com
>  <mailto:lc@x...> lc@xxxx
> 818-701-6686
>  
> 
> -----Original Message-----
> From: equismetastock@xxxxxxxxxxxxxxx [mailto:
equismetastock@xxxxxxxxxxxxxxx]
> On Behalf Of Richard Dale
> Sent: Sunday, September 18, 2005 6:39 PM
> To: equismetastock@xxxxxxxxxxxxxxx
> Subject: RE: [EquisMetaStock Group] Constant price from a specific 
date
> 
> 
> Here it is in a format that recognises 1 year ago.  The compare 
statement in
> the valuewhen also resolves the problem of one year ago falling on a
> non-trading day.  
>  
> {do not change these}
> daynum := Cum(1);
> totaldays := LastValue(daynum);
> fulldate := Year()+Month()/12+DayOfMonth()/365;
> 
> 
> {config section}
> constantneeded := C;
> dateneeded := LastValue(fulldate)-1;
> 
> priceneeded := ValueWhen(1,yearagodate > Ref(fulldate,-1) AND 
yearagodate <=
> fulldate,constantneeded );
>  
> {Plot priceneeded}
> priceneeded;
>  
> Best regards,
> Richard Dale.
> Norgate Investor Services
> - Premium quality Stock, Futures and Foreign Exchange Data for
>   markets in Australia, Asia, Canada, Europe, UK & USA -
> www.premiumdata.net <http://www.premiumdata.net/>  
> 
>  
> 
>   _____  
> 
> From: Larry Carhartt [mailto:lc@x...] 
> Sent: Monday, 19 September 2005 8:11 AM
> To: equismetastock@xxxxxxxxxxxxxxx
> Subject: [EquisMetaStock Group] Constant price from a specific date
> 
> 
> Is there a way to set a constant value representing the price of a 
specific
> date?  For instance, ref(c,-250) would give you the close price from
> approximately one year ago.  With this formula, when MetaStock 
calculates
> the indicator, the close of one year ago will be calculated on each 
bar of
> data.  What I need is the price one year ago from today and that 
price
> remains a constant for all previous bars to use in a calculation.  I 
realize
> I could enter the constant manually, but that does not allow for 
automation
> and certainly leaves room for error.
>  
> Can this be done in MetaStock?  I hope I am being clear on what I 
need.





------------------------ 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/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/