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)
You can eliminate the columns that count (the ones to the left of the Cyan and Peach colored columns) by just using COUNT() or COUNTA() (both should be equivalent in your case I think).
In the row just below trade 796, column E I think (the cell that has value 325)--wherever you reference that the formula can just be:
COUNT($F$1:$F$796)
That gets rid of 6 of your columns if you choose to.
Thanks. I know there are several shortcuts, some I used to know. I had actually called a friend ths afternoon, who is a spreadheet whiz, but got her voicemail, so I did it another way.
Go back to 2006ish and I was pretty sharp in Excel, but as the volume of my deal analysis fell off, a lot of that went away. A lot of formulas now come out as garbage for me, where at one point they were not even a thought. Rather than look it up in a help section, I often just add a column. Losing my touch as I get older.
One thing I recognized was my larger holds, win or lose, were at the front of the month. Then I fell into a groove of scalping for the rest of the month. I believe I should have stayed with the beginning strategy, but something spooked me. Or rewarded me? I do not recall anything specific, but I see it in the pattern.
I just emailed @josh, but will also post here. Always looking to learn something new...
I tried volume ladders, market footprint, etc. several years ago, but then fell back to simple VSA on a 1 minute. Big volume + tiny bar = possible absorbtion. Easy.
I am most interested in seeing how POC, VAH and VAL coincide with the SR lines I draw by hand. Those are SR levels I never pay attention to, mostly because I don't watch anything to show where they are... but I do believe in knowing what other traders are looking at, so feel somewhat like I am being lazy by not knowing where those are. I had some volume indicator that really upset NT once before, I had to completely re-install, but can't remember which indicator it was.
I am curious what indicators are popular for NT, or even if someone has a chart template? Is it the Gomi package? If anyone has a good understanding of it I would love to look at it.
BTW, I have read this thread, which seems to end on the indicator info. But anyone who is familiar would be appreciated.
CL did find the support in the blue zone, and is now forming what may be W5 on the 120/240m coming off the local DB. Today's action was a float up, I almost did trade it having been on the wrong side of that on a holiday years ago... but, volume can go anywhere and I sat flat.
There is a retest of the ETH trendline in orange, but for some reason I have not ruled out the RTH line in red...
Start of September 2012 screens right half. I may play with prior OHLC and volume profile on one or more charts this month. Big topic of discussion on nexusfi.com (formerly BMT). Not sure where to put it, but will work it in somewhere. I do not want to reduce the volume chart, I find that works much better for me when it spans the entire height. It kind of feels like what I imagine volume ladders do for other traders that I read about. Maybe some day I will get it. But for today, dinosaur or not, it is what I know.
Left side screens. I have not done anywork on 6E or ES, but interested in how ES just hugs that zone.
Before I erase and start over, I was really expecting ES to hit 1385 last week. Maybe that zone is no longer valid now, but last week I was surprised. Now there is a local DB set at 1395... and also stop orders, most likely...