Stock quotes

[Drew Sanderson]

How would you pull a stock quote into a Go solution? I am not talking about just displaying something like google finance but rather capturing the actual stock price and placing it in a field.

[Lee Smith]

Do a search in "AppShopper" for stocks and you will get over 300 hits. Surely one of those will work for you?

[Drew Sanderson]

I think you missed what I am after. This is not for simple stock price so one of the many stock quote apps won't work. I need the raw stock price placed into a FileMaker field. A site that returns XML when in a web-viewer would work great. I use a web-service in pro but since there are no plugins with GO, I have to use the web-viewer.

Got it...

http://www.google.com/ig/api?stock=aapl

[Lee Smith]

I was with you right up to your last two wards

[Drew Sanderson]

I have been trying to find an answer for a long time... I think I just had to post to a forum before I could find the answer for myself I was looking at using YQL but never got the syntax quite right.

[org]

Was looking at this myself tonight - first play had with FM12 - pretty cool!

--

Used new 'Insert from URL' FM12 script step - see file attached

note: for FM11 could use BaseElements plugin or Webviewer scrape

--

Notes

- quick google showed yahoo URL method using Yahoo's CSV results - Yahoo don't seem to offer a REST service - imagine due to licensing restrictions with exchanges

- the chart is a standard yahoo api.

Cheers

Olly

GetStockQuotes.fmp12.zip

[Drew Sanderson]

That is very interesting... I will have to dig into it. I had looked at the Yahoo csv which worked great for Pro but I could not figure out what to do with it in Go. Insert in from URL has a lot of potential. I wish you could point it to a variable but a global works. Thank you so much for sharing. Great demo file :)

[org]

Just spotted your link to Google API above,

Turns out can also get batch of stocks in one hit from Google API in JSON. (including from multiple exchanges)

Example:

http://finance.google.com/finance/info?client=ig&q=NASDAQ:GOOG,NASDAQ:YHOO,LSE:TSCO,TYO:6758

e.g.

TYO:6758 = Sony as listed on Tokyo Stock Exchange

Needs prefix of each exchange & stock symbol to work - makes sense as TSCO symbol in UK is diff company form TSCO in US

Imagine there's is a limit on free calls via Google API - not had a look through Google's Terms

Seems to be a list of relevant Google exchange prefixes here. http://www.google.co...nce/disclaimer/

Cheers

Olly

[Matt Malyschko]

Was looking at this myself tonight - first play had with FM12 - pretty cool!

--

Used new 'Insert from URL' FM12 script step - see file attached

note: for FM11 could use BaseElements plugin or Webviewer scrape

--

Notes

- quick google showed yahoo URL method using Yahoo's CSV results - Yahoo don't seem to offer a REST service - imagine due to licensing restrictions with exchanges

- the chart is a standard yahoo api.

Cheers

Olly

 

This was great! Thanks heaps!!

[Calvin Tomm]

Hi Org

I just downloaded your GetStockQuotes and it is exactly what I'm looking for... if it would work. It worked once the first time and now I get a message box saying Message Failed. Could you please look into it? Thanks!

Calvin