New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Version 2 Update - IEX Cloud #557

Open
joshuablackburn-iex opened this Issue Nov 7, 2018 · 147 comments

Comments

Projects
None yet
@joshuablackburn-iex
Copy link
Contributor

joshuablackburn-iex commented Nov 7, 2018

Hi everyone,

We've been hard at work over the last 9 months on the next version of the API. We looked at all your feedback and set out to build a platform that can scale to meet your needs, add new services, and be a sustainable business. We didn't want to just give you a couple of upgraded endpoints, but to address all the issues that frustrate you when trying to build financial apps. It became clear early on that we wouldn't be able to deliver on our vision with the existing exchange API. So we created IEX Cloud.

IEX Cloud is a new venture of IEX Group that makes it easier for you to build financial apps and integrate data into your existing apps. IEX Cloud is our way of addressing issues you've raised allowing you, the developer, to get back to what you really want to do. Just build.

Using our unique position in the market, we negotiated a new, unprecedented partnership to bring you the highest quality financial data. We are working on additional financial data partnerships, but also other unique data sets. We want to use our resources to bring you the best rather than give you a bunch of average choices to sift through.

As an organization, we’ve developed many large scale services to run our business and want to make them available so you can offer scalable features to your users without hundreds of hours of development time. There will be a few at launch like real-time alerts, real-time rules engine, UI widgets, and message streaming. This is an area we plan to be very active to help you scale your apps.

IEX Cloud will introduce a pricing model to make this a sustainable business, but not like you’ve seen before. We think it is prohibitively expensive to get data and services you need to test a new idea, and terms of use don’t focus on developer needs. So we are going to simplify everything. Investors Exchange data will continue to be redistributed by IEX Cloud free for everyone. We think the whole point of building apps is to display data to your users, so all data can be displayed to your users without additional cost. We don’t think you should have to research hundreds of providers and sign multiple contracts, so we got rid of contracts, and everyone has access to all core data. We also think there is a fairer, more accessible way to price these services, so there will be three simple plans. Free, $9 per month, and $499 per month. Plans are based on usage with an option to pay-as-you-go. These are unheard of prices for the caliber of data we will provide, and again, Investors Exchange data will continue to be redistributed by IEX Cloud for free.

IEX Cloud will officially launch early 2019 with early access to our beta next month to those that sign up at https://iexcloud.io Signing up will get you a beta invitation and allow you to stay up-to-date on our release details.

Our goal is to make IEX Cloud closely compatible with the current API to reduce code changes. Some endpoints may be marked for deprecation, and there may be minor changes to existing endpoints to fix data consistency issues. We are planning to sunset all non Investors Exchange data endpoints in the current IEX Exchange API on May 1, 2019.

We’d love to get your feedback on IEX Cloud. Post any questions, concerns, or suggestions. If you have coded a library, integrated our data into your app, or have a testimonial and would like to be featured on the new site, email us at support@iexcloud.io

We look forward to seeing you all on the new platform.

@JMCA2

This comment has been minimized.

Copy link

JMCA2 commented Nov 7, 2018

Will you offer, at least, free End of Day prices from other exchanges?

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 7, 2018

The free tier will provide enough usage where you'll be able to get end of day prices for equities.

@cwood119

This comment has been minimized.

Copy link

cwood119 commented Nov 7, 2018

Will version 2 be expanding coverage of the earnings endpoints? I've noticed a substantial difference in the number of daily announcements coming back from the /today-earnings endpoint vs the Zacks api and other earnings calendars on the web.

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 7, 2018

@cwood119 Yes it will. We have partnered with one of the best providers out there.

@professorDante

This comment has been minimized.

Copy link

professorDante commented Nov 7, 2018

Will we be able to source live or 15 min delayed options chains?

@idratherjack

This comment has been minimized.

Copy link

idratherjack commented Nov 8, 2018

I think it's a great approach, and funding it with a sustainable business model. Having worked with a lot of (expensive) data vendors in the past, I think your approach is a much welcomed, modern way of servicing this part of the market. Looking forward to learn about the new partnerships and start working with your new innovations.

@f2calv

This comment has been minimized.

Copy link

f2calv commented Nov 8, 2018

If we end up paying for data could you confirm we won't then need to "attribute" that the data is then coming from IEX?

I have no problem paying a reasonable rate for good quality data - but everyone is using data differently. Looking at the pricing options - could you give some more clarity to the levels/options;

  • start
  • launch
  • scale

