Closed

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

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

Skills: Data Processing, R Programming Language, Statistical Analysis, Statistics

See more: basic portfolio website template, design basic portfolio website, basic portfolio dreamweaver, investment portfolio analysis with r, finance in r, asset allocation in r, applied finance with r, learn r for risk management, intermediate portfolio analysis in r, datacamp portfolio analysis python, quantitative investment portfolio analytics in r pdf, creating basic portfolio design dreamweaver, basic portfolio dreamweaver template, make basic portfolio macromedia director, portfolio performance, data analytics hadoop r programming, freelance r programming, help with r programming project -- 3, help with r programming project 3, r programming and

About the Employer:
( 1 review ) Yuen Long, Hong Kong

Project ID: #18650433

11 freelancers are bidding on average $100/hour for this job

kannasanthosh

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 pr More

$133 HKD / hour
(69 Reviews)
6.1
MasterKym

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, wit More

$266 HKD / hour
(11 Reviews)
4.4
engineeringexp

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, resou More

$100 HKD / hour
(11 Reviews)
4.1
Baderah

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 / hour
(18 Reviews)
3.5
ricmwas

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 More

$69 HKD / hour
(3 Reviews)
1.7
peternjoroge37

I am a Professional writer with 6 years of experience in the [login to view URL] the areas I am more and comfortable in includes copy writing, technical writing, sell sheets, marketing, Law, Linguistic, Accounting, Architectur More

$72 HKD / hour
(0 Reviews)
0.0
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

$65 HKD / hour
(0 Reviews)
0.0
ignarregui

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 lear More

$66 HKD / hour
(0 Reviews)
0.0
OSolovyev

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 More

$66 HKD / hour
(0 Reviews)
0.0
frpcarvalho

Its a easy job! I will explain you very fast.

$100 HKD / hour
(0 Reviews)
0.0
kumark2008

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 / hour
(0 Reviews)
0.0