Trying to determine if an option is overvalued or undervalued.

[ezrollin]

I'm trying to figure out if an option is overvalued or undervalued based on past prices and especially VS the stock's price.
I doubt I can add in a stocks price to a script that is used on an option chain screen.

So I'm just trying to start off looking at an average but I get errors like NaN.

def averagePrice = (close[5] + close[4] + close[3] + close[2] + close[1]) / 5.0;
plot data = averagePrice;

Is it factoring in weekend data so I need to check to make sure its NaN?
Thanks

 

[halcyonguy]

I'm trying to figure out if an option is overvalued or undervalued based on past prices and especially VS the stock's price.
I doubt I can add in a stocks price to a script that is used on an option chain screen.

So I'm just trying to start off looking at an average but I get errors like NaN.

def averagePrice = (close[5] + close[4] + close[3] + close[2] + close[1]) / 5.0;
plot data = averagePrice;

Is it factoring in weekend data so I need to check to make sure its NaN?
Thanks

sorry, i don't have an answer.

there seems to be NAN errors for options data with volume errors or low numbers for open interest.

i tried a couple things , but wasn't able to trap and ignore the errors.
tested after market closed.

#cu10_test

# https://usethinkscript.com/threads/trying-to-determine-if-an-option-is-overvalued-or-undervalued.15847/
#Trying to determine if an option is overvalued or undervalued.
#ezrollin  Start dateToday at 7:23 AM

#I'm trying to figure out if an option is overvalued or undervalued based on past prices and especially VS the stock's price.
#I doubt I can add in a stocks price to a script that is used on an option chain screen.

#So I'm just trying to start off looking at an average but I get errors like NaN.


#def averagePrice = (close[5] + close[4] + close[3] + close[2] + close[1]) / 5.0;
#plot data = averagePrice;
#plot data = if isnan(averagePrice) then 0 else averagePrice;


# doesnt work.  plot still has NAN's
#def c1 = if isnan(close[1]) then 0 else close[1];
#def c2 = if isnan(close[2]) then 0 else close[2];
#def c3 = if isnan(close[3]) then 0 else close[3];
#def c4 = if isnan(close[4]) then 0 else close[4];
#def c5 = if isnan(close[5]) then 0 else close[5];

# doesnt work.  plot still has NAN's
def c1 = if isnan(volume[1]) then 0 else close[1];
def c2 = if isnan(volume[2]) then 0 else close[2];
def c3 = if isnan(volume[3]) then 0 else close[3];
def c4 = if isnan(volume[4]) then 0 else close[4];
def c5 = if isnan(volume[5]) then 0 else close[5];

def averagePrice = (c1 + c2 + c3 + c4 + c5) / 5;
plot data = averagePrice;
#

stock: AXP

 

[Trader4TOS]

sorry, i don't have an answer.

there seems to be NAN errors for options data with volume errors or low numbers for open interest.

i tried a couple things , but wasn't able to trap and ignore the errors.
tested after market closed.

#cu10_test

# https://usethinkscript.com/threads/trying-to-determine-if-an-option-is-overvalued-or-undervalued.15847/
#Trying to determine if an option is overvalued or undervalued.
#ezrollin  Start dateToday at 7:23 AM

#I'm trying to figure out if an option is overvalued or undervalued based on past prices and especially VS the stock's price.
#I doubt I can add in a stocks price to a script that is used on an option chain screen.

#So I'm just trying to start off looking at an average but I get errors like NaN.


#def averagePrice = (close[5] + close[4] + close[3] + close[2] + close[1]) / 5.0;
#plot data = averagePrice;
#plot data = if isnan(averagePrice) then 0 else averagePrice;


# doesnt work.  plot still has NAN's
#def c1 = if isnan(close[1]) then 0 else close[1];
#def c2 = if isnan(close[2]) then 0 else close[2];
#def c3 = if isnan(close[3]) then 0 else close[3];
#def c4 = if isnan(close[4]) then 0 else close[4];
#def c5 = if isnan(close[5]) then 0 else close[5];

# doesnt work.  plot still has NAN's
def c1 = if isnan(volume[1]) then 0 else close[1];
def c2 = if isnan(volume[2]) then 0 else close[2];
def c3 = if isnan(volume[3]) then 0 else close[3];
def c4 = if isnan(volume[4]) then 0 else close[4];
def c5 = if isnan(volume[5]) then 0 else close[5];

def averagePrice = (c1 + c2 + c3 + c4 + c5) / 5;
plot data = averagePrice;
#

stock: AXP

If you're seeing some columns with numbers and others with "NaN," it means that there are some periods within the lookback window where the data is missing or not available.

The "NaN" values occur when there is no valid data for a particular bar within the lookback window (in this case, the past five bars). This can happen if there was a gap in the data or if the data is simply not available for those periods.

 

[halcyonguy]

If you're seeing some columns with numbers and others with "NaN," it means that there are some periods within the lookback window where the data is missing or not available.

The "NaN" values occur when there is no valid data for a particular bar within the lookback window (in this case, the past five bars). This can happen if there was a gap in the data or if the data is simply not available for those periods.

i know that. that is why i tried trapping for errors with isnan( )

 

[jpmcewen]

@ezrollin if you are still looking...a couple of scripts in this link from shortthestrike should help.

Option Percent Change (http://tos.mx/PqPUFwW) can be changed to 5 days

def condition =(close - close[3])/close[3];
AddLabel(condition,Round(condition*100,0)+"%",if condition >= 0.5 then color.green else if condition <= -0.5 then color.red else color.white);

My guess is the Premium Percent of Underlying (http://tos.mx/6c3ceCk) script can probably be incorporated into the Option Percent Change script to accomplish what you are looking for.

def condition = ((close/close(getUnderlyingSymbol())));
#plot condition = if signal <= 0.04 then 1 else 0;

#def condition =(close - close[1])/close[1];
AddLabel(condition,Round(condition*100,0)+"%",if condition >= 0.5 then color.green else if condition <= -0.5 then color.red else color.white);