Thursday, June 26, 2008 at 4:18 PM
Our team is pleased to announce the release of a data API for Google Finance portfolios. This means that developers can build financial software that could give you easy access to your portfolios on your desktop, homepage, or mobile phone. If you know something about writing software and are interested in making this happen, check out the details on the Google Data API blog and let us know what you come up with!
26 comments:
This is cool, but it would also be nice to access any stock quote via API/other means. Not just our portfolio! For us aspiring quants who do computation :)
Nice API, but many Non-US stocks are missing. Would be great to use it for German stocks for example.
Is there a way to pull financial statement data for a particular ticker symbol from google finance through your API's? I'd like to write my own stock screening program.
It is a great start! it would be great to also have the S&P GICS
This is really cool. I was waiting for this feature since along..
Gr8 and Thanks Google, I have already started to link my personal alert tool to the API
Good.
But could you please implement the download function for historical exchange rates as well?
Please allow up to four decimal places! Seems like a no brainer but so many online portfolios round off to two!
Yes, with this API, we can do much more then before. Softer design becomes more easier.
I have a lot of stocks that are very sensitive to the price of oil.
Is there a feature (or a stock symbol) that allows me to pull up the current price of Light Sweet crude? It would be great if I could plot out Oil versus General Motors.
Keep up the great work folks!!
I'm slowly converting all of my friends to the google interface because it is the best thing going!
It seems you might no longer be reading comments from older posts, so I apologize up front about being somewhat off topic.
I have been banned now for 2 or 3 weeks from Google Finance Forums without what a reasonable person might call just cause. It is the general consensus that the Google Finance moderation is incoherent and not uniform in its coverage.
One fortunate user found his posts deleted with no feedback. His fortune is in the fact that he was not banned, like I was.
An example of someone else speaking on the topic:
"This is bad. First Google doesn't moderate anything, then they start deleting posts based on some obscure reasoning.
I can't imagine that anyone took enough issue with posts in *this* thread to report them. Am I wrong?
So, I'm questioning Google's policies here in an open forum. We'll see if this post remains."
This user misunderstands the policy for the forum. It is in fact NOT an open forum. It is a forum that has unenforceable or unclear rules with invisible, unaccountable, and unreachable administrators. In time I hope the moderation system becomes tenable, but as it is now it is downright frustrating.
Again, I will ask that you please remove the ban from my account at your earliest convenience. Thank you. -jhg
Not just our portfolio! Is there a way to pull financial statement data for a particular ticker symbol from google finance through your API's?
The weather API allows simple anonymous access to XML not dependent on Java through
http://www.google.com/ig/api?weather=location
Are there plans to allow anonymous access to simple quotes? It would be nice not to have to figure out authentication for each user just to get a quote.
http://finance.google.com/finance/feeds/default/portfolios/1/positions/NASDAQ:GOOG
Does anyone know how to contact Google Finance to alert them to missing tickers?
Finance requirements for financial sites: (Email me agrawalavinash1@yahoo.com for details)
Details in http://docs.google.com/Doc?id=dthcr25_138c2pjpw
a) Ability for financial writers to write commentary :
For an online user, to easily write online commentary on companies and stocks, Google Finance should be integrated with Google Docs and Spreadsheets, to easily put company charts, quotelinks etc. Also, such value links will benefit users and also Google.
For example:
http://www.tradingmarkets.com/.site/stocks/commentary/gkitermi/-67038.cfm
needs links to (a) Stock Charts(in the style that author wants), (b) when he enters stock symbols, like LEH(Lehman Brothers), GS(Goldman Sachs, etc), it should come up hyperlinked to Stock Charts, etc.
b) Things that would improve productivity, referring to:
http://finance.google.com/finance?q=amfi&hl=en :
1) Stock charts to have candlesticks, and also for them to remember my settings. For example: every time one has to hit "5y" for 5year charts; there should be a default setting avl on a computer
2) Page customizability: Ability to create gadgets I want, and then move around components of the page, for example , I would like to see company summary info near top of page, and company news to bottom of page; and ability to remove stuff one does not need, for example company blog posts.
c) Ability to rank stocks by any user specified criteria, whether price/volume or earnings, profit margins(percentage), etc
b) Ability to cut-and-paste specific stock charts very easily, and also cut-and-paste charts, or income statements etc into Google Docs or Word doc. And ability to annotate stock charts with notes, or draw trendlines etc on them etc, will help. Also this will help bloggers immensely.
c) With (b) in place, also one should easily be able to create also audio/video presentation ie commentary and maybe post them on Youtube.
d) Ability to form communities, and use Google Finance tools from (a),(b) etc: for example, either Warren Buffett followers, or Peter Lynch followers or growth stock investing followers can create a community. And using (b), they can quickly have discussions.
e) List of stocks making new 52-week highs, new 52-week lows etc everyday :
Is it possible to provide list of stocks making new 52-week highs, new 52-week lows etc everyday ? And dollar gainers, dollar losers
There IS a top movers section on the google finance page, ie http://finance.google.com, but the top movers shows only 5 stocks and that too, the criteria for the "top movers" should be settable by user.
Another enhancement that will be useful is that, as user scrolls through this list of say stocks making 52-week highs, he should be able to display their charts etc, and scroll through them too.
Customizability is key.
f) One more thing might help, is for each company, say American Home Mortgage Investment (AHM), for Google Finance to have a link to how the company and its business really works. for example, AHM provides loans and in turn gets funding from banks, brokerages etc, and in the process acts as the middleman. This might help investors make more informed decisions too. Just a thought for the future. Or maybe users get to vote on who writes the best such description and such description can be linked to , on Google Finance page for AHM stock. Right now, there ARE some user Discussions (but which are not informative) but if there is a vote system, hopefully the best Discussion will be near the top. And the Company "Summary" is present, which is informative.
g) Industry Group rankings:
It will be great to have industry group rankings, as present in
http://www.prophet.net/explore/sectorrankings.jsp
ie Industry Rankings page
along with links to the stocks within each Industry group.
Actually www.prophet.net is very good, and Googlers can look at it. And prophet.net is also based on banner ads ;-) so thats an idea for google finance
h) Social networking will play a very important role. So the aim for Google Finance would then be to provide ALL the finance tools, that would facilitate finance-related social networking.
Such tools include docs & spreadsheets, stock charts editing, detailed fundamental company information, tools for contributors to author financial commentary and maintain financial wikis/blogs, find more financial oriented people (via orkut?) and form groups there and discuss financial commentary easily (thru docs, spreadsheets, editable stock charts, detailed fundamentals etc,) meetup organization, commentators should be able to host online financial radio shows(channels), etc.
i) Stock Fundamental Data :
Following is a
Chart customizability example showing earnings (EPS) growth quarter by quarter
http://docs.google.com/Doc?id=dthcr25_13dh9fpm
that we would like to see in Google Finance
j) For investors/traders, More technical stock information like in
Market underlying technicals
Stocks making new 52-week highs
etc is essential.
h) Widget creationg (using fundamental and technical stock data) : Hello, Just like users can create widgets in GoogleMaps (for example to list real estate, gas stations, etc), Google Finance should have ability for users to create widgets, and then anyone can simply use them (aka social networking, collaboration).
For example, if one creates a stock screener based on certain criteria for stock selection, any other user should be able to add that widget to his view. GoogleMaps for example now provides such a library of gadgets.
i) Candlestick charting:
Stock charts should be customizable , for example candlestick charts, or charts with fundamental information, etc. And then such charts should be available on iPhone etc.
j) Stock Fundamental Data and Technical Charts in same chart:
For example, look at bottom-left box in http://www.investors.com/dgohelp/dgohelpweekly.gif
for CTX RYL LEN etc, these Sales % change numbers would be slowing.
Similarly, as the mid-left box in above graph shows, the annual sales would be slowing.
h) Stock Fundamental Data in Finance API:
Thank you Russell, I had looked at http://finance.google.com/finance?fstype=ii&q=CTX
but it should up to users to get the information they want, easily. for example, if I would like to build a gadget, using your database, as in : http://www.investors.com/dgohelp/dgohelpweekly.gif
that would be great. Or I could at least query, "CTX sales Q3 2006", ie Centex' sales for Q3 of 2006, and so on....
i) Live figures for number of stocks making new highs and new lows: For example, in yahoo finance, the market Overview page, the page has figures for number of stocks making new highs and new lows. Can Yahoo Finance make those live, just like the market indices are updated live.
j) Right now, we see the names of stocks that make new 52-week highs and new lows in price everyday. Can you please show stocks making new 52-week highs and new lows , sorted by Industry groups. www.Dailygraphs.com does this
k) I would like to create a Finance widget, for getting stock fundamentals and particular ratios: If I want to look up a stocks fundamentals like Cisco (CSCO) , I would like to get data from http://finance.google.com/finance?fstype=ii&q=NASDAQ:CSCO ; then extract Revenue, Profit numbers from there, and come up with my own ratios. Then I can have this widget on my page that everyone can use.
l) On Yahoo and Google Finance Stock Screener, eg : from http://screener.finance.yahoo.com/newscreener.html,
Lets say I would like a list of stocks making 52-week lows, sorted by Industry Group, so that I can know which industry groups are weak. Right now, in yahoo finance screener, I can only get the list of stocks making 52-week lows, but I cannot arrange the results based on the stock industry group. Also when I see the symbols from a stock screen and want to SCROLL down through their daily and weekly charts, right now there is no easy way; right now, I have to manually open each stock in a new window, which is painful. By moving my cursor over the symbol name, I should be able to see the stocks charts pop-up and then automatically close as I move away from that symbol. www.dailygraphs.com does this well, please take a look.
m) Incorrect links : If I look up a symbol like JFR on Google Finance, at http://finance.google.com/finance?q=jfr&hl=en, then it does not have any company website or details on what JFR does. The proper link is http://www.nuveen.com/ETF/products/fqf.aspx?fundid=JFR#Top_Holdings
n) Google finance videos: need to have more videos and videos to be from finance companies like BusinessWeek, thestreet.com, Kiplinger's, CNN Money, etc, like the videos on yahoo finance.
From http://people20.blogspot.com/2007/10/message-to-yahoo-finance-google-finance.html
Hi, i was trying out GoogleFunction for a certain Stock Research. I need one important function to the list of useful function in GoogleFinance. Just like we have yesterday closing price (closeyest), i need "Yesterday's Volume" ! I noticed u've Average Volume(volumeavg)... this is not useful for my research.
Your help is much appreciated. Keep up the good work.
Regards.
The Google FIance api is useless without support for live quotes.
Today, the Microsoft-owned in-game ad agency said that it has signed an exclusive multiyear agreement with Blizzard. Azerothians opposed to seeing in-game ads in their local world of warcft gold watering holes need not worry, however, because the deal is limited to Blizzard's Web sites and Battle.net,the game maker's online-gaming hub. Terms of the deal were not announced, but Massive did note that the agreement is applicable to users in the US, Canada, Europe, South Korea, and Australia.
buy wow gold
Massive also said today that it would be extending its aforementioned deal with Activision to encompass an additional 18 games appearing on the Xbox 360 and PC.cheap wow goldThe agency didn't fully delineate which would fall under this deal, though it did call out Guitar Hero: World Tour, James Bond: Quantum of Solace, and Transformers: Revenge of the Fallen,buy wow items as well as games in its Tony Hawk and AMAX Racing franchises.Shortly before Activision and Vivendi announced their deal of the decade,wow power leveling the Guitar Hero publisher signed on to receive in-game advertisements from Massive Inc for a number of its Xbox 360 and PC games. A bit more than a year later, Massive is now extending its reach to Activision's new power player, Blizzard Entertainment.buy wow gold from our site ,you'll get more surprises!
Today, the Microsoft-owned in-game ad agency said that it has signed an exclusive multiyear agreement with Blizzard. Azerothians opposed to seeing in-game ads in their localworld of warcft goldwatering holes need not worry, however, because the deal is limited to Blizzard's Web sites and Battle.net,the game maker's online-gaming hub. Terms of the deal were not announced, but Massive did note that the agreement is applicable to users in the US, Canada, Europe, South Korea, and Australia.
buy wow gold
Massive also said today that it would be extending its aforementioned deal with Activision to encompass an additional 18 games appearing on the Xbox 360 and PC.cheap wow goldThe agency didn't fully delineate which would fall under this deal, though it did call out Guitar Hero: World Tour, James Bond: Quantum of Solace, and Transformers: Revenge of the Fallen,buy wow items as well as games in its Tony Hawk and AMAX Racing franchises.Shortly before Activision and Vivendi announced their deal of the decade,wow power levelingthe Guitar Hero publisher signed on to receive in-game advertisements from Massive Inc for a number of its Xbox 360 and PC games. A bit more than a year later, Massive is now extending its reach to Activision's new power player, Blizzard Entertainment.buy wow gold from our site ,you'll get more surprises!
I have used the API for a while w/o problems. however, i recently start to experience problems like below. Any help will be appreciated. thanks
-----------------------------------
com.google.gdata.util.ServiceException: Bad Gateway
Server Error
The server encountered a temporary error and could not complete your request. Please try again in 30 seconds.
at com.google.gdata.client.http.HttpGDataRequest.handleErrorResponse(HttpGDataRequest.java:529)
at com.google.gdata.client.http.GoogleGDataRequest.handleErrorResponse(GoogleGDataRequest.java:555)
at com.google.gdata.client.http.HttpGDataRequest.checkResponse(HttpGDataRequest.java:480)
at com.google.gdata.client.http.HttpGDataRequest.execute(HttpGDataRequest.java:459)
at com.google.gdata.client.http.GoogleGDataRequest.execute(GoogleGDataRequest.java:527)
at com.google.gdata.client.Service.insert(Service.java:1243)
at com.google.gdata.client.GoogleService.insert(GoogleService.java:560)
-----------------------------------
mafin, I think we'll need more information in order to investigate.. ie, the URLs used (do they all fail, or are some successful?)
Does the sample client code work?
(I don't see any problems from our side in terms of the # of failed requests over the last few weeks, but I'll check in on the URls that you are using).
Please follow up in our group:
http://groups.google.com/group/google-finance-apis
Thanks!
Today, the Microsoft-owned in-game ad agency said that it has signed an exclusive multiyear agreement with Blizzard. Azerothians opposed to seeing in-game ads in their localworld of warcraft goldwatering holes need not worry, however, because the deal is limited to Blizzard's Web sites and Battle.net,the game maker's online-gaming hub. Terms of the deal were not announced, but Massive did note that the agreement is applicable to users in the US, Canada, Europe, South Korea, and Australia.
buy wow gold
Massive also said today that it would be extending its aforementioned deal with Activision to encompass an additional 18 games appearing on the Xbox 360 and PC.cheap wow goldThe agency didn't fully delineate which would fall under this deal, though it did call out Guitar Hero: World Tour, James Bond: Quantum of Solace, and Transformers: Revenge of the Fallen,buy wow items as well as games in its Tony Hawk and AMAX Racing franchises.Shortly before Activision and Vivendi announced their deal of the decade,wow power levelingthe Guitar Hero publisher signed on to receive in-game advertisements from Massive Inc for a number of its Xbox 360 and PC games. A bit more than a year later, Massive is now extending its reach to Activision's new power player, Blizzard Entertainment.buy wow gold from our site ,you'll get more surprises!
When will Finance Data API have access to the Cash account and cash-linked transactions? Thanks.
Is there any chance of getting hold of FTSE related data rather than just the NASDAQ & DOW?
I agree with @quant - there should be a sandardized API to access Google Finance data.
It is great!,Unfortunately, there is no spreadsheet of the historical data download provided in HongKong and China area. @@
Very nice, but is there an API planned for the stock screener ?
Post a Comment