R programming

I just started a class in Computational Finance and Financial Econometrics. Most of the financial modeling is done in Excel but we are also using R. I was wondering if R is gaining popularity in the financial sector. I know most quants use scripting languages such as C++/Pear/Python/Java and some of the common statistical software packages are E-views/SAS/Matlab. R is similar to the other software packages but the major difference is that its free which is why I was wondering if it's and up and coming analytic took that analysts are using on the job.

10 Comments
 

R is now probably the most popular statistical language by sheer number of users but SAS is still more common because a) open source scares most corporate types and b) R has no real support to speak of.

Making money is art and working is art and good business is the best art - Andy Warhol
 

I am definitely a SAS guy. I work for a government statistical agency and our in house software is SAS because it can handle much larger data sets and can be run off a Unix server. I guess I'll continue to learn R and expand my resume by 1 letter. Thanks for the feedback

 

Anyone have good links on R reading data from Excel, run script, and export results back to Excel? I'd love to read more about about it. I have a little experience with R and a shit ton of experience with VBA.

I'll do what I can to help ya'll. But, the game's out there, and it's play or get played.
 
pplstuffAnyone have good links on R reading data from Excel, run script, and export results back to Excel? I'd love to read more about about it. I have a little experience with R and a shit ton of experience with VBA.
 
pplstuffAnyone have good links on R reading data from Excel, run script, and export results back to Excel? I'd love to read more about about it. I have a little experience with R and a shit ton of experience with VBA.

There are some really good youtube videos on importing/export data files from various formats. I recommend videos by "economicurtis". Basically, its a pain to import/export spreadsheets in .xls format. Its recommended that you save the spreadsheet as .csv which is much easier to read into R.

 
pplstuffAnyone have good links on R reading data from Excel, run script, and export results back to Excel? I'd love to read more about about it. I have a little experience with R and a shit ton of experience with VBA.
I faintly remember there being an addin for excel that allows you to write macros that use R without leaving excel. Other than that here is a section talking about reading excel: http://cran.r-project.org/doc/manuals/R-data.html#Reading-Excel-spreadsheets
Making money is art and working is art and good business is the best art - Andy Warhol
 

R is worth learning. I fucking love it -- use it every day, even for things I could easily do in Excel (I prefer R's visualization tools). Admittedly, I haven't seen it used in finance all that much (financial types would rather spend $2,000 on an equivalent technology since 'costs money' is corporate speak for 'risk management').

 

Dignissimos necessitatibus ea quibusdam quisquam eius minus. Voluptatem velit officiis ratione perspiciatis voluptas. Minima unde culpa blanditiis maiores asperiores quia. Molestias cum repellat natus cum.

I'll do what I can to help ya'll. But, the game's out there, and it's play or get played.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (65) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”