Færdiggjort

Calculate VaR (99%) over next 252 trading days in excel

Hello,

I need a talented finance freelancer who can calculate the VaR (99%) over the next 252 trading days of 5 different stocks in a portfolio. If you can do this well please let me know.

The method used should be

1. EWMA 1: λ=0.94 for both variance and covariance.

2. EWMA 2: λ=0.94 for variance and λ=0.98 for covariance.

3. Historical Simulation 1: Rolling window with 252 trading days.

4. Historical Simulation 2: Rolling window with 100 trading days.

Evner: Excel, Finans, Matematik, Statistisk analyse, Statistikker

Se mere: var calculation formula, historical var calculation excel, var calculation examples, value at risk sample in excel, value at risk pdf, how banks calculate var, how to calculate var of a portfolio in excel, value at risk problems and solutions, summing days excel, trading platform excel export, calculator days excel, dynamic graph entered number days excel, stocks 100 days excel, trading indicator excel, employees free time sheet date days days excel, backtesting trading systems excel forex, substracting days excel, negative days excel, sample daily schedule days excel, find records last days excel

Om arbejdsgiveren:
( 7 bedømmelser ) Twin Waters, Australia

Projekt ID: #19239878

Tildelt til:

allmed2013

-I work in Finance, I have worked on risk management projects, so this is my field of expertise. Although, we need to discuss more details of what you really want to do here to minimize the risk of confusion. I can Flere

$235 AUD in 3 dage
(0 bedømmelser)
0.0

21 freelancere byder i gennemsnit $292 på dette job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Flere

$300 AUD in 5 dage
(310 bedømmelser)
7.8
javed1705

I am a qualified professional accountant, APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 13 years of experience. I can guarantee getting t Flere

$155 AUD in 3 dage
(481 bedømmelser)
7.7
liveexperts123

Hi there i am a professional mathematician and forex trader i can do this perfectly ...............................................

$750 AUD in 3 dage
(72 bedømmelser)
7.1
suyashdhoot

Hi I am a very experienced statistician, data scientist and business analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several com Flere

$500 AUD in 3 dage
(123 bedømmelser)
6.9
dgled

Hi, I know how to calculate the VAR of values by periods (like price by dates) and other similar formulas (like TWR). I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and ex Flere

$250 AUD in 3 dage
(87 bedømmelser)
7.0
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$250 AUD in 5 dage
(115 bedømmelser)
6.3
daniyal3214

I am a professional Financial Analyst and Financial Management expert holding years of experience in Valuation, Hedging and Quantitative Risks. I will be happy to discuss in detail.

$100 AUD på 1 dag
(129 bedømmelser)
6.2
doctorkendrick20

Hi, I'm good at this and can help I have skills in Excel, Finance, Mathematics, Statistical Analysis, Statistics

$150 AUD in 3 dage
(23 bedømmelser)
5.0
widadsaghir1993

Hello sir. As a math and statistics expert, I'm glad to see your project. If you check my profile, you can see I have deep knowledge in math and statistics with data analytics. if you give me your project, i think I Flere

$250 AUD in 3 dage
(6 bedømmelser)
4.4
freelancerpr0

I am a professor of mathematical finance and I can surely help you with your portfolio. You can check sample work I have done in my portfolio and my profile reviews: https://www.freelancer.com/u/freelancerpr0?w=f P Flere

$250 AUD in 3 dage
(7 bedømmelser)
4.6
Haddouamine

Hello sir ! I have a Masters degree in Economics and Statistics with 5 years of professional experience . I am the best candidate for this project as I already have Flere

$95 AUD på 1 dag
(15 bedømmelser)
4.0
kabbylinks

As a financial analyst with a BS in finance and 12 years of diverse-industry experience, I excel at managing complex FP&A initiatives for publicly held companies and global, multimillion-dollar operations. Valued as Flere

$250 AUD in 3 dage
(6 bedømmelser)
3.6
Zarinaali

Please message to discuss more details Please message to discuss more details Please message to discuss more details Please message to discuss more details

$1261 AUD in 3 dage
(3 bedømmelser)
2.9
Shanvm30

Hi, I can work on your project. I have a master degree in statistics with an overall experience of more than 9 years in statistical analysis using SAS ,R , SPSS ,stata and Excel

$170 AUD in 5 dage
(2 bedømmelser)
2.9
abbasJz

Dear employer, Hi I already have done a project like this and I have the MATLAB code for this type of calculations. I have done my M.Sc. thesis using Python and MATLAB. It was about developing a numerical mode Flere

$222 AUD in 3 dage
(12 bedømmelser)
3.1
rizwankamali

Hello I will complete the task of calculating moving averages using both lambda values in 2 days on milestone basis. I am qualified chartered accountant with 1 year teaching and 11 years professional experience in fi Flere

$225 AUD in 2 dage
(4 bedømmelser)
2.3
IbexEnterprises

Hi There, I am very much interested in doing this project. I am having a very rich experience in this field. Please give me a chance to work for you. You can check my previous project feedback/Review/Rating from cli Flere

$150 AUD på 1 dag
(7 bedømmelser)
2.1
ciiroccp

[login to view URL] [login to view URL] Hello, Please check out my Demo Dashboard YouTube video to get an idea of my work. I can manipulate the data: Provide KPI and Creat Flere

$155 AUD in 3 dage
(0 bedømmelser)
0.0
malookailash5

I am a chartered accountant with 5 years experience in account finance audit and taxation. I will complete your work within 2 days with 100 %accuracy.i have good work ex of excel,tally ,busy,word and other [login to view URL] Flere

$200 AUD in 2 dage
(0 bedømmelser)
0.0
Optimus22

I am a data scientist having 8 + years of experience in data mining,data scrapping,data transformation,data visualization and statistical modelling & have worked with large MNC's.

$222 AUD in 7 dage
(0 bedømmelser)
0.0