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

Re: [EquisMetaStock Group] Exploration Results different from Data Window value?



PureBytes Links

Trading Reference Links

Csong

The difference is because you are not using the same number of bars for the exploration as you load
for the chart. My "rule of thumb" is to use 5 times as many bars as the longest EMA for the
exploration (750 bars in this case), and from this you should expect accuracy to about 4 decimal
places.

The situation arises because of the way an exponential moving average is constructed. It never
completely discards any data. Therefore using different lengths of history will give different
results.

Roy

> I have created the below exploration to detect:-
>
> - the 150EMA line moving down trend since the last 60 days & started
> to turn upwards since the last 3 days,
> - CLOSE crossover the 150EMA,
> - yesterday's CLOSE is less than today's CLOSE.
>
> However I noticed that from the exploration results, the 150EMA value
> (ColA) shows a "slightly" different value from that of the Data Window
> if you were to place the mouse pointer on the chart's 150EMA at
> similar date as the exploration. Why is this so?
>
> Any explanation to the above will be much appreciated.
>
> Best regards,
> Csong
>
> &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
>
> 150EMA Breakout
>
> EXPLORATION NOTES
> -----------------
> 150EMA sloping downward & making a reversal upwards AND CLOSE
> =>150EMA. You will see a downward 150EMA line since last 60 days which
> will then turn upwards for 3 days.
>
> CALCULATION PARAMETERS
> -----------------------
> Periodicity: Daily
>
> COLUMN FORMULAS
> ---------------
> ColumnA: Mov(C,150,E)
> ColumnB: Ref(Mov(C,150,E),-3)
> ColumnC: Ref(Mov(C,150,E),-15)
> ColumnD: Ref(Mov(C,150,E),-30)
> ColumnE: Ref(Mov(C,150,E),-45)
> ColumnF: Ref(Mov(C,150,E),-60)
>
> FILTER SOURCE
> -------------
> Filter Enabled: Yes
>
> Formula:
> colA>colB
> AND colB<colC
> AND colC<colD
> AND colD<colF
> AND CLOSE>=Mov(C,150,E)
> AND Ref(C,-1)<Ref(Mov(C,150,E),-1)
>
> &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>




------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/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/