AnsweredAssumed Answered

How to import Stock Quotes in CSV from Yahoo

Question asked by submarine on Mar 1, 2014
Latest reply on Mar 1, 2014 by 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.

Outcomes