Find Jobs
Hire Freelancers

Learning basic portfolio performance attribution in R programming ..can somebody take me through

$65-115 HKD / hour

Closed
Posted over 5 years ago

$65-115 HKD / hour

Hi i would like to learn how to import an excel or csv file into the Rstudio and use the pa package (performance attribution) to do some basic analysis..i am newbie in R the process i went through earlier...but failed I loaded a package called "pa" in R trying to do some basic performance attribution analysis for my portfolio, the pa package comes with its own data frame, namely "year" I tried the data (year) in the console line, it works My problem..... I tried to create/import a CSV file and I call it Rtestcsv (with all my holding and Bloomberg code) Rtestcsv I tried to type [data (Rtestcsv)] in the console, error msg pops up and said the file is not found, why? is it true the "pa" package created by Yang Lu can only apply to his own data frame? In order to use the "pa" package performance simple analysis, what should i have to do with my own data frame? coz it seems the CSV file has been successfully imported and appeared in the top right-hand R environment R environment couple of questions i would like to resolve 1) how come the csv/excel file is not able to run in the pa package? 2) for a year performance attribution analysis in my portfolio, say every month i would def buy and sell stocks ....so what's it look like for the excel data set? i only have to include every single names in my data set at every 1st day of each month with its own weighting is enough? if i sell it at the middle of the month, i dont have to capture it in that month's data set? 3) i dont have to follow the pa own package data frame column? i can still use the pa package to run the analysis by creating my own data set only capturing few columns like my Rtestcsv file? that means ignoring the "value" , "size", "growth" and "momentum"?? i think the pa Brinson model doesn't need so much data to do basic attribution analysis right? 4) possible to create some fast short cut buttons in Rstudio to run the pa analysis very quick?? I would appreciate if someone could shed me some insights to handle my issue as I am new to R Best cocochan
Project ID: 18650433

About the project

10 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $104 HKD/hour for this job
User Avatar
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in many data analytics projects involving SAS & R. Also I have worked in projects involving Excel (Pivot Table, Macros) and VBA. I believe I have enough expertise in R to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh
$133 HKD in 40 days
5.0 (69 reviews)
6.1
6.1
User Avatar
Hello, I am a data scientist and R programmer. I can sense the frustration you are feeling trying your best to get it to work, I have also been there. In fact, a lot people have. I am an enthusiast R programmer, with good spoken language and solid understanding of programming concepts, and I am willing to help you out. We can have sessions with shared screens and I will work you through how to do most of the stuff you need in R. Contact me for further discussion. Thank you
$266 HKD in 40 days
5.0 (17 reviews)
4.8
4.8
User Avatar
A Data Scientist with experience in Python, R programming, R Shiny, R studio and anything related to data science and python Master in Engineering, Electrical and Electronic Engineer, who is dynamic, reliable, resourceful, committed and organized with enthusiastic approach to succeed with a pleasant attitude. Possessing excellent analytical skill and good research background. I have successfully completed IELTS with an overall band of 7 and have a good proficiency in English 10 Years Experience in Data Science Data Visualization Power BI Tableau Business development Anything on R programming COMPLETED PROJECTS • FM radio. • VHDL Design of an Up/Down Counter. • Design of Up/Down Counter using PIC. • Duck Shooter Program using C. • Pointer movement controller on 2-dimentional axis using C. • LCD display Manipulation projects including: o Text Display o Volt-Meter • Analog to Digital Conversion (8-bit). • Sound to Light Color Organ Design and Development. • Minesweeper Player Creation using PIC. • Simulation of an End to End Communication System with MATLAB. • (BENG Individual Project) (MENG Part A). • (MENG Individual Project) (MENG Part B). • (MENG Group Project).
$100 HKD in 4 days
4.9 (17 reviews)
4.7
4.7
User Avatar
Hi, I noticed that you are having some trouble with r especially the pa package. R is a very diverse programming language and you can achieve your objective in many ways. One thing to keep in mind is that before you do an analysis on the data you need to know how to configure the data in a manner that suits your analysis. I have done a project on portfolio analysis( as you can see on my portfolio). I can share with you some of the techniques and help you improve your analysis skills. Thank you Eric M
$69 HKD in 40 days
4.9 (5 reviews)
3.3
3.3
User Avatar
I am a quantitative financial analyst with an expertise in R and Python programming. Therefore, I can solve your problem aptly. I am also CFA and FRM qualified. For more details, contact me.
$65 HKD in 40 days
4.2 (26 reviews)
3.6
3.6
User Avatar
HI!, as a student i perfectly know how is getting started in R, and i also helped a lot of my partners of the degree, so even i don't have the experience that others could have i have the skills to help someone to learn :)
$66 HKD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! Earned maths degree from the leading technical University. My thesis were on time series forecasting. Have been working with R and Python as a Data Scientist in Banking for 5+ years. Have used R and Python for data wrangling, reporting and credit scoring models development. Will be glad to help.
$66 HKD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Its a easy job! I will explain you very fast.
$100 HKD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having good excel skills & system knowledge Will be able to do any type of Data entry JPG or pdf to excel or word
$100 HKD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of HONG KONG
Yuen Long, Hong Kong
5.0
1
Payment method verified
Member since Sep 18, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.