Stock Connector add-in for Excel: updates and bugs

This page shows a log of the latest changes, including bug fixes and new features. For detailed Stock Connector information and support, visit the main Stock Connector info page. For email notifications about significant changes, join this Google group. Send your feedback and bug reports to stockconnectorapp@outlook.com.

April 11, 2022

Mutual fund quotes provided by IEX had an outage beginning 5 days ago: most US mutual funds are currently not being recognized by IEX. I am following up with the provider and will give an update here once I get an estimated time when the outage will be resolved.

February 3, 2021

Tweaked visual layout to ensure that "x" buttons do not get hidden behind the scroll bar when customers have a high number of stocks.

January 23, 2021

The server upgrades have now been completed and you should not expect further interruptions.

The upgrades will address capacity issues from high server load and eliminate the server errors which sometimes occurred for free and paid users. They'll also allow me to scale more easily in the future if additional capacity is needed.

January 22, 2021

Weekend maintenance is planned on 2021-02-22 starting at 05:00:00 UTC and lasting approximately 1 day. Stock Connector will be working throughout maintenance apart from momentary downtime which can be resolved by closing and reopening Excel.

The maintenance will upgrade servers in order to resolve recent capacity issues, which have occasionally prevented the premium features from turning on over the past week.

January 16, 2021

This weekend maintenance is being performed for premium accounts. Premium features may be temporarily disabled.

January 4, 2021

5 market indexes have been added to Stock Connector, such as "^GSPC" for the S&P 500 index. See the full list on the Stock Connector info page.

November 26, 2020

Currency prices (including cryptocurrencies) are working correctly again. The issue was temporary downtime from the data provider.

November 24, 2020

Currency prices (including cryptocurrencies) are not working as of 11:00 AM Eastern Time due to an issue at the data provider. I'm working on resolving this issue and will update as more details become available.

November 18, 2020

Stock Connector was unavailable for approximately 4.5 hours at night in the Americas, from 10:00 PM Eastern Time until 2:30 AM.

This issue is now resolved and the service should be working correctly for all users. The root cause was an outage in one of Stock Connector's service providers. This is the first time in 2020 that this type of outage occurred, so I expect it to be very rare in the future.

October 21, 2020

For approximately 2.5 hours in the early morning on October 21, price information for Stock Connector was unavailable. This issue is now resolved and prices are available as normal to all.

From around 1:30 AM Eastern Time until 4:00 AM Eastern Time, no price information was being retrieved to Stock Connector. The reason for the downtime was that the data stream purchased from the provider was no longer large enough to accommodate the Stock Connector user base. I have now upgraded the service to a higher-capacity data stream to resolve the issue.

For now, the Stock Connector price will remain the same despite the increased cost. In the future, additional controls may be necessary to further limit free-tier users, and the price may be increased for Premium. As explained on the Help page, all existing Premium users will continue to have access to the features for no additional charge and will never be required to pay more.

October 14, 2020

Payments for premium features have now been re-enabled in Stock Connector. Now the purchase system works normally as it did before, via PayPal. All customers who have previously paid should continue to receive the premium features.

For approximately 1 week beginning October 7, 2020, the payment system was disabled because of a server bug. In order to maintain access to the premium features, they were temporarily enabled for all authenticated users (whether contributors or not).

May 7, 2020

With the recent increase in usage, the database which verifies premium users has been under increased stress, resulting in premium users sometimes not being recognized by Stock Connector. I have now implemented better retry logic in order to dramatically reduce the probability that a user will not be recognized.

Apr 29, 2020

From approximately 4pm to 6pm Eastern Time, there was a provider outage affecting the NASDAQ stock exchange. As a result, stock prices for US NASDAQ stocks were displaying yesterday's price. An escalation was raised with the IEX data provider: https://github.com/iexg/IEX-API/issues/1464

The outage is now resolved.

Apr 15, 2020

