Has anyone connected to Yahoo Finance or ETrade? I want to pull stock data.
In my opinion, the two Quandl connectors will not work anymore. I've recently found http://www.eoddata.com/default.aspx for daily quotes and https://intrinio.com/ for financial data like 10-K filings.
At the end of the day, if you really want robust API's with all the info you need, you're going to have to pay for it.
I do appreciate everyone's help on this!
@christophorce - I didn't see any specific connectors that pull Yahoo Finance or Etrade, however if you go into your DataCenter and look for the Quandl Connector you'll see some files that might you what you are looking for -
"NASDAQ-100.zip"
"EndofDayStockPrices.zip"
Take a look and see if those meet your needs!
Google Sheets using Googlefinance formula works great.
https://support.google.com/docs/answer/3093281
Worked like a charm! Great tip. Thanks!
@Dani, you should make this a KB article and show step-by-step building financial charts in Domo via Google Sheets. Took 1 min to set up.
I meant @DaniBoy
Hi all - I set up a Google Sheet to pull the stock price for one of our clients and in the Google Sheet the data returned looks great, like this:
But everytime I try and connect using the Google Sheets connector it does not return any values (and I have double checked it's referencing the right sheet name). I think it has to do with the cell values containing a forumla because when I copy and paste values, then the data comes through the connector just fine. Is anyone else having an issue with the cells that contain a forumla not coming through the connector?
Thanks!
Formulas in general work great, I just tested it out again to be sure and the values come across clean.
In the Google article mentioned above (https://support.google.com/docs/answer/3093281) it states:
This seems to be specific to the GOOGLEFINANCE function. I tried many other functions and they all work as expected.
Ahh, thanks @n8isjack-ret! I didn't catch that the historical data is known to result in #N/A errors. Bummer, but glad it's not all formulas. Thank you!
@christophorce,did any of the above replies help you out?
i tried using the google sheets approach. unfortunately it would only work some of the time. When DOMO would update, most of the cells just said "updating..." I'd have to go into the sheet and basically refresh it, then the import would work. It was too unreliable.
@Bulloko @n8isjack-ret @Millhouse
Any thoughts on this?
Thanks!Dani
@Sweep_The_Leg there is a way, using Yahoo finance, to get stock information into Domo. It is very flexible and can provide a LOT of good information.
NOTE: This is not a basic process. An understanding of web url manipulation will help. You may need to study the Yahoo API documentation as well.
I will do my best to present the steps here. Note that these steps may change over time. They work well today but if the Yahoo API changes there may be differences when you are implementing this process.
RESOURCES:
STEPS to build the connector:
HOW TO build the URL (for 3.2 above):
When you're done, save and run the dataset. It will import the data from Yahoo. You can schedule it for whatever timeframe you want it to run.
NOTE: Domo will not know the column names. The Yahoo API does not return those. So each column will be called simply: COLUMN1, COLUMN2, etc... You will have to run the dataset through a Blend or ETL to rename the columns.
Good afternoon,
Well the Yahoo API worked great... until yahoo shut it down on 11/1. I'm back to trying our Quandl connectors, but even those aren't working right. The End of Day Stock quote connector isn't showing any data for 11/8 (yesterday's close) and the Zacks ZIP file was discontinued in Sep 2016 (this was confirmed by my reaching out to Quandl directly).
I'm trying other free API that I can find on the net, but nothing seems to be what I need. All I'd need, bare bones, is an API that collects historical price data, at time of market close, and the associated Symbol.
Anyone else have any suggestions?
@Sweep_The_Leg thanks for the update!
@n8isjack-ret @Bulloko
Any thoughts on this thread given Yahoo's closure of their API?
Dani