The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
15 views

Help with amortisation table in Excel VBA [on hold]

I am a beginner with VBA. I am trying to create an amortisation table where the interest rate used depends on two inputs which will be provided by the user. For example if X=2; and Y=3, then interest ...
1
vote
0answers
101 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
569 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
777 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
419 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 ...