I have a project that is half way finished that I would like to complete asap. It requires someone with great excel vba skills combined with good understanding of finance (or accounting). The spreasheet is a dash board to monitor portfolios. It needs to be able to aggregate positions into a number of different fields-metrics. The transaction engine has been developped by someone else who couldn't complete it perfectly so I would require you to debug the few glitches left. This project needs time together as I would need to walk you through some specific steps but for someone fast, I anticipate about 10 hours work. I am ready to pay more (see PM) if the work is good and it takes much longer than anticipated. Have a look at this file and its VBA to get a feel for the work. Most of the development needs to "automate" the first 2 tabs (mostly info in RED)and the NAV tab as well. To make sure that you read this description and the attached file, please put the key word: "Option" and the word on the Sheet "Dash Board" cell A147.
PS: The original file is too large for being posted...please ask for it if interested.
Option Put. Hi, I am not sure of what you exactly need, but I have no problem doing it in VBA. I have been working in a laboratory since many years and I am accustomed to calculations. Contact me. Luc