• C++ Programming for Financial Engineering
    Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!
    Python for Finance with Intro to Data Science
    Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!
    An Intuition-Based Options Primer for FE
    Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

How to update and upload stock prices from yahoo/google into R ?

HedgeFudge

Joined
8/26/15
Messages
12
Points
11
Hi all ,

I am a noob when it comes to R or basically any kind of codeing . I am more of a finance guy not the quant/computing type . so bascially , i downloaded R and I want to upload the data to R so i can try to do some analysis on it , would like to know how to do the uploading and is there a way that , end of the day it automatically pulls out the data from yahoo/google and run the analysis ?
Would really appreciate some help guy ! thanks !


Regards,

Fudge
 
Try using the quantmod library. It's not really automatic, you have to run the code yourself everytime, but it downloads the most recent set of data directly into R.

The code you need should be something like this:

install.packages("quantmod")
library(quantmod)
getSymbols( "^GSPC", from="1900-01-1", src='yahoo')

You can get any quotations you want, just readjust the symbols (e.g. for apple stock type AAPL instead of ^GSPC), date and source.
 
Guys I just realized , the above methods are for uploading historical prices for one stock .
I am basically looking for writing the codes for my stratergy and then running it for the whole market . or atleast for 400 stocks . I have the data , but i want the data to update automatically and the codes to run the computations . is it possible ?
 
Back
Top