Fixed a bug affecting payments-processing. For the past 4 days, certain users have been unable to have their payments processed correctly. Now the issue is resolved, so anyone with a Microsoft account should be able to pay for the premium features, and everyone who has paid already should be able to access the premium features.

Apr 13, 2020

Began rolling out and testing subscriptions for some users. Users who contribute via the $20 payment will not need to switch to subscriptions in the future.

Apr 12, 2020

Added a button to display and hide help information.

Apr 8, 2020

In the last update, 4 buttons were broken. All have now been fixed:

Apr 6, 2020

Added support for international stocks in Stock Connector in 14 international exchanges. Non-US stocks have their prices updated once daily, at the end of the day.

You can now search for a company by name (eg. "Volkswagen") in Stock Connector and see the top 10 US and international stocks that match.

See the main Stock Connector help page for details on how to use international stocks. The supported exchanges are:

Mar 27, 2020

Stock Connector market data was down for approximately 70 minutes earlier today. The issue was very high request volume going beyond the limits of my paid live market feed service. I have now increased the limits to accommodate the higher volume of requests.

Mar 23, 2020

Stock Connector was down for approximately 29 hours from March 22 until March 23. The issue was a server configuration problem that has now been resolved by the service provider. Over the next few weeks I'll be setting up a backup server in case a similar issue occurs in the future.

Mar 22, 2020

Stock Connector went down a few hours ago. I'm investigating the issue and working with the service provider to get it resolved. Sorry for the inconvenience!

Aug 8, 2019

I realize there have been stability issues over the past few weeks as I've been contending with several bugs that were related to changes from my service provider. I've already fixed several and I'm working hard to fix more - please continue to send me reports of any issues that you encounter.

Today I found and fixed a significant bug in my own code which was affecting my retry logic and was preventing my service from being resilient to any reliability problems in the underlying data service. I expect that for some users it will solve the issue where stock prices sometimes don't load at all.

I'll continue to listen for reports of users who can't load their stocks. One helpful thing in these cases would be to send me a copy of your file, with personal info removed. That enables me to debug your issue on my own computer. I'm also aware of a couple other unresolved issues:

Aug 2, 2019

Fixed a bug that affected many users with large numbers of stocks, which prevented correct loading. All users with 100+ stocks were affected.

Aug 1, 2019

NASDAQ has pulled their UTP data from all services who don't pay a large monthly fee (thousands) to NASDAQ (see http://www.utpplan.com/). As a result, IEX blocked me from receiving UTP data for NASDAQ stocks (mostly tech stocks, such as MSFT, AAPL, and GOOG).

That caused a temporary bug for free users, which I've now fixed. All users can still see and connect price information for all stocks, including NASDAQ stocks, and you will continue to see that information in the future with Stock Connector.

However, because the market close data is no longer coming from NASDAQ, I don't get official close prices on those stocks. What that means is that after the markets close each day, certain stocks such as AAPL, GOOG, and MSFT may show slightly different prices from the official NASDAQ "close" price, along with close times that may be slightly different from the exact market-close time. Those prices reflect the most recent trade of that security on IEX itself. I'll start a discussion with IEX about whether anything can be done to get the exact closing prices.

Jul 29, 2019

Microsoft now says their bug (described below) is fixed. To get the fix, update your version of Excel and check that you have Version 1907, build 11901.20176. To update, go to File > Account > Update Options.

Jul 21, 2019

An Microsoft bug with Excel is causing issues for a minority of users when they Save and reopen the file with Stock Connector. For these users, closing and reopening the file may cause the recently-added stocks to be removed.

The specific affected versions of Excel are:

Microsoft is aware of the issue and has a fix planned: https://github.com/OfficeDev/office-js/issues/626. I'll post an update once I hear from Microsoft that this issue is resolved.

Jul 16, 2019

I fixed a bug causing certain stocks to appear with price = 0 and change -100% after-hours. This bug affected only non-paid users.

Also, I'm continuing to tune the default update timing to deal with high data costs from free users with larger numbers of stocks. I've re-enabled the fast (5-second) times for paid users and free users with under 10 stocks. For others I've increased the minimum interval to 5 minutes. I'll see how that impacts data costs and adjust as appropriate.

