The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
3answers
192 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 ...
0
votes
2answers
150 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 ...
3
votes
0answers
586 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 ...
2
votes
0answers
791 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 ...
1
vote
0answers
60 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 ...
1
vote
0answers
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 ...
1
vote
0answers
72 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. ...
1
vote
0answers
161 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 (...
1
vote
0answers
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/...
1
vote
0answers
800 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 ...
1
vote
0answers
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 ...
0
votes
0answers
24 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 ...
0
votes
0answers
36 views

Return, STD and CAPM based on Continuously compound return on daily prices

Mission: For some ETF, Get 1, 3, 5 years: Return STD CAPM parameters (alpha, beta) Reference if I calculated correctly: Yahoo finance performance & risk data Raw data: Daily adj. close ...