Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/16/2005(UTC) Posts: 93 Location: Maryland,US
|
I see many code with powerpivots+, but so far everything I have seen is for experts. Has anyone used powerpivots+ external formulas in explorations. With the time lag it takes the pivot to flag it is not straight forward because it never flags on the day the exploration is ran. I can put the formula in a SUM function of 4 days to get the flag {sum(extfml("powerpivots.pivots")=1,4)=1} or do something with the value of BarsSinceNthPivot, but I was wondering if anyone has done other things that work.
I am basically looking to add a check for minor pivot to an eploration.
Thanks
vm
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 9/26/2005(UTC) Posts: 185 Location: Brazil
|
Try this:
Column A
Cross(CLOSE,ExtFml("PowerPivots.NthPivotPrice", 1,0,1))
Column B
Cross(CLOSE,ExtFml("PowerPivots.NthPivotPrice", -1,0,1))
Filtro:
Cross(CLOSE,ExtFml("PowerPivots.NthPivotPrice", 1,0,1))
OR
Cross(CLOSE,ExtFml("PowerPivots.NthPivotPrice", -1,0,1))
Hope this answers your question. :)
regards,
Bulli
|
|
|
|
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)
|
Vaughn,
If you take the Long entry signal and the short entry signal into an exploration, it will then give you te exact buy and sell signals from that expert
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/16/2005(UTC) Posts: 93 Location: Maryland,US
|
Excellent, I will check both out.
Thanks
vm
|
|
|
|
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.