The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
17 views

how to create folder and csv files for each row in each sheet (VBA) [on hold]

I have an excel workbook. In this workbook,I have 3 worksheets, named by"First","second" and "third". Each sheet has 4 columns such as Date X1,X2,Oneletter.I'm trying to run a VBA program.But I have ...
3
votes
0answers
261 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 ...
0
votes
0answers
390 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
275 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 ...