logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
ericsonk  
#1 Posted : Tuesday, May 9, 2006 12:45:34 AM(UTC)
ericsonk

Rank: Newbie

Groups: Registered, Registered Users
Joined: 4/22/2006(UTC)
Posts: 5

I'm trying to apply an indicator to my charts. When I drag it to the chart I see this message: An MSX DLL has incorrectly produced results prior to the first loaded price data record. Referenced DLL: "PowerPivots.NthPivotPrice" Has anyone seen this message before? Can you tell me how to adjust things so that I can use the indicator. I've seen the indicator work on other machines with MetaStock & Power Pivots.... HELP!!!!
hayseed  
#2 Posted : Tuesday, May 9, 2006 1:53:51 AM(UTC)
hayseed

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346

hey krista...... don't get the error here nor can recall seeing it before.... let us know just what your attempting to apply it to, if possible , we can check......... henry knows the most about powerpivots, perhaps he has seen it before......h
ericsonk  
#3 Posted : Tuesday, May 9, 2006 2:13:47 AM(UTC)
ericsonk

Rank: Newbie

Groups: Registered, Registered Users
Joined: 4/22/2006(UTC)
Posts: 5

I'm using an indicator that was passed along to me. It's a COMPRESSION INDICATOR. Here's the code: hp:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,0 , 1); hp1:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,1 , 1); hp2:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,2 , 1); 1hp:= ExtFml( "PowerPivots.NthPivotPrice",-2 ,0 , 1); 1hp1:= ExtFml( "PowerPivots.NthPivotPrice",-2 , 1, 1); 1hp2:= ExtFml( "PowerPivots.NthPivotPrice",-2 ,2 , 1); 2hp:= ExtFml( "PowerPivots.NthPivotPrice",-3 ,0 , 1); 2hp1:= ExtFml( "PowerPivots.NthPivotPrice",-3 , 1, 1); 2hp2:= ExtFml( "PowerPivots.NthPivotPrice",-3 ,2 , 1); x:=If(hp<hp1 AND hp1<hp2 AND (hp1-hp)<hp2-hp1,1,0); x2:=If(1hp<1hp1 AND 1hp1<1hp2 AND (1hp1-1hp)<1hp2-1hp1,2,0); x3:=If(2hp<2hp1 AND 2hp1<2hp2 AND (2hp1-2hp)<2hp2-2hp1,3,0); x+x2+x3 Thanks for taking a look at this!!!!! Krista
hayseed  
#4 Posted : Tuesday, May 9, 2006 3:56:20 AM(UTC)
hayseed

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346

hey krista.... that indicator works for me, with no errors.... applied it to oex, spy, csco and such..... are you applying it to something other than stocks...... if i take out the powerpivots dll from meta, none of the formulas will work, but they give the "missing" error not the error you mentioned... you might check out henrys powerp indicators.... try to use one of those that includes the, hP:=ExtFml("PowerPivots.NthPivotPrice", ..... see if it works or gives the same error..... sorry i couldn't be more help.....let us know..... h
wabbit  
#5 Posted : Tuesday, May 9, 2006 4:08:05 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
This is a programming error that occurs when the .ddl function tries to return a value for a 'bar' before the first bar on the chart. It is specifically mentioned (two or three times) in the MDX guide NOT to do this, so I am surprised it made it through the PP testing routines? I would raise the issue with the programmers (or whom ever you bought the software from) and get them to correct their code. It sounds like the situation is not easy to replicate, so you should provide them with the stock ticker that is causing the problem and all the code for your indicator. A screen shot of the error, or the exact text of error message would also help them out. You might also like to ask them to verify/validate all the conditions to which the following function values are set: a_psResultRec->psResultArray->iFirstValid a_psResultRec->psResultArray->iLastValid as these are the values that are probably causing the trouble in the function. From there it should be easy for the programmers to recompile a corrected version. wabbit :D
henry1224  
#6 Posted : Tuesday, May 9, 2006 3:13:02 PM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
Krista, the error occurs because the formula is looking for at least 3 Major pivots to have occured . Depending on the amount of data loaded on a chart, you will then get these types of errors. try your forrrmula without the major pivot price 2hp:= ExtFml( "PowerPivots.NthPivotPrice",-3 ,0 , 1); 2hp1:= ExtFml( "PowerPivots.NthPivotPrice",-3 , 1, 1); 2hp2:= ExtFml( "PowerPivots.NthPivotPrice",-3 ,2 , 1); Amended formula hp:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,0 , 1); hp1:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,1 , 1); hp2:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,2 , 1); 1hp:= ExtFml( "PowerPivots.NthPivotPrice",-2 ,0 , 1); 1hp1:= ExtFml( "PowerPivots.NthPivotPrice",-2 , 1, 1); 1hp2:= ExtFml( "PowerPivots.NthPivotPrice",-2 ,2 , 1); x:=If(hp<hp1 AND hp1<hp2 AND (hp1-hp)<hp2-hp1,1,0); x2:=If(1hp<1hp1 AND 1hp1<1hp2 AND (1hp1-1hp)<1hp2-1hp1,2,0); x+x2
Users browsing this topic
Guest (Hidden)
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.