akuma99

GoldenTRACKER 0.4.2

Hi to all fellow Goldentalkers!

Through my trawling through the many informative (and some not so informative) posts as a part
of my mod role here at Goldentalk, I have noticed the posts asking for a spreadsheet about this,
or how do you work out that, or what if I did this instead of that, and thought, bugger it, lets throw
something together that might help out with some of those questions.

So, in anticipation of an online HYIP diary system I hope to have up and running in the near
future, I offer you:

To put it simply, it is an excel spreadsheet designed to keep track of the many permutations
of programs out there in the HYIP world. While in its early stages, I use it to keep track of all my
programs and it is working great guns.

I offer this to all Goldentalkers free of charge of course, in the hope that improvements, updates
and suggestions will be posted here in this thread for other Goldentalkers to share.

In short, the blue squares are areas you can enter amounts into, all others calculate automatically.
No cells have been locked, so you can change (or break) it as you please, but please, if you make
improvements post a new version here.

Click on the headings for explanations on what each column is for if your unclear on its use.

I hope it is of some help to you all.

- Minor empty cell problems fixed
- Bonus indicator added
- Now includes space for 10 programs

Current version
GoldenTRACKER 0.4.2 | http://www.goldpoll.com/goldentracker_v.0.4.2.zip

Previous versions
Sorry older version are now no longer available.

peterg

Thanks a bunch mate, owe you a cold one or three for that.....
I'll have a good play with it tomorrow. It's starting to get a bit late here, and I'm in the same age decade as the Grand Master himself.... so us old codgers need to go horizontal a bit earlier than you youngsters !

I'll soon be flat out like a lizard drinkin'...

ken123

Thanks. I will give it a try. I will vote for it after the trial run.

NDA corp

Me too. Thanks akuma99...

Vote after 'test drive'...hope to be a smooth one !

Aloysis

Good Day akuma99,

Very good contribution indeed.. now i can track my investment..hehe have been trying to come out something like what u have done but just can't find the time..have to work overtime.. thks dude!

Truly

Thx Akuma.

Now I think Hyip accounting is ok in use.
(Please search at talkgold, I made lots of suggestions to the admin)

If the following issues be counted, then members here can all go and use it, I think.

1. Interests rate to be "0"
The present verion shoud be positive.

Why to be "0"?
In not a few cases we have to sponsor or benefactor other members into certain programs, and all such real spends yield 0% interests.

2. Divide the "New Investment" to "Personal Spend" and "Bonus Spend"
The Personal Spend is just like the former "New Investments", should be added into "Invested Amount".

The Bonus Spend is from Admin BOnus (like fast market) and Referral Bonus (like other programs), which is added to investment automatically (produce the same interests).
But Bonus Spend is not from members pocket money and should NOT added into Invested Amount!

3. Calendar Function
Alerting members when to withdraw or spend, and other issues.

I am now using Hyip Accounting!

amazinggrace

akuma99

Hey tudi.cn, yes I looked at HYIP Accounting 1.7 last week in the hope it would do what I need, but to be honest I was quite dissapointed in its lack of flexibility. My main issue was you cannot change the compounding rate mid way through a program from what I can see, as well some of the issue you list as well. It seems to be good for straight simple schemes, but who here puts money in, compounds at 100%, then withdraws 6 months later ... not many. If I have missed that functionality then let me know.

That is why I though why not keep it simple, throw what I need into a spreadsheet and get suggestions from Goldentalkers on what they need. You have started that process so thanks tudi.cn

Aloysis, not a problem, I was in the same boat, so when I had a spare minute I grabbed the opportunity to throw something together ... suggestions are welcome and I will modify as need be.

Truly

I understand your concerns.

Actually we are always in many programs (I am in about 20), so we really need a goold helper.

As for the variable rates in Hyip Accounting, I update the New Payments twice or once a week manually (like the case of PO-Trading). And you know, any software maybe not so easy to deal with this issue.

I was always thinking if we can help to improve a system, that will benifit us all.