Referencing “Opt Exp” time period in Scan


Category:
0
0

I am trying to scan for stocks whose current closing price is sitting above the Pivot Point provided in WoodiesPivots for the Opt Exp timeframe. I’m aware of the limitations of the thinkorswim scanner when it comes to secondary aggregations, but the complete inability to use timeframes higher than the monthly seems to make it impossible to accomplish the desired task.

Is there a workaround for this?

Marked as spam
Posted by (Questions: 1, Answers: 1)
Asked on February 19, 2021 9:23 pm
187 views
0
Private answer

Within the WoodiesPivots study included with Thinkorswim there is a user input named "time frame". Among the list of available "time frames" is one for "OPT EXP". This causes the pivot levels to be computed based on the expiration dates of the standard monthly options for all stocks. There is no equivalent time frame available for custom scans. Which you have already observed.

There is no way simple way to work around this limitation. There may be a very complex way to solve this. The only way to go about this would be to revise the code from the WoodiesPivots study to compute the levels from a daily time frame. This would require the use of some very complex code to compute expiration Friday. Then the code would need to use several recursive variables to keep track of the key values from each options expiration period and compute the values of each level from those recursive variables.

Not even sure if this is possible, but I have laid out the core challenges that must be conquered in order for this to even have a chance at working.

All of this is light-years beyond the scope of what I can accomplish in the brief 15 min I allow for providing free solutions in the Q&A Forum.

Marked as spam
Posted by (Questions: 37, Answers: 4118)
Answered on February 20, 2021 9:01 am
0
I figured as much. Would it be appropriate to ask here how much you would charge if you were to accept such a job?
( at February 20, 2021 4:06 pm)
0
Check the About page on this webpage for details. You will find that in the menu at the top of the website. There you will find a description of the services we offer, our rates and terms of service. You will find that we do not provide price estimates or quotes.
( at February 20, 2021 9:58 pm)