e.g. a financial geek/hobbyist wishing to use to use closing prices of all 7000+ stocks/ETFs/etc to rebuild their "for fun" models on a daily basis, would that then constitute a "scale" user?

@stanley3333

This comment has been minimized.

Copy link

stanley3333 commented Nov 8, 2018

so when is the old api (V1) going to be shut down?

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 8, 2018

@professorDante We plan to introduce end of day options first, then 15 min delayed.

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 8, 2018

@stanley3333 The exchange will continue to offer the v1 API. The current plan is to retire non Investors Exchange data from the v1 API in May 2019.

@Polkm

This comment has been minimized.

Copy link

Polkm commented Nov 8, 2018

Will there be free or premium after hours chart data? Will there be any significant key renaming within JSON objects? Are you still going to allow CORS requests from all domains? Will the plans be throttling requests by IP or API key?

@stanley3333

This comment has been minimized.

Copy link

stanley3333 commented Nov 8, 2018

ok, so how can I identify non Investors Exchange data?
I guess Financials
https://api.iextrading.com/1.0/stock/aapl/financials
and every data not generated from IEX is then going to be retired in May 19?

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 8, 2018

@stanley3333 It will essentially be everything under "Stocks" except the two IEX endpoints. The contract providing existing 3rd party data will expire and our new partners are providing data on IEX Cloud.

@JoeSalmeri

This comment has been minimized.

Copy link

JoeSalmeri commented Nov 8, 2018

@joshuablackburn-iex

Can we get some more details on what is included in the different levels? (Free, $9 per month, and $499 per month).

Is there a document that explains the different levels?

The 3 endpoints I currently use are quote, stats, and dividends.

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 8, 2018

@JoeSalmeri We will definitely provide more details. Working on the full site right now which will provide much more detail.

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 8, 2018

@Polkm Chart data will still be available. Free and paid users have access to all data. We don't plan to rename JSON objects to make it as easy as possible to migrate. CORS requests from all domains will still be supported. Throttling will be by IP and we plan to keep generous request limits.

@roblav96

This comment has been minimized.

Copy link

roblav96 commented Nov 8, 2018

@joshuablackburn-iex

This worries me:

SCALE: $499/MO

Could you define what scale entails?

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 8, 2018

@roblav96 It represents a very large amount of data and service usage. Almost all individual users will be able to do what they need at $9. We actually made a usable product at $9. The higher plan is geared towards businesses who have very heavy use.

@calbot

This comment has been minimized.

Copy link

calbot commented Nov 8, 2018

@joshuablackburn-iex Will the pricing be subject to change once subscribed?

@devduke

This comment has been minimized.

Copy link

devduke commented Nov 8, 2018

@joshuablackburn-iex We're currently building a site that uses v1 of the Websocket and REST API.

