Matt - After using it for a while now, I have a suggestion about
the format of the HP KISS section table. It would be very
helpful if the star column (far right, used to mark favorites) is
shifted to the far left, maybe in between the "Minutes" and
"Stats/Trades" columns.
I code a bit here and there and have lots of experience with
advanced Excel use, so I get that it might not be as easy as it
sounds e.g. maybe you have a lot of dependencies created with the
structure (using column numbers in code instead of column
names...which is still common). Just thought I'd ask because it
would be super helpful for me visually as I update my favorites
regularly as the "hot" sectors of the market change and some days
I'm just game for more alerts than other days. In the current
format, I find myself clicking the wrong star a lot and I've taken
to keeping a ruler next to my computer to hold against the screen
to check the line.
*before I started using table column names instead of column
numbers for things like concatenation, if I ran into an issue where
I had invested to much time to go back and change the structure, I
would consider adding a column at the end that repeated a previous
column (simply for visual help). If that was the situation here,
maybe you could bookend the table with the "Symbol/Chart" column
data (e.g. NVDA shown on both far left and far right)
thx maybe worth a change. TBest though to send us a pm
about it, or email into support - messages here get buried and
forgotten. And I don't look at the Trading Community as much as
Steve does because I'm doing all sorts of backend things on the
website, systems etc and so I will miss seeing some posts - best to
just send admin stuff like that to us
The other thing I'd like to do is set the top header row to stay
in position when one scrolls down past the top headers you have to
remember which that column is - by having the header follow you
down then you don't have to - a similar thing can be done in
spreadsheets like Excel where you set the header rows to follow you
down
I used to call myself an 'Excel God' LOL then I saw what my wife
can do and she blows me away LOL, the spreadsheets she used to
create for American Water back when she still worked LOL, were a
thing of art and beauty and functionality - her boss used to marvel
at them
Newsletter
Subscribe to our email list for regular free market updates
as well as a chance to get coupons!
Matt - After using it
Posted by bthefnd on 13th of Sep 2024 at 10:40 am
Matt - After using it for a while now, I have a suggestion about the format of the HP KISS section table. It would be very helpful if the star column (far right, used to mark favorites) is shifted to the far left, maybe in between the "Minutes" and "Stats/Trades" columns.
I code a bit here and there and have lots of experience with advanced Excel use, so I get that it might not be as easy as it sounds e.g. maybe you have a lot of dependencies created with the structure (using column numbers in code instead of column names...which is still common). Just thought I'd ask because it would be super helpful for me visually as I update my favorites regularly as the "hot" sectors of the market change and some days I'm just game for more alerts than other days. In the current format, I find myself clicking the wrong star a lot and I've taken to keeping a ruler next to my computer to hold against the screen to check the line.
*before I started using table column names instead of column numbers for things like concatenation, if I ran into an issue where I had invested to much time to go back and change the structure, I would consider adding a column at the end that repeated a previous column (simply for visual help). If that was the situation here, maybe you could bookend the table with the "Symbol/Chart" column data (e.g. NVDA shown on both far left and far right)
thx maybe worth a change.
Posted by matt on 13th of Sep 2024 at 10:43 am
thx maybe worth a change. TBest though to send us a pm about it, or email into support - messages here get buried and forgotten. And I don't look at the Trading Community as much as Steve does because I'm doing all sorts of backend things on the website, systems etc and so I will miss seeing some posts - best to just send admin stuff like that to us
The other thing I'd like to do is set the top header row to stay in position when one scrolls down past the top headers you have to remember which that column is - by having the header follow you down then you don't have to - a similar thing can be done in spreadsheets like Excel where you set the header rows to follow you down
Yes, freezing the header row
Posted by bthefnd on 13th of Sep 2024 at 10:49 am
Yes, freezing the header row would be awesome.
ha ha you said that
Posted by matt on 13th of Sep 2024 at 10:50 am
ha ha you said that much more efficiently than I did 'Freezing the header row' that's what I should have said vs my long discussion
Decades of nerdy excel life
Posted by bthefnd on 13th of Sep 2024 at 10:52 am
Decades of nerdy excel life helped me out for once
I used to call myself
Posted by matt on 13th of Sep 2024 at 10:55 am
I used to call myself an 'Excel God' LOL then I saw what my wife can do and she blows me away LOL, the spreadsheets she used to create for American Water back when she still worked LOL, were a thing of art and beauty and functionality - her boss used to marvel at them