Jul 12, 2019

The cost of paying for the financial data has increased faster than expected due to high usage among free users. I need to pay for every time a stock updates, so to try to keep my costs under control, I made a couple tweaks for those users to encourage less-frequent updates.

Users who contributed money or who contribute in the future still get the fast refreshes and the Refresh button, of course.

Jul 5, 2019

I've found a paid data source and implemented the change which switches Stock Connector to use this new source (unfortunately, no free data source exists that is good enough). I've decided to continue offering the app for free anyway.

Based on past contribution numbers, the users who pay should be able to make up for the cost of providing the data to those who can't afford it or don't want to pay. Since the cost of the data gets very expensive for users who refresh the stocks list frequently, I plan to limit free users to wait at least 60 seconds between automatic price updates. For paid users, I'll continue to allow the fast 5-second updates, but I do plan to charge $20 for new paid users.

Jun 27, 2019

I'm aware that the temporary update to use the price-only IEX data has broken some users with high numbers of stocks and currencies. I'm working to resolve this issue first before I fix the % Change problem.

I've also fixed the support email links, which were broken by an unrelated issue.

Jun 17, 2019

As you may know, Stock Connector previously used IEX as its data provider. On Jun 1, 2019, IEX disabled general access to its free financial data, 3 years after the service was introduced. This change broke Stock Connector and many other tools across the web. Of course, it was always a known possibility that IEX would decide to shut down its free service, similar to how Yahoo shut down Stock Connector's initial source.

On Jun 17, 2017, I integrated a workaround with the old IEX API which fetches price data but not % Change. I will continue investigating ways to get a free % Change source back up and running. Please let me know if you're aware of alteratives I can use. Thank you!

Jan 25, 2017, 11:30 PM

I've now fixed the break caused by the data provider. All US stocks should now be returning values to Excel correctly again.

Jan 25, 2017, 6:30 AM

Received reports of a bug which impacted all free users. Investigated the issue and found that the external data source for US stocks had changed its API without notice. I'll update again once I'm able to resolve the issue.

Jan 15, 2017

Added support for cryptocurrencies and currencies. Examples:

Cryptocurrency prices are real-time, even for non-contributors. Foreign currency prices (non-crypto) may be delayed. Currencies are accurate to 2 decimal places.

Jan 7, 2017

Fixed a bug that caused values to stop updating sometimes (when successive http calls were too slow to return). This change also fixed a bug for users with more than 100 stocks. The fix also gives a small performance boost for all users.

Jan 3, 2017

Fixed a bug that prevented real-time prices from updating frequently enough. There was a server caching problem that stored old values, but that has now been resolved. Premium users (contributors) will now see the accurate real-time prices, and other users will now see the accurate prices delayed only by 15-20 minutes.

Dec 31, 2017

Fixed a bug that blocked all stock quote updates for users who also had currencies, international stocks, or mutual funds listed. (Those asset types still don't work yet though, only US stocks.)

Dec 29, 2017

Feedback over the past month has helped uncover several issues with the new IEX data source:

Nov 12, 2017

As you may know, Stock Connector previously used Yahoo as its data provider. On Nov 1, 2017, Yahoo disabled external access to its free financial data without warning, 12 years after the service was introduced. On Nov 9, 2017, Yahoo posted an official response. This change broke Stock Connector and many other tools across the web. Of course, it was always a known possibility that Yahoo would decide to shut down its free service, especially after its purchase by Verizon.

On Nov 12, 2017, I finished integrating IEX as the new data provider for Stock Connector. Although it's still a free source for US stocks and exchange-traded funds (ETFs), IEX has many differences compared to Yahoo as a data provider:

Disadvantages

Advantages

I will continue investigating ways to address those disadvantages with other data sources, but I can't make any guarantees there. Please let me know if you're aware of alteratives I can use. Thank you!

For more information on Stock Connector, see the Stock Connector info page.