Find Jobs
Hire Freelancers

R Studio: Analysis of data of stocks in SP500 -- 2

€30-250 EUR

Ολοκληρώθηκε
Αναρτήθηκε περίπου 6 χρόνια πριν

€30-250 EUR

Πληρωμή κατά την παράδοση
Output: A reproducible code in R + a short .pdf report with commented tables and graphs. The two files should be named STUDENT1ID STUDENT2ID.R and STU- DENT1ID [login to view URL], where STUDENT1ID and STUDENT2ID are student IDs of the members of the group. The files should be uploaded to a designated area in the [login to view URL] website. Project Description: Analysis of data of stocks in SP500. Your tasks are the following. 1. Get the data. First, you should set your individual first and the last date for your data analysis. This is done by [login to view URL](STUDENT1ID) [login to view URL] <- [login to view URL]("2018-03-31") - 365 - sample(1:20,1) [login to view URL](STUDENT2ID) [login to view URL] <- [login to view URL]("2018-03-31") + sample(1:20,1) One possible way to get the data is from the R library BatchGetSymbols and run the following code: library(BatchGetSymbols) [login to view URL] <- GetSP500Stocks() tickers <- [login to view URL]$tickers [login to view URL] <- BatchGetSymbols(tickers = tickers, [login to view URL] = [login to view URL], [login to view URL] = [login to view URL]) The object [login to view URL] has now the data for SP500 stocks. Another possibility is to use a package library(pdfetch) and get the selected data (adjusted close for individual stocks) by calling yahoo <- pdfetch_YAHOO(tickers, fields = "adjclose", from=[login to view URL], to = [login to view URL]) 2. We are interested just in the adjusted closing price value. Organize the data in a table, where rows represent the dates and columns represent the individual stocks. The first column should be the date, the following columns should have a name that correspond to the tickers. It helps that you may get the data using two alternative procedures (and compare the resulting two tables). Clean the data (address missing values if any) and make sure that each entry in the table corresponds to the correct date and the correct ticker. Note that some data entries may be missed in download, or the dates may not be 100% consistent for all tickers. As a part of the exercise, save the corresponding table in a .csv file. 3. Perform a basic mean - variance analysis. From the table of the closing prices, create a table representing log returns. Avoid the use of for loops. Instead, apply vector operations (such as log, diff, apply). Compute the averages and standard deviations for each stock. Properly treat any missing values. Plot a frequency histogram for the averages with a density fit. Add a fit based on normal distribution. Do the same for the standard deviations. Run a command summary on both the vector of the averages and the vector of standard deviations. Plot a graph on (x, y) axis with points representing the standard deviation x and the average y for each stock. Add a ticker name to each point (this can be done by a command textxy from library(calibrate)). 4. Perform a basic CAPM analysis for each stock in your SP500 data. For each stock, run regression lm(y ⇠ x), where y is a vector of returns of a given stock and x is a vector of returns of a given benchmark, in our case the SP500 index. This means in particular that you need to get the values of the index itself (ticker bGSPC) and compute its returns. Make sure that the dates of the returns are consistent, otherwise the data would be shifted and the entire analysis would give irrelevant results. Store the resulting coe cients representing ↵ and for each stock together with the P- value corresponding to the coe cient ↵. Plot the histogram of the vector of betas with the density fit and the fit based on a normal distribution. Identify the stocks at both extremes, the ones with the smallest and the largest betas. Plot the histogram of the vector of alphas with the density fit. Identify the stocks with statistically significant alphas (from the corresponding P-values). Lastly, choose one stock that you find interesting, and plot the joint returns of the stock and the index together with the corresponding regression line.
Ταυτότητα εργασίας: 16947168

Σχετικά με την εργασία

12 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
We are a team of industrial and mechanical engineers. We had done more complex finance projects (such as implementing a research article) and we are already working on implementation of HMM and random forest algorithms in Python. We have experience in R, therefore I think we are qualified for this job.
€150 EUR σε 3 ημέρες
4,9 (8 αξιολογήσεις)
4,3
4,3
12 freelancers δίνουν μια μέση προσφορά €136 EUR για αυτή τη δουλειά
Avatar Χρήστη
Hello, I can help with you in your project R Studio: Analysis of data of stocks in SP500. I have more than 5 years of experience in Econometrics, R Programming Language, Statistical Analysis, Statistics . We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
€250 EUR σε 3 ημέρες
4,8 (24 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
As an engineer in statistics and applied economics as well as a technician specializing in office computing (Microsoft Office MOS Diploma), I am able, available and ready to do this kind of work easily and quickly and under favorable conditions
€130 EUR σε 3 ημέρες
5,0 (62 αξιολογήσεις)
5,4
5,4
Avatar Χρήστη
I read the whole description, thank you first for the clarity of specification. You can visit my profile and note that all the projects I've done were using R. I can do it, but it will be costly that's why I bid with the maximum budget you set. I hope you charge me to do this. I will satisfy your request.
€250 EUR σε 5 ημέρες
4,9 (28 αξιολογήσεις)
4,9
4,9
Avatar Χρήστη
Hi, I'm familiarized with R studio analysis. I read the project content and it looks intereseting. I only need data and project instruction/details to start working on it. Regards.
€133 EUR σε 7 ημέρες
5,0 (6 αξιολογήσεις)
3,6
3,6
Avatar Χρήστη
A proposal has not yet been provided
€88 EUR σε 5 ημέρες
4,9 (2 αξιολογήσεις)
2,9
2,9
Avatar Χρήστη
A proposal has not yet been provided
€88 EUR σε 4 ημέρες
5,0 (3 αξιολογήσεις)
1,3
1,3
Avatar Χρήστη
Hi, I can do this work. Individual and hard working person done your work accurately. Waiting your response. Always I do my best & fast with on time delivery for my all clients. Please tell me what you need and how would you like to complete this project. Your project will be 100% accurate and professional. 100% satisfaction guaranteed. Fully clear communication. Continued support after done your project. Please trust me & give the opportunity. I will hope your answer. Send me a message, I’ll respond quickly. Best regards.
€150 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hi i am saprative I specialize in designing and architecture high traffic website using django. I have extensive experience in developing django based apps.I did work on Some mechanic learning and BI projects I will be giving you a solution where you can mange the whole process from the admin profile. Your work seems pretty easy project for me. Lets have a talk over chat so that I can get a context about the project.
€155 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
A proposal has not yet been provided
€55 EUR σε 4 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της GERMANY
Munich, Germany
5,0
3
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Μαΐ 11, 2018

Επαλήθευση Πελάτη

Άλλες δουλειές από αυτόν τον πελάτη

Excel and VBA
€30-250 EUR
Excel VBA project
€8-30 EUR
Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.