Portfolio Performance Modeling Jobs

3 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 30+ hrs/week - Posted
Excel Portfolio Manager Spreadsheet I am looking for someone with an expert level experience in Excel 2013 to join the team and work on an existing comprehensive portfolio management spreadsheet. I currently have an existing Excel spreadsheet with various portfolio tabs that contain: a. Asset allocations b. Securities with current prices b. Dollar Cost Averaging strategy c. Rebalancing data d. Fee data f. Transactions g. Performance Reports h. Summary Reports and more. I am looking to accomplish 3 things: 1. Fix the current bugs in the spreadsheet and in the various reports. 2. Expand the functionality of the spreadsheet to include benchmarking comparisons in reports. 3. Increase the speed of the spreadsheet. The spreadsheet should be as “dynamic” as possible. By that I mean avoiding hard coding as much as possible and using VBA and Macros to make the portfolio scaleable. The candidate MUST have: - Expert level experience with Excel 2013 - Expert level experience with VBA and Macros - Good working knowledge of investing and portfolio management - Be a full-time freelancer with ample free time to work aggressively on this project - Get work done quickly and efficiently and meet deadlines - TEST YOUR OWN WORK AND DELIVER A BUG FREE PRODUCT - Be a clear communicator - Be available to speak on the phone daily regarding specifications - Be available on Skype daily to discuss specifications - Be comfortable in the role as a teacher when it comes to understanding and using the spreadsheet correctly The most important is TEST YOUR OWN WORK AND DELIVER A BUG FREE PRODUCT. I will no longer work with programmers who do not test and send me software loaded with bugs. if this is you, please do NOT apply. Note: To do this work effectively, it’s important for you to have a good working knowledge of investing and portfolio management. You must be an expert programmer and also a knowledgeable investor. Please submit any investing spreadsheets you have previously created for review.
Skills: Portfolio Performance Modeling Equity Research Excel VBA Financial Accounting
Fixed-Price - Intermediate ($$) - Est. Budget: $500 - Posted
Our firm is looking for a talented individual who can help us build out a variety of tools in Excel that will allow us to create customized portfolio solutions using Efficient Frontier and Mean Variance Optimization analysis. The scope of work will also include charts, reports, etc. that can be presented to the customer. For an example please visit: https://www.portfoliovisualizer.com/backtest-asset-class-allocation?s=y&mode=2&REIT2=10&endYear=2015&initialAmount=10000&TotalBond2=30&TotalBond1=40&IntlStockMarket2=20&portfolio3=Custom&portfolio2=Custom&portfolio1=Custom&TotalStockMarket2=40&TotalStockMarket1=60&startYear=1972 I look forward to discussing in more details via skype. Please provide any examples of work that you have done that is similar. Thanks. Matt
Skills: Portfolio Performance Modeling Excel VBA Statistics