The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
0answers
108 views

Adding Asset Weights To Cholesky Output - Monte Carlo in VBA

I am looking to create a Monte Carlo generator in Excel to plot correlated asset paths for a portfolio containing 1 to 10 assets. I have the correlation matrix for all 10 assets and have performed the ...
3
votes
0answers
588 views

Portfolio Optimization with Monte Carlo Simulation - How to do it with Excel?

If I have three asset classes and their historical weekly returns for five years, how can I construct a minimum variance portfolio and an efficient frontier plot with Excel? To do that do I have to ...
1
vote
0answers
805 views

Exporting Time Series Data For Securities Prices From Bloomberg to Excel

I have a list of securities over a thousand entries long that I want to construct a time series of prices for over a specified historical period (e.g. 2/01/10-2/20/10). Doing this manually would take ...
3
votes
2answers
431 views

Resources for finding quantitative finance examples using excel, VBA and access

I am seeking to increase my knowledge in the quantitative finance field. I would be grateful if someone could point me to useful resource online, where I can find working examples of they types of ...