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)
I checked the SC forum and and found the user you mentioned. The problem is that every time SC makes some major changes he as well has to change his code.
This workaround was added to the above thread on the SC forum:
If you really need a column's values in ascending datetime order, here is a way to do it (without manually entering a formula in every cell):
1) Put this in cell Z2: =J30+1
2) Put this in cell Z3: =Z2-1
3) Put this in cell Y3: =INDEX(A$3:A1002,Z3,1))
This assumes you have Number of Rows set to 1000. Edit the A1002 to the number of rows +2.
This example sorts the Date Time column A, but it works with any column.
I started a thread over at SC for a feature request, but haven't seen any interest. Rather than bump my own post over there, I thought it may be worthwhile to get some feedback from the futures.io (formerly BMT) crew.
From my post:
Am I in the minority in thinking this would be a useful addition? If so, that's fine. It just seems like there's some potential. Initially, an obstacle that came to mind was place in time. For example, if it's just 5min into current day RTH it doesn't seem like there would be much value in proportionalizing the current day volume profile against a recent completed day or average of several completed days. If it was a constantly updating comparison (i.e. 08:30-08:35 from today proportionately compared to 08:30-08:35 from yesterday), that could be useful.
I don't think it's any grail or anything earth-shattering, it just seems like a feature that could produce more representative market view when using volume profiles (or vol by price).
Thoughts? Bueller? Bueller?
Luck is what happens when preparation meets opportunity. ~ Seneca