Tracking Excel spreeadsheet

Hello,

I'm looking to have an Excel spreadsheet created that will help me with tracking of financial transactions. I invest in HYIPS. (High Yield Investment Plans) The spreadsheet I envision will be going from to right.

What I need to have created is a ongoing tracking spreadsheet that will be used daily.

The formulas I need to have applied are the following. From the initial purchased day a clock counting the days going forward. Ex. if purchased on Sept 20 when I go to enter data on this company say on Oct. 10 a column showing me for day 20 days I have been invested in this plan. The next day showing me 21 days. Until that case ends.

I will also need a column that will show the days company has been in existence. I can provide the initial info then the spreadsheet must have the ability to count forward everyday showing me company has been around for 51 days, then 52 etc.

I need a formula for a column when new cost (earnings) entered for that day will have a continuous automatic sum fro that company. Each day cost gets entered for a company a current updated sum will appear.

At the bottom of this column a continuous sum of all the information entered for each companies earnings daily It could be as may as 100 companies.

A column converting the daily BitCoin cost for earnings into US$ cost. The one column will show say .256 BTC for a company the next column will show that cost converted to US$. But the trick is somewhere on the spreadsheet I must be able to enter the daily cost of BitCoin because it will change from day to day, but I will need the overall earnings converted everyday to US$. Also that column will have a continuous sum at the bottom that will update automatically after entering e data (earnings) if for only one company let alone 75 companies on daily basis.

I need the spreadsheet to have a column which will calculate the break even point of an investment. Ex. company pays 4% daily. Some where this info will be entered for that company and the spreadsheet will show me that the break even point will be 25 days to recover the initial investment. But the tricky part is many will be different parameters. Some may be 4% daily others 10% daily other 1.5% daily. It only has to be figure out one time. (If need be I can also do calculation and enter into spreadsheet because it will only be entered once.)

Lastly I need to be able to enter the info for a new company (HYIP) plan I invested in that day. We will say there are 20 companies. I will have these companies separated by risk. Say A-high risk, B-moderate risk, C-low risk. When I enter the new companies info into the sheet it will be placed into which ever category by risk and by date. Basically the newer companies will fall at the bottom of that section. But I will assign the company the risk profile. I just need the spreadsheet to be able to move that info into the appropriate section.

I believe this is the complex issues. The other info I can enter in name of company, web address, date company started--this date would be used to calculate how many days company is in existence everyday.

Please let me know if you have any thought of being able to put this together and have the tie and projected cost.

Thanks,

Joe Pistorius