# Tagged Questions

The tag has no usage guidance.

207 views

### Step By Step method to calculating VaR using MonteCarlo Simulations

In trying to find VaR for 5 financial assets with prices over a long period of time(2000 days worth of data) how would I do the following: Carry out monte-carlo simulation in order to find a VaR ...
164 views

### How to automatically get all options data for a particular stock into microsoft excel?

I'm looking for a way to get the entire options chain (All options expiries) for a particular stock in excel without manually copy pasting anything. It does not have to be real time and I will only be ...
26 views

### how to convert quarterly data to monthly

Is there any way to convert quarterly data to monthly in excel or preferably in STATA? I Next to that, how can I transform dates in excel so as to be recognized by STATA?
35 views

### Swaption Corridor Payoff Diagram

What does the payoff diagram look like for a long payer swaption corridor? For example, suppose that I am looking at a long-payer $1 \times 10$-year swaption with 10Y swaps as the underlying. If I ...
200 views

### Could someone teach me how to construct the portfolios by compute (like using R, Excel or Eviews)

Recently, I am doing my dissertation that covers asset pricing theory. The empirical test of Fama 3 factors model is an important part of this dissertation. Please let me review the fama model. Fama ...
62 views

### Backtesting Long/Short Market Neutral Z-Score Strategy with Custom Factors and Custom Stock Universe

So I've managed to backtest simple strategies, like MA, RSI and some fundamental ones (P/E ratios etc) but Im stuck at my last strategy. Here is some information: Tools: Excel and Python (also a ...
7k views

### How to simulate correlated Geometric brownian motion for n assets?

So I'm trying to simulate currency movements for several currencies with a given correlation matrix. I have the initial price, drift and volatility for each of the separate currencies, and I want to ...
14 views

### Deming Regression

I am trying to test the linearity = interdependence or the non-linear (contagion) between Asian countries during the Asian crises using the fluctuation of the exchange rate. Is it relevant to use the ...
79 views

### Optimize a trading strategy created in excel with R

I have created quite a complex back test in excel spanning 15 years with 17 parameters. I would like to optimize the parameters which would give me maximum return given a maximum draw-down percentage. ...
24 views

### find the qth lower tail quantile

I have daily currency returns. For each month, I have to find the return associated to the 5% lower tail quantile for each currency (the lowest return or the second lowest return). Could you please ...
163 views

### How to backtest Value at Risk Models using Conditional and Unconditional tests?

I am trying to carry out backtesting on a number of Value at Risk figures i obtained using var/covar, historical, and monte carlo simulation. The two methods im using are the Kupiec test (...
26 views

29 views

### Daily principal payments, accumulated on yearly basis in excel

I am doing something seemingly quite easy: Prinipal calcuation of a loan. I need to calculate daily principal payments and accumulate it on a yearly basis. So my current implementation look like ...
903 views

### How to fully replicate ADX + DI Indicators in Excel? [closed]

For black box testing, I was hoping that I could replicate the ADX + DI+ and DI- indicators that are provided in trading platforms such as ThinkOrSwim, ScottradeElite etc. However, I noticed that ...
98 views

### Export security description data from bloomberg into excel

I have the cusip of about 300 bonds. I want to retrieve the security description from bloomberg and then export it into excel. Does anyone have any tips as to how to accomplish this?
589 views

### Which method is implemented by Excel's YEARFRAC for ACT/ACT?

I know the algorithm used by Excel to calculate the YEARFRAC(startDate, endDate, basis) for basis=1. Excel calls the method "act/act". A Java re-implentation of Excel's algorithm can be found at ...
592 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 ...
3k views

### Bloomberg Libor Rates

I load swap rates data from Bloomberg in excel using the command =BDH(Ticker,"Px Last",Start_Date,End_Date,"Dts",FALSE) The tickers I use are "USSW1 Curncy", "...
277 views

### Obtaining logical lists of Bloomberg security codes in Excel

I am using Bloomberg's BDP and BDH functions in excel to retrieve data for a set of options. The problem is that (as underlying prices move and expiration dates come and go) option strikes are ...
95 views

### Review of Excel Stock Simulator

I am currently a senior in high school and I built a stock simulator using knowledge gained from a semester of AP Statistics. I was wondering if someone could tell me if my simulation is legit/...
806 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 ...
433 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 ...
585 views

2k views

### What is the best solution to use QuantLib within Excel?

Excel is likely the most widespread instrument across all not-only-quants desks; in addition, we have to keep in mind that Bloomberg and Reuters allow to easily import real time data in Excel, and ...
515 views

### Data feed for 10 year government bond yields [duplicate]

I am trying to access a data feed for 10 year sovereign bond yields for countries, say the G20. I have tried world bank and IMF data api sources but to no avail. The data feed is used to update an ...
69 views

### Clarifying the way in counting number of weeks for calculating historical weekly volatility in Bloomberg

I would like to confirm the way to counting number of weeks for calculating historical weekly volatility in Bloomberg. Given an option with issue date from 14/1/2014 to 13/1/2019, is the proper way to ...
2k views

### IMM dates in excel

I need to get the IMM dates in excel. IMM dates are defined as the third Wednesday of every March/June/September/December.
792 views

### How to correctly construct a value- and equally weighted portfolio consisting of property-types?

A problem of which I couldn’t find the answer on the forum is about the construction of equally-weighted and value-weighted portfolio. I want to compute the equally-weighted property-type portfolio ...