![]() Here is the excel demonstration file for download (no VBA, no macros). Here is an example that compares the S&P to a hypothetical trading system: With VAMI results you can evaluate the 2 sets of performance results. This way, when you are finished, you can compare apples to apples, rather than apples to oranges. ![]() Or, you can compare your results on a monthly basis with the performance of the emini S&P (or any other tradeable). VALUE ADDED MONTHLY INDEX (VAMI) (When to Use it?): When you have different trading systems and you want to compare their performance, or if you have different versions of one system and you want to compare them, it is useful to normalize the monthly returns and then compare them with VAMI calculations. You select if it was a GAIN or a LOSS from cell I6ģ.Excel and trading, (free MS Excel template is available BELOW). So 1st you choose the amount (For example £3000) in Cell I4Ģ. The sheet is here if anyone can attempt to get this off the ground and working.īasically I've now made the calculator into a GAIN or LOSS calculator now,using a list select in cell I6ġ. My math always has been, well, crap! trying to get my head around this now, I think I'm about to explode! Still trying to figure out how to get this working, looking at SHG's original code as a starter, to try and work out the math. I might contact dropbox over thisī6: =IF(ISNUMBER(B2), B2, IF(ISNUMBER(B3), B3 * B1, IF(ISNUMBER(B4), (1 - B4) * B1, "")))īut now seeing as I've reconfigured my spreadsheet and added cells, moved cells etc I'm totally confused!! (& thanks again SHG for your reply earlier, very much appreciated as always!)Įdit, just to add, if you open in dropbox, for some reason dropbox shows the referenced cells differently on the web! You have to download it and you'll see the cell references are the same as the one's shown on the image Imgur. So hard to find something like this on the web. I know the formulas will be more difficult because of the cell 'I6' with the drop down selector, but it makes the whole sheet work well. I know it's a big ask, but if you / anyone can help getting this calculator working it would be really really fantastic, I don't think there is a way to do it with 64bit excel? If there is, I'm all ears! I would have used (Excel Jeanie/HTML Maker), but I've got 64bit excel installed so I couldn't add it here, as they aren't 64bit compatible). I know from the screenshot it looks 'Busy' but that's because I spent time to include all the cell references. ![]() This then means that from this selection all the calculations will be either showing recovery data (To get back to break even), The main difference SHG is that I've managed to make Cell I6 a 'LIST' drop down menu where a user can select either 'GAIN' or 'LOSS' I include a dropbox excel sheet link here also I've added 'callouts' to reference cell loctions. I've had a rethink SHG, as I made a few errors, saw ways to improve the calculator, and I've spent a few hrs redesigning a new version this morning.Īgain, trouble is I'm not clever enough with formulas to get it working! But I can design ok, well kind of.) Thanks again for your reply yesterday, I've recovered now! ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |