RapidMiner

Yahoo Historical Stock Price Operator is not returing data

SOLVED
Contributor II

Yahoo Historical Stock Price Operator is not returing data

Yahoo Historical Data is returning empty values in rapidminer, is there any bug ?

I was able to download rawdat from yahoo finance website, but this operator is unable to do it.

Attachments

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator
Solution
Accepted by topic author pradeep
‎04-24-2017 11:39 AM

Re: Yahoo Historical Stock Price Operator is not returing data

Hi Pardeep. 

 

Just do a search for how to do it on the Community. Here's a great response from Ingo: http://community.rapidminer.com/t5/RapidMiner-Studio-Forum/Import-XML-code-to-process/m-p/32606

Super Contributor
Solution
Accepted by topic author pradeep
‎04-24-2017 11:38 AM

Re: Yahoo Historical Stock Price Operator is not returing data

 

Dear all,

 

In the current version you have to click on menu view -> show panel -> XML. Then you can paste the XML code in the new XML windows and confirm with the green checkmark.

 

Cheers

Sachs

19 REPLIES
Regular Contributor

Re: Yahoo Historical Stock Price Operator is not returing data

Yes, I noticed the same thing. And another app I use to download data from Yahoo (YLoader) won't work either -- it throws a "HTTP response error 301"

Anyone else?

Regular Contributor

Re: Yahoo Historical Stock Price Operator is not returing data

Yes, I noticed the same thing. And another app I use to download data from Yahoo (YLoader) won't work either -- it throws a "HTTP response error 301"

Anyone else?

Contributor

Re: Yahoo Historical Stock Price Operator is not returing data

I'm suffering this malfunction also. Please can someone help?

Thanks a lot

 

Regular Contributor

Re: Yahoo Historical Stock Price Operator is not returing data

I've confirmed with another software vendor the problem is with Yahoo changing their protocol: "The main fix in version 4.10 is for error 301 when downloading Yahoo data, which was due to a change in the Yahoo protocol." The Yahoo Historical Stock Data operator is in the Finance and Economic Data extension provided by BroadReachAnalytics. Visiting their URL provided in the RM documentation (http://www.broadreachanalytics.com/) it appears they are no longer active. RapidMiner: Is there any opportunity to update this operator? Thanks.
Contributor

Re: Yahoo Historical Stock Price Operator is not returing data

Hello my friend thankyou so much

Highlighted
Moderator

Re: Yahoo Historical Stock Price Operator is not returing data

Yes, I can confirm that this is no longer working and BroadReachAnalytics appears to be gone.

 

With RapidMiner, you can always find a work around and here it is. 

 

<?xml version="1.0" encoding="UTF-8"?><process version="7.4.000">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="7.4.000" expanded="true" name="Process">
    <process expanded="true">
      <operator activated="true" class="open_file" compatibility="7.4.000" expanded="true" height="68" name="Open File" width="90" x="45" y="34">
        <parameter key="resource_type" value="URL"/>
        <parameter key="url" value="http://www.google.com/finance/historical?q=NASDAQ%3AGOOGL&amp;ei=u5z8WJGtC8ejeeqWgbgJ&amp;output=csv"/>
      </operator>
      <operator activated="true" class="read_csv" compatibility="7.4.000" expanded="true" height="68" name="Read CSV" width="90" x="179" y="34">
        <parameter key="column_separators" value=","/>
        <list key="annotations"/>
        <list key="data_set_meta_data_information"/>
      </operator>
      <connect from_op="Open File" from_port="file" to_op="Read CSV" to_port="file"/>
      <connect from_op="Read CSV" from_port="output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>
Community Manager

Re: Yahoo Historical Stock Price Operator is not returing data

Hi...I have moved over to "openexchangerates.com" which has a nice API. I built a simple app for an accounting client using the API on RM server. Send me a PM if you want to see it.

Scott
Scott Genzer
Senior Community Manager
RapidMiner, Inc.
Super Contributor

Re: Yahoo Historical Stock Price Operator is not returing data

 

Hi Thomas,

 

Thanks for that work around. I can confirm that it works pretty well with a single symbol. However, is there also a way to load multiple symbols at a time?

 

From your tutorials I know that it is possible to append several single symbols but in this case I want to download about 20. Searching the internet I found a site (LINK) which describes a select query but I couldn't manage to get this working in Rapidminer... Smiley Sad

 

 

Kind regards

Sachs

Contributor II

Re: Yahoo Historical Stock Price Operator is not returing data

Hello Sachs,

 

 

I am new for Rapidminer,

could you please help me out in using 'xml code' for Yahoo Historical Stock price operator, which has been provided Thomas,

using it in Rapidminer?

 

Thanks