Hi guys, im just stuck on this, its probably not that hard, any help would be much appreciated.
There are 3 sheets - raw,A, and B
In 'raw' i will have unfiltered data from which i need to transfer 2 cells onto Sheet A and B. I need the Date and 'Total Equity' (which will be called Price in Sheet A/B).....the code should be something like -' If Column A has accoun# 323 and column G = USD, then copy the corresponding cells in column C(date) and column E (total eq.), send iit to sheet 'A', if acct# is '540' and colimn G =USD then send the corresponding Column C,E amounts to sheet 'B'.
Take a look at the Sheet ‘A’, I need new data to be entered into the sheet(in Row 2 everyday, without deleting any of the previous historical data). Then once this is imported into the sheet I want the following calculations to be run on the new figures
- Index (which is C2/$C$3777*100)
– Daily % change (which is LN(C2/C3))…should be done for whole column
- Volatility – (STDEV(E3:E3777)*SQRT(252))
- Cummulative Return - E2+G3
- Drawdown - ‘ –(MAX($G5:G$3776)-G5)
I hope that wasnt too confusing, if unclear please ask
thanks in advance
Bookmarks