PDA

View Full Version : Members returns analysis page



KevinD
08-22-2010, 09:49 AM
This page -> http://www.tsptalk.com/tracker/tsp_user_balance_returns.php

At the top you can sort by user name and YTD returns.

Any way to add a sort by MTD returns?

JTH
08-22-2010, 12:08 PM
This page -> http://www.tsptalk.com/tracker/tsp_user_balance_returns.php

At the top you can sort by user name and YTD returns.

Any way to add a sort by MTD returns?

Agreed, that would be awesome!

burrocrat
08-22-2010, 12:33 PM
welcome back!

burrocrat
08-22-2010, 12:34 PM
ooops, i thought this was a thread about member returns, sorry lady.

Boghie
08-22-2010, 12:41 PM
ooops, i thought this was a thread about member returns, sorry lady.

Burrocrat,

I, too, have arisen from the dead. Yuk, yuk.
I think CoolHand was worried.
Just a boring market.
Kinda busy.

But, KevinD, your suggestion is awesome. I don't know what tools Tom uses. Such a change could be very simple - or an absolute misery. Maybe Tom could put it on his change list and factor it in with other priorities. Regardless, I think you could copy and paste the data into a spreadsheet and work it that way...

Boghie
08-22-2010, 12:56 PM
Has anyone else found it annoying that:


Many of the current crop of AutoTracker leaders don't document their moves, ideas, and strategies in their threads. That used to be – maybe still is – a requirement for being on the AutoTracker.

Not nice. :confused:

There are those of us who are currently banging around in the middle or bottom that could use a bit of help. Some of us are not accustom to our current locale – normally spending time nearer the top. Most of those oldsters (AutoTracker speaking) documented their moves.

Time to do the same.

Spread the wealth a bit, it won’t hurt.
We will grow the pie together - yummy.
Floating peacefully on a rising tide – relaxing.

JTH
08-22-2010, 01:11 PM
Has anyone else found it annoying that:
Many of the current crop of AutoTracker leaders don't document their moves, ideas, and strategies in their threads. That used to be – maybe still is – a requirement for being on the AutoTracker.Not nice.


Yes it has been that way ever since I can remember.

1. Those at the top don't want to be overtaken.

2. Those at the top don't want to be responsible for a
bunch of folks losing money based on their moves.

3. Some folks got to the top by pure luck, or by
following other members...

poolman
08-22-2010, 01:28 PM
Yes it has been that way ever since I can remember.

1. Those at the top don't want to be overtaken.

2. Those at the top don't want to be responsible for a
bunch of folks losing money based on their moves.

3. Some folks got to the top by pure luck, or by
following other members...


Not that I am at the top or near it but those are some pretty good answers JTH.

JTH
08-22-2010, 01:43 PM
Not that I am at the top or near it but those are some pretty good answers JTH.

Thanks, I figured you should know the answer to that one :D

tsptalk
08-22-2010, 02:15 PM
Any way to add a sort by MTD returns?
I am sure there is a way, and that was one of the categories I really wanted when we first redesigned the autotracker, but I could never get it to work. I don't recall exactly why it was so tough - perhaps because the return had to be calculated, stored, the resorted, but I could not get it to go. I had another programmer try to help me and it just wasn't working right. When I make the monthly tallies now, I have to cut and paste the yearly list and resort in excel. Kind of a pain.

If anyone wants to give it a shot, I'd work with them to get it done.

Boghie
08-22-2010, 05:25 PM
Tom,

I am making a full version upgrade on a little basketball conference webapp as I type. I'll soon be in a module where I'll want to sort by a computed field. Another option would be to load the grid and allow sorting on the column. It all depends on the tools used - and the bugs in those tools:p.

I just wasted two days because I wanted to MD5 hash passwords in my database. I never wanted to have my customers (my bball buddies) to start using a system with their personal passwords in the clear (my little db is a Microsoft Access database which some hacker has a chance at getting to because it isn't a database server). Guess what. You can read a byte[] array data from a field called "Password" - but, you can't save byte[] array data to a field named "Password". Renamed the field and everything works...

So, even easy things can be hard.

And, offering a sort on a computed field may not be easy.



I am sure there is a way, and that was one of the categories I really wanted when we first redesigned the autotracker, but I could never get it to work. I don't recall exactly why it was so tough - perhaps because the return had to be calculated, stored, the resorted, but I could not get it to go. I had another programmer try to help me and it just wasn't working right. When I make the monthly tallies now, I have to cut and paste the yearly list and resort in excel. Kind of a pain.

If anyone wants to give it a shot, I'd work with them to get it done.

burrocrat
08-22-2010, 06:21 PM
if you are using ms excel for the number crunching, research the 'vlookup' command to sort and compare a big set of variables, kicks the crap out of 'if' statements or conditional formatting.

thank blue i think for that tip, the travel cost spreadsheet she helped me with actually did the trick, there will be a management and a grunt multi-day workshop, after the new fiscal year (from another thread), just had to help show how it penciled out.

KevinD
08-22-2010, 08:02 PM
I am sure there is a way, and that was one of the categories I really wanted when we first redesigned the autotracker, but I could never get it to work.

Thanks Tom. I wish I had the skills to help...I definitely would. :embarrest:

tsptalk
08-22-2010, 10:32 PM
So, even easy things can be hard.
Agree. You never know what is going to cause the problems. It seems simple in our heads, but making the computer think so is another story. :)

KevinD
08-23-2010, 07:14 AM
I'm no techie but I see "date range" search boxes on other sites. My mad money bank account for one and the Georgia lottery results page for another. This page has a search box for a single date. How about something like that?

tsptalk
08-23-2010, 11:00 AM
That's true. The date range might help.

It is currently set up to show returns from Jan 1 through any date of the year. And to grab data from this date to that date and display it probably would be pretty easy, but adding up only that data within that range is tougher than it sounds. But the date range idea might be a helpful way to approach it. Thanks.

One of these rainy days in the fall I may jump in head first and try to get it done.

KevinD
12-20-2010, 09:41 AM
Bump.

http://www.tsptalk.com/tracker/tsp_user_balance_returns.php

Not sure how long it's been this way but you can now sort by MTD and QTD. Thanks Tom! 10331

tsptalk
12-20-2010, 09:54 AM
You're welcome KD. I worked on it this weekend. It should be a lot faster now too.