Loading Financial Data into Rapidminer

felix_w
felix_w New Altair Community Member
edited November 5 in Community Q&A

Dear Rapidminer Community, 

 

I went through some posts in the forum looking for a convenient way to load financial data (mainly stocks and indices) but I think there are only workarounds which work in some cases but nothing in general? The operators Yahoo Stock Data, Yahoo Historical Stock Data don't work? Or have I configured them wrongly?  Also the workarounds from Scott and Thomas only work partly?

 

As most of these posts are almost a year old, I wanted to ask if there was already something new? An operator which allows to load financial data? Or any new (more convenient) workarounds to load data into Rapidminer? 

 

Best regards

Felix

 

https://community.rapidminer.com/t5/RapidMiner-Studio-Knowledge-Base/Real-Time-Financial-Data-via-Alpha-Venture-API-alternative-to/ta-p/41119

 

https://community.rapidminer.com/t5/RapidMiner-Studio-Forum/Downloading-historical-financial-data-since-change-of-Yahoo-API/m-p/39145#M26819

Tagged:

Answers

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    @felix_w The Fin/Econ extension is dead and probably won't ever be updated again. Yes, there are some non-elegant workarounds but I think @sgenzer posted something about using Quandl. Have a search for that.

  • hughesfleming68
    hughesfleming68 New Altair Community Member

    In my opinion, the best way is to use R Execute. Lookup the libraries Quantmod and QuantTools which can also connect you to IQFeed if you need tick data. Quandl is also easy to set up. You may need to familiarize yourself with data frames and Posix dates and that is about it.

     

    Rapidminer + R is a formidable combination for financial analysis.

     

    Alex

  • felix_w
    felix_w New Altair Community Member

    Thank you for your replies! I will go with the easy version first and try to use quandl as I am not very familiar with R.

     

    Best regards

    Felix

  • luc_bartkowski
    luc_bartkowski New Altair Community Member

    I use Alpha Vantage. They offer a simple web-based API. They offer also live data.

    A working daily data example RapidMiner process is available here Real-Time-Financial-Data-via-Alpha-Vantage-API

    This RapidMiner model could be extended to intraday by extending the pivoting in the RM process. Intraday data includes an extra field (intraday timestep e.g. 15min, 10min, 5min, etc.) that has to be included in the process.

Categories