Discussions
»
Product and Service Development
»
Formula Assistance
»
error report in momentum of moving average function
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 4/16/2006(UTC) Posts: 39
|
I get this error in the results report when I try this formula : Mo(Mov(HHV(C,10),70,E),21) in the explorer module for all tested stocks. What do I do wrong?:
Security Name Reason for Rejection Location ABN AMRO Small Companies Netherlands F. Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\A Delta Deelnemingen Fonds Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\D Merril lynch emerging europe fund Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\M Merril Lynch Latin fund A2 Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\M ORANGE FUND Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\O ORANGE SENSE FD Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\O Robeco Emerging Markets Eq. D Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\R Robeco European Midcap Eq. D Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\R Robeco Multimanager Asia-Pacif. Eq. D Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\R **RANDSTAD Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\R **UNIBAIL-RODAMCO Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\U *EUROCOMMERCIAL PROP Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\E *IMTECH Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\I *USG PEOPLE Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\U ABERDEEN_GLOB_EMERGI Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\A BETER BED Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\B COMGEST_GROWTH_INDIA Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\C CTAC-ALIGN Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\C EAST_CAPITAL_BALKAN_ Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\E FIDELITY_INDONESIA_A Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\F FORTIS_OBAM Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\F ISHARES_S&P_LATIN_US Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\I KARDAN Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\K MACINTOSH Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\M MAGELLAN Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\M NYSE EURONEXT Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\N ODIN_FINLAND_ACC_EUR Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\O ODIN_MARITIM_ACC_EUR Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\O ORANGE ORANJE PARTIC Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\O ROBECO_CONSUMER_TREN Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\R SKAGEN_GLOB_ACC_NOK Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\S SKAGEN_KON-TIKI_ACC_ Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data\S TWENTSCHE KABEL HOLDING (TKH) Error in column C: Period value out of valid range in Mov() function. C:\MetaStock Data
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 7/25/2005(UTC) Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi Anton
I'm guessing that you have the Explorer set to use less than 100 records or "Minimum Records". You need 350 bars loaded if you expect your Mov() function to return a really accurate result, so why not try that.
Roy
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 4/16/2006(UTC) Posts: 39
|
Thanks Roy, this did the trick. Somehow the bullet load minimum records was thicked.
Strange thing was that the function Mov(HHV(C,10),70,E) on its own produced no errors. Only after nesting the mov. av. into the momentum formula created a problem in ...the mov. av. .??
It's solved now thanks to your hint
Anton
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
error report in momentum of moving average function
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.