Loading Financial Data into Rapidminer

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

Find more posts tagged with

AI Studio

Finance

Accepted answers

All comments

Thomas_Ott

@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

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

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

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.