I'd like to learn a bit more about all of the modeling and MS Excel based spreadsheet portfolio calculation, analysis, and optimization tools that investment managers use in their portfolio accounting, risk management, and pricing / valuation of positions processes.
Something like what Wall Street Prep or Tain The Street offers but geared more for what I just mentioned would be ideal but I couldn't come across anything.
I think the best solution currently available will probably be a book. Would love some suggestions!
I'm thinking something along these lines.
Essentially I'm looking for something that would help someone if they were in the role of a Portfolio Risk Analyst, Portfolio Optimization Analyst, Middle Office Valuation Analyst, Performance Analyst, etc....
Hedge Fund Modeling and Analysis using Excel
Quantitative Finance: Simulation using Excel
Would love any other suggestions!!