Home

Trading signal to short a stock

%3CLINGO-SUB%20id%3D%22lingo-sub-731376%22%20slang%3D%22en-US%22%3ETrading%20signal%20to%20short%20a%20stock%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-731376%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI'm%20collecting%20real-time%20data%20from%20a%20trading%20platform%20(think%20or%20swim)%20using%20RTD%20function.%26nbsp%3B%20I%20would%20like%20to%20setup%20a%20column%20to%20signal%20when%20to%20Short%20a%20stock%20when%20a%20condition%20is%20met%20(ex%3A%20RSI1hr%20and%20RSI2hr%20is%20%26lt%3B70).%26nbsp%3B%20I%20have%20this%20being%20used%26nbsp%3B%3DIF(AND(B3%26lt%3B70%2CC3%26lt%3B70)%2C%20%22SHORT%22%2C%20%22%22).%26nbsp%3B%20However%2C%20I%20only%20want%20the%20column%20D%20to%20add%20the%20SHORT%20text%20when%20a%20NEW%20condition%20is%20met%20(say%20within%20the%20last%202%20hrs).%26nbsp%3B%20Would%20anyone%20be%20able%20to%20help%20me%20with%20this%20request%3F%26nbsp%3B%20I%20greatly%20appreciate%20it!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-731376%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReal-Time%20data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETrading%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
WormTrader
Occasional Visitor

Hello,

I'm collecting real-time data from a trading platform (think or swim) using RTD function.  I would like to setup a column to signal when to Short a stock when a condition is met (ex: RSI1hr and RSI2hr is <70).  I have this being used =IF(AND(B3<70,C3<70), "SHORT", "").  However, I only want the column D to add the SHORT text when a NEW condition is met (say within the last 2 hrs).  Would anyone be able to help me with this request?  I greatly appreciate it!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies