Apparantly, there are people referring this page throughout the net for this spreadsheet download... Please let me know if it is not functioning correctly...I have not tested it throughly...Who woulda' thought...
Hi, Good to see some questions on Excel. I have some myself, so, if someone could help me, I would be much apreciated. I trade on Oanda, so I can have a full historic activity for me to analise my trades, but I also keep track of my evolution on a weekly basis. As you can see on the file I attached, my spreadsheet has a colum (yellow) where I set my goal eah week. Next there is what I actualy made. The next colum is the same but in terms of percentage (which I didn't delete). Next is the colum for month in general. In another tab I keep the record of any activity given by Oanda. On the right I keep a projection on a 52 week and 104 week (both on the goal as on the projection considering what I've already acomplished) Next the is a cell that indicates the actual valorisation considering the beguining and an estimate for the next week goal considering what I've ended up in last week. Finally, there's a chart with the goal and the actual gain. Confusing? Well, I'm Portuguese, sory for some gramma errors... My question is: Is there a way that I can just punch a number and the formulas involved automaticaly do everything (each time I add a value on the week), instead of me having to edit the formulas all the time to choose the correct cell, which is the new week's value? For example; for next week (nº8) I would like to just put the NAV (on the green colum) and automaticaly; the graph, the % and everything else just updated, instead of me having to edit the formulas for the new cell... Any help is very welcome. TIA