RapidMiner

Loading Financial Data into Rapidminer

Wisdom logo Registration now open for RapidMiner Wisdom Americas | New Orleans | October 10-12, 2018   Learn More
Highlighted
Guru
Guru

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-Al...

 

https://community.rapidminer.com/t5/RapidMiner-Studio-Forum/Downloading-historical-financial-data-si...

4 REPLIES
Unicorn
Unicorn

Re: Loading Financial Data into Rapidminer

@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.

Regards,
Thomas

Blog: Neural Market Trends

RapidMiner Tutorial Videos here!

Re: Loading Financial Data into Rapidminer

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

Guru
Guru

Re: Loading Financial Data into Rapidminer

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

Re: Loading Financial Data into Rapidminer

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.