Use last price in the scanner?

[yman]

How to select last price/current price is greater/less than study? I only see high low open close.

 

[BenTen]

It's not available under the scan list, most likely not possible.

 

[godfreym]

Hi guys. I am trying to code a custom column. I have two columns on a scan result. One is the Last price of an option and the other is the Open price. I am trying to code a new custom column to highlight the column green when the last price is 10% greater than the Open price.

Here is my code. I'm not sure why TOS wont accept the syntax. Any suggestions:

def O =OPEN;
def l =Last();
plot scan = (O*1.10);
assignBackgroundColor(if scan>l then color.dark_green else color.black);

 

[rad14733]

@godfreym Off the top of me head I think this should work... Note that I use self-documenting code rather than cryptic variable names... Also note that you cannot use Last as a priceType... Close works as Last while a candle/bar is painting...

def percenttChange = 0.10;
def lastPrice = close;
def tradePrice = if !IsNan(EntryPrice()) then EntryPrice() else lastPrice;
def diff = lastPrice - tradePrice;
def pct = if tradePrice != 0 then diff / tradePrice else 0;
plot data = pct * 100;
AssignBackgroundColor(if diff / tradePrice >= percenttChange then Color.DARK_GREEN else Color.BLACK);

I don't have any open positions to test this against at the moment...

 

[godfreym]

Thanks for taking a look. This may work and will give it a shot. I will let you know. Thanks again.

Shoot. Didn't work. Is there another priceType to use to replace Last? That's weird that you cannot calculate off it when its an actual column

 

[rad14733]

@godfreym No, the code above is not working... I did get it working and then messed it back up again... I've been having a terrible time coding today due to stress so I think I'm done for the night... I'll get it working tomorrow morning... I've slept like crap for days, if you can even call it sleep...

Edited to add: I managed to fix the code above... Note that it doesn't account for a negative price change percentage but it could be added...

 

[godfreym]

Man thats awesome. Thank you so much. I will test is first thing after the markets open. I dont think the negative percentage matters so long as it turns green if its greater than 10%.