Closed

evaluation of etf performance using the capm anf fama-french models

For each ETF, compute the Sharpe ratio, CAPM alpha (with associated t-statistic) and Fama-French alpha (with

associated t-statistic). Use the LINEST function in a VBA subroutine to compute alphas and t-statistics. Append

your results to the data in the spreadsheet ETFdata.xlsx.

 Create a pivot table from the combined data.

 You will need pass a spot check where you demonstrate your facility with the pivot table to me. Be able to answer

a series of questions such as:

o Compare the average expense ratio between Vanguard and Blackrock ETFs

o What provider has the highest FF alpha among Growth & Income funds?

o What is the correlation between turnover and expense ratios among Emerging Markets funds?

o How many small cap funds have significantly positive CAPM alphas?

Skills: Excel

See more: Using R and TreePlan, perform software management tasks and answer questions about decision trees for these questions., fama french model econometrics project, performance liquid chromatography exam questions, stationarity test eviews fama french model, fama french model eviews, servo motor control using pic16f877a compare module, business performance analysis evaluation, ber snr performance using bpsk matlab, fama french 1992 sas, sas fama french, fama french sas, using nimsad compare ssadm, using perl compare diff files, performance chat website using, parse using bash script find average

Project ID: #12213162

10 freelancers are bidding on average $175 for this job

$200 USD in 3 days
(266 Reviews)
6.7
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More

$155 USD in 3 days
(35 Reviews)
5.3
$166 USD in 3 days
(6 Reviews)
3.7
NoelReubenMuturi

Hello, kindly contact me through https://www.freelancer.com/u/NoelReubenMuturi.html Hello, I am Noel, a proficient statistician. I am proficient in diverse statistical disciplines including data analysis, statistic More

$200 USD in 3 days
(5 Reviews)
3.5
serhiio

Hello I work as a financial analyst. I will help you with the decision of this task. My education finance manager. My experience for about 10 years.

$155 USD in 3 days
(2 Reviews)
2.6
asin1987

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on skype as well: as More

$155 USD in 3 days
(0 Reviews)
0.0
anandsabale

Hi, I am GARP certified FRM with work experience of 12 years in hedge funds and fund of hedge funds. I run a consulting company from Pune, India. My clients are based in UK and US. I would like to bid for this proje More

$222 USD in 10 days
(0 Reviews)
0.0
Markysm

I have extensive experience scripting and creating solutions for excel. The task described seems simple and I can turn this around to you rather quickly.

$150 USD in 3 days
(0 Reviews)
0.0
Mamun80

Dear Concern, I am Electrical and Electronic Engineer. I am very good in Microsoft office application especially in Excel, MS word, visio, power point, etc. I have manage large database in Alcatel-Lucent, Ericsson, Pa More

$155 USD in 3 days
(0 Reviews)
0.0
mascotsoft4

Dear Client, Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project befor More

$194 USD in 6 days
(0 Reviews)
0.0
Goalaholic

I have done CFA level 2 and have calculated CAPM and other models. I have done these models in excel as well. Further assistance will be provided if required

$150 USD in 10 days
(0 Reviews)
0.0
balafreelancer16

I am interested in Data Entry,Typing jobs, chat and email support. I am also a fast learner, enthusiastic and can work with minimal supervision.I can work part time or a full time job where I can work at my home,depend More

$111 USD in 3 days
(0 Reviews)
0.0