1 Reply Latest reply on Mar 1, 2014 8:58 PM by submarine

    How to import Stock Quotes in CSV from Yahoo

    submarine

      I am creating a FileMaker GO file which will I get live or delayed stock quotes from Yahoo Finance. I am hoping to get the quotes and put it into a field and performing calculation on other financial ratios.

       

      This website (http://www.gummy-stuff.org/Yahoo-data.htm ) shows how to get quote from Yahoo but it is in CSV format, eg

      http://finance.yahoo.com/d/quotes.csv?s=BBDB.TO+NT.TO+GE+MSFT&f=snl1d1t1ohgdr

       

      If I paste the link above on my browser address it downloads the csv file on my desktop. but when I use insert from URL to get the file in FileMaker, it returns the code below

       

      <HEAD><TITLE>Redirect</TITLE></HEAD>
      <BODY BGCOLOR="white" FGCOLOR="black">
      <FONT FACE="Helvetica
      "<em>http://download.finance.yahoo.com/d/quotes.csv?s=

      BBDB.TO+NT.TO+GE+MSFT&f=snl1d1t1ohgdr

      /em>".<p></B></FONT>

      <!-- default "Redirect" response (301) -->
      </BODY>

       

       

      I wonder where did I do wrong.