Are the API endpoints in v2 going to be the same as v1 but with the version number changed?
(ie. https://api.iextrading.com/2.0/stock/aapl/quote)?

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 8, 2018

@devduke The base URL will change, but the goal is to keep a majority of the current endpoints intact.

@bkcollection

This comment has been minimized.

Copy link

bkcollection commented Nov 8, 2018

Is making an app to display stock price for user to use for free still enjoy FREE tier with iex cloud? Let said 100,000 user daily.

@blafarm

This comment has been minimized.

Copy link

blafarm commented Nov 10, 2018

Can you please comment on whether or not IEX Cloud will launch with enhanced Excel API calls? More specifically, I'm wondering if IEX Cloud will provide access to more data points, and discrete calls for those data points that don't require parsing out a long comma delimited strings. Looking forward to the launch. Thank you.

@mortenc

This comment has been minimized.

Copy link

mortenc commented Nov 11, 2018

@joshuablackburn-iex Thanks for the update, very excited to check out IEX Cloud!

Can you provide some further details on whether you'll also be expanding the datasets as part of IEX Cloud? The sign-up page says "New partnerships bring you the best available third-party data including U.S. & International equities (...)" – does that mean we might see support for European exchanges? 🤞

Thanks

@devduke

This comment has been minimized.

Copy link

devduke commented Nov 12, 2018

@mortenc @joshuablackburn-iex I second this question but for Canadian Exchanges.

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 12, 2018

@mortenc @devduke We will definitely have international exchanges! When the beta opens it will probably include just the data we have now, but we will aggressively add in the new datasets we now have access to. International expansion will ordered by demand.

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Nov 12, 2018

@bkcollection Our free tier does allow displaying data to users, but for non commercial use only. If that is your use case, then you should be fine. Free tier will have unlimited access to IEX data, but will have a lower limit of messages for other data. If you are serving your users IEX prices you'll be fine.

@blafarm

This comment has been minimized.

Copy link

blafarm commented Nov 13, 2018

@joshuablackburn-iex Regarding my question above about Excel integration, did I misunderstand the scope of IEX Cloud? Is the feature set not at all applicable to Excel WEBSERVICE calls? Thank you.

@kwandrews7

This comment has been minimized.

Copy link

kwandrews7 commented Feb 5, 2019

I'd be ok with a query param. But I would definitely also be another vote for keeping it available in the quote endpoint. Right now, I've integrated a hubot chat package with IEX that allows people to get data on a given symbol. Using the the quote endpoint, I don't need to cross reference any other apis. Just the single quote API.

@nickkraakman

This comment has been minimized.

Copy link

nickkraakman commented Feb 5, 2019

Hi, I was excited to use the original IEX API, but found some limitations in the data that was returned by the /financials endpoint. Specifically, me and other users (see #309 #415 #72 #73 and #498) are missing Current Liabilities, which is needed to calculate the often used Current Ratio for a company.

When I heard about version 2 of the API, I immediately registered for the beta. I just received my invite and immediately checked it out, but unfortunately no extra data points seem to have been added to the /financials endpoint. Current Liabilities is still missing.

It is cool that a lot of fancy data sets are being made available in version 2, but maybe the core endpoints should be improved first. Are there plans to make more data available through the /financials endpoint?

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Feb 5, 2019

@nickkraakman
Please check the balance sheet endpoint
https://iexcloud.io/docs/api/#balance-sheet

Our financials are far more extensive now. The /financials endpoint in the docs needs to be updated, but we now have cash flow, balance sheet, and income statement.

https://iexcloud.io/docs/api/#cash-flow
https://iexcloud.io/docs/api/#balance-sheet
https://iexcloud.io/docs/api/#income-statement

@nickkraakman

This comment has been minimized.

Copy link

nickkraakman commented Feb 5, 2019

@joshuablackburn-iex wow!! I totally missed that one! Seems like the /financials endpoint is left as is for backward compatibility. Amazing job on the financial statement endpoints, now I can fully start implementing the API!

@cwood119

This comment has been minimized.

Copy link

cwood119 commented Feb 5, 2019

@joshuablackburn-iex

Those are already available on Cloud. https://iexcloud.io/docs/api/#estimates

Any plans to add the "next earnings date" to this endpoint so we can show when the earnings announcement is estimated to occur?

@StockConsultant

This comment has been minimized.

Copy link

StockConsultant commented Feb 5, 2019

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Feb 5, 2019

@cwood119
Rolling this out now.

@nickkraakman

This comment has been minimized.

Copy link

nickkraakman commented Feb 6, 2019

@joshuablackburn-iex in the docs for the "balance sheet" endpoint, the following is said:

"Pulls balance sheet data. Available quarterly (4 quarters) and annually (4 years)"

However, when I make a request using ?period=quarter or ?period=annual, only 1 quarter or 1 year of data is returned, even though 4 quarters or 4 years of data should be available according to the above statement. Is there a way to return all 4 periods of data?

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Feb 6, 2019

@nickkraakman
You're able to pass a param called 'last' which will specify the number of quarters or years to retrieve. I updated the docs to make it more clear.

@chticer

This comment has been minimized.

Copy link

chticer commented Feb 7, 2019

@joshuablackburn-iex

Thanks for the hard work with the people involved in IEX Cloud. I am able to get the company name from the quote endpoint now.

I am also seeing some mutual fund information being available, even though it's just the company name. Love seeing the progress being made.

@stanley3333

This comment has been minimized.

Copy link

stanley3333 commented Feb 8, 2019

@joshuablackburn-iex
"You're able to pass a param called 'last' which will specify the number of quarters or years to retrieve. I updated the docs to make it more clear"

This still only shows the last record:
https://cloud.iexapis.com/beta/stock/aapl/cash-flow?period=annual&last=4
https://cloud.iexapis.com/beta/stock/market/batch?symbols=AAPL&types=balance-sheet&last=4&period=quarter

Other improvements that would be great:
-historical shares outstanding is missing, should be included in income statement or balance sheet historical data
-pull historical annual AND quarterly fundamental data (balance sheet, cf, income) in ONE call
-longer history of fundamental data. 10 years / 10 quarters
-analyst estimates: Sales and EPS Estimates for the next 2 future quarters / 2 next fiscal years
-analyst estimates: EPS Long-Term growth rate (5years)

  • the Message quota per month of 500.000 for "Start" is really low. This lets one pull 166 times the balance sheet for one period for one symbol. Not much, especially when testing.
@myanalysis

This comment has been minimized.

Copy link

myanalysis commented Feb 8, 2019

I see on the Counsel page the Mutual Funds have been Updated but on the Documents page it still says [In Development].
I have several phone Apps sitting around waiting on access to this this. Any updates on how to use?
Awesome stuff. Very excited. Thanks!

screen shot 2019-02-09 at 2 12 48 am

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Feb 8, 2019

We have to update the docs, but if you already have mutual fund or OTC symbols, you can pass them to
/chart
/company
/financials
/previous

@joshuablackburn-iex

This comment has been minimized.

Copy link
Contributor Author

joshuablackburn-iex commented Feb 8, 2019

Sign up is now open for IEX Cloud at https://iexcloud.io/

The api is currently beta, but we have extensive, high quality data and adding more daily.

@joshuablackburn-iex joshuablackburn-iex unpinned this issue Feb 8, 2019

@Itsme23333

This comment has been minimized.

Copy link

Itsme23333 commented Feb 11, 2019

Near the beginning of the thread, joshuablackburn-iex said:

The free tier will provide enough usage where you'll be able to get end of day prices for equities.

How would we go about doing this? Since it's adjusted data, I think that we would need to download the entire history for any given stock each day. I just downloaded the 5 year history for AAPL, and it cost me 12,590 messages out of my 500,000 limit for the free tier. With 21 trading days per average month, that means that the free tier would almost permit me to download the complete history of two stocks each trading day of the month. Even with the $9.00 tier, I could only download the complete history of 20 stocks every day.

So using very round numbers, at $1 / million additional messages, it would cost me $59 per month to download the history for 200 stocks every day, and $559 per month to download the history for 2000 stocks every day. Of course at that point it would be cheaper to just switch to the scale plan and pay $499 per month. But there are several places that provide this type of data for $10 - $20 per month. Of course you are free to charge what you like just as I am free to find another provider.

I realize that it's possible to just download the current day's data, and append it to the existing file, but then you have to have a factor available to adjust the prior data. I can do it, but I can't do it without some type of multiplier column, and then everything becomes much more error prone anyway.

Using the version 1 API, I can pull the complete history of about 8800 stocks in 3 minutes. I'm amazed by how well this performs. I hope that you can find a reasonable way of pricing the new version of the API so that I can continue using your services.

@stanley3333

This comment has been minimized.

Copy link

stanley3333 commented Feb 11, 2019

@Itsme23333
@joshuablackburn-iex
I can only second that. With the free tier one doesn't get far.

@radikal9

This comment has been minimized.

Copy link

radikal9 commented Feb 11, 2019

How do we get realtime OCHL data for a stock and not 15 minute delayed quotes?

@JohnRobson

This comment has been minimized.

Copy link

JohnRobson commented Feb 11, 2019

Using the version 1 API I can pull the complete history of about 8800 stocks in 3 minutes. I'm amazed by how well this performs. I hope that you can find a reasonable way of pricing the new version of the API so that I can continue using your services.

I agree with @Itsme23333 , I believe that Version 2 should keep all the features of version 1 + new features. I mean not only the technical stuff but also keep the free services.

There are a lot of space for Version 2 make a profit, but if it won't keep a wide base package of free services compatible with version 1, for the long term will be better to use other competitors services.

@xmanko

This comment has been minimized.

Copy link

xmanko commented Feb 11, 2019

Would it be possible to get for free (data weight=0) the "report date" field for the lasted financial statement available( i.e "Balance Sheet", "Income Statement" etc) ?
So I can only request a new financial statement if the one I already have is outdated.

@bishinew

This comment has been minimized.

Copy link

bishinew commented Feb 12, 2019

How to get quote for index such as Dow, Nasdaq and S&P 500?

Thanks

@blafarm

This comment has been minimized.

Copy link

blafarm commented Feb 12, 2019

@joshuablackburn-iex

Eight days ago I posed some questions regarding single cell WEBSERVICE calls in Excel that have not been answered. So, seven days ago I sent the same questions to support@iexcloud.io, but I've not received a response. I would like to present them again in the hopes of learning the answers:

  1. I am having trouble finding in the docs the exact formula structure for single cell WEBSERVICE calls in Excel. I found this in my account console and it works:

=WEBSERVICE("https://cloud.iexapis.com/beta/iex/tops?symbols=AAPL&token=pk_xxxxxxxxxx")

However, I cannot get any other single cell Excel WEBSERVICE calls to work. For example, after reviewing the documents, I would have thought this formula would work but unfortunately it doesn’t:

=WEBSERVICE("https://cloud.iexapis.com/beta/iex/stock/AAPL/quote/latestPrice&token=pk_xxxxxxxxxx")

Can you please provide me with the exact syntax for single cell Excel WEBSERVICE calls?

  1. Is there any known way to make IEX Cloud work with single cell calls in Google Sheets ?

  2. Do you have a general sense for when the Dividend metrics will be available via single cell WEBSERVICE calls?

  3. Do you have a general sense of when the "next earnings date" metric will be available via a single cell WEBSERVICE call?

Thanks very much for your support,

@curtcotner

This comment has been minimized.

Copy link

curtcotner commented Feb 13, 2019

@joshuablackburn-iex

Eight days ago I posed some questions regarding single cell WEBSERVICE calls in Excel that have not been answered. So, seven days ago I sent the same questions to support@iexcloud.io, but I've not received a response. I would like to present them again in the hopes of learning the answers:

  1. I am having trouble finding in the docs the exact formula structure for single cell WEBSERVICE calls in Excel. I found this in my account console and it works:

=WEBSERVICE("https://cloud.iexapis.com/beta/iex/tops?symbols=AAPL&token=pk_xxxxxxxxxx")

However, I cannot get any other single cell Excel WEBSERVICE calls to work. For example, after reviewing the documents, I would have thought this formula would work but unfortunately it doesn’t:

=WEBSERVICE("https://cloud.iexapis.com/beta/iex/stock/AAPL/quote/latestPrice&token=pk_xxxxxxxxxx")

Can you please provide me with the exact syntax for single cell Excel WEBSERVICE calls?

  1. Is there any known way to make IEX Cloud work with single cell calls in Google Sheets ?
  2. Do you have a general sense for when the Dividend metrics will be available via single cell WEBSERVICE calls?
  3. Do you have a general sense of when the "next earnings date" metric will be available via a single cell WEBSERVICE call?

Thanks very much for your support,

I had the same problem. Josh said to use this url:
=WEBSERVICE("https://cloud.iexapis.com/beta/stock/AAPL/quote/latestPrice&token=pk_xxxxxxxxxx")

@wbhern

This comment has been minimized.

Copy link

wbhern commented Feb 13, 2019

@blafarm -- your syntax is wrong in the second example. Try the following:

=WEBSERVICE("https://cloud.iexapis.com/beta/stock/AMZN/quote/latestPrice?token=pk_xxxxxxxxxx")

(You have an extraneous /IEX in your path, and the token should be preceded by the ? as the querystring beginner, not with an & as if latestPrice was also part of the querystring.)

I'm not an xPath maven, but you should also be able to use the FILTERXML command combined with WEBSERVICE so that you could use larger scoped (i.e., non-single-cell) queries and still provide cell-by-cell results.

@blafarm

This comment has been minimized.

Copy link

blafarm commented Feb 17, 2019

Just a quick note: Both the Excel and Google Sheets examples in the current version of the documentation are incorrect. You need to use double quotes and not single quotes. https://iexcloud.io/docs/api/#excel-how-to

@blafarm

This comment has been minimized.

Copy link

blafarm commented Feb 17, 2019

@curtcotner
@wbhern
Thank you.

@bishinew

This comment has been minimized.

Copy link

bishinew commented Feb 17, 2019

How to get index Quote like DJI or IXIC etc? Thanks

@KingIsulgard

This comment has been minimized.

Copy link

KingIsulgard commented Feb 18, 2019

Will the cloud version contain data of all global markets or will it remain US only?
Would also be nice to have indices (such as S&P 500 & DOW), cyrptos and forex included.

@blafarm

This comment has been minimized.

Copy link

blafarm commented Feb 18, 2019

A word of caution for Google Sheets users: A sheet with 46-single cell calls for the Next Earnings Date generated 5,000,000 messages and shutdown my IEX account after running for around 2-days. When I activated the Pay As You Go feature, and the sheet refreshed, it generated an additional 290,093 messages in less than 15 seconds. And for the record, Google Sheets only updates the ImportData function once an hour (see this link: https://support.google.com/docs/answer/58515?hl=en).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment