Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
NBCV is ID 5 and SG 37 is selling COT (in a nutshell) specifically it is "high pullback ask volume and bid volume difference." SG 38 is buying COT.
I'm using the following logic for selling (SG37) =and((ABS(ID5.SG37))>8*(ABS(ID5.SG38))) and this for buying =and((ABS(ID5.SG38))>8*(ABS(ID5.SG37)))
The logic works fine with the following exception
If SG37 or SG38 is zero it returns a positive or meets criteria and colors bar ie SG37 is zero(0) and SG38 is nine(9.) If not a zero the logic works as it should
Any help very much appreciated
-William
Can you help answer these questions from other members on NexusFi?
For what I'm using this for ie color bar based on SG37 & 38 of the NBCV study I'm using this to eliminate having to show the NBCV study itself (takes up too much real estate on an M1 Bar chart
The problem is the COT data (SG37 & 38) has different thresholds of significance between 0200AM ET through 0900AM and 0900AM through the pit close. The majority of the time SG37 will be zero and 38 will have a number greater than zero, vice versa SG37 will have a negative number and 38 will be zero.
I'm still dialing this in. I have set the multiplier to as high as 20X but 20 times zero is obviously zero.
Are you versed/ skilled in SC syntax? I can pick away at it, more of a hack. I don't have access to spreadsheet studies through my SC platform
