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

[HedgeFudge]

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

 

[Polter]

You can just use Quandl API from R: Quandl Financial and Economic Data

Data sources:
- Wiki EOD Stock Prices - Data via Quandl
- YFinance - Data via Quandl
- Google Finance - Data via Quandl
- Quandl Financial and Economic Data

 

[MarekSabata]

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.

 

[Martin Thomson]

Overview of financial data sources directly accessible via R interface packages

 

[HedgeFudge]

Thanks a ton guys !!

Regards,
Fudge

 

[HedgeFudge]

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 ?

 

[ExSan]

You can just use Quandl API from R: Quandl Financial and Economic Data

Data sources:
- Wiki EOD Stock Prices - Data via Quandl
- YFinance - Data via Quandl
- Google Finance - Data via Quandl
- Quandl Financial and Economic Data

is there something similar for C/C++

 

[pingu]

is there something similar for C/C++

No