Home

Importing stock values into Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-260559%22%20slang%3D%22en-US%22%3EImporting%20stock%20values%20into%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-260559%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20the%20past%20year%20I%20am%20hearing%20about%20the%20new%20excel%20option%20that%20will%20enable%20to%20import%20live%20stock%20values.%20While%20this%20option%20exists%20for%20a%20long%20time%20in%20Google%20Sheets%2C%20and%20it%20works%20extremely%20well%2C%20I%20am%20wondering%20why%20does%20it%20takes%20for%20Microsoft%20so%20much%20time%20to%20add%20this%20feature%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-260559%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314943%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20stock%20values%20into%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314943%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20trying%20for%20some%20time%20to%20import%20data%20on%20individual%20stocks%20that%20are%20NOT%20part%20of%20the%20new%26nbsp%3B%20%22GET%20DATA-STOCKS%22%20workflow%20in%20Excel%20(office%20365).%20Specifically%2C%20I%20need%20dividend%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20%22GET%20DATA%2FFrom%20other%20sources%2FWeb%22%20and%20pasted%20links%20to%20my%20Fidelity%20brokerage%20quote%20page.%26nbsp%3B%20I%20have%20entered%20my%20username%20and%20PW%20in%20the%20provide%20credentials%20dialog%20box%2C%20to%20no%20avail.%26nbsp%3B%20I%20have%20also%20tried%20to%20load%20a%20link%20to%20a%20%3CA%20href%3D%22http%3A%2F%2Fwww.fool.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.fool.com%3C%2FA%3Efree%20quote%20page%2C%20and%20likewise%20this%20Get%20Data%20function%20does%20not%20display%20the%20tables.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20have%20any%20work%20arounds%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303149%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20stock%20values%20into%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303149%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Keith%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20I%20am%20currently%20stuck%20in%20Excel%202019%2C%20not%20Office%20365!%3C%2FP%3E%3CP%3ESo%20I%20can't%20access%20this%20feature%20to%20figure%20out%20the%20problem!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suggest%20you%20ask%20this%20question%20in%20a%20new%20conversation%20from%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FBI-and-Data-Analysis%2Fbd-p%2FBIDataAnalysis%22%20target%3D%22_blank%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ESo%20that%20other%20members%20can%20see%20it.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ERegards%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHaytham%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302941%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20stock%20values%20into%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302941%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20to%20this%20and%20want%20some%20help%20in%20inputting%20info.%20to%20retrieve%20correct%20stock%20data.%20Specifically%20having%20trouble%20with%20some%20Canadian%20stocks.%20Most%20work%20fine.%20For%20example%20when%20I%20input%20TO.NTR%20i%20get%20the%20correct%20CDN%20stock.%20However%20when%20I%20try%20a%20CDN%20REIT%20like%20Granite%20Real%20Estate%20Investment%20Trust%20(GRT-UN)%20Iget%20nothing%20at%20all.%20Is%20there%20a%20guide%20somewhere.%20Understand%20Bloomberg%20is%20the%20source%20of%20this%20data.%20Help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKeith%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-260599%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20stock%20values%20into%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-260599%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ofer%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3ENo%20doubt%20the%20first%20to%20come%20up%20with%20this%20idea%20is%20Google.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EThe%20reason%20is%20that%20Google%20wants%20Google%20Sheet%20to%20compete%20with%20Excel%2C%20and%20to%20have%20features%20not%20found%20in%20the%20Excel%20to%20attract%20users.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EBut%20I%20think%20that%20the%20Excel%20team%20since%20that%20time%20has%20put%20this%20feature%20in%20their%20future%20plans%2C%20and%20they%20have%20recently%20included%20it%20differently%20and%20in%20more%20appropriate%20manner%2C%20as%20it%20is%20a%20data%20type%20in%20the%20Excel%2C%20while%20in%20Google%20Sheet%2C%20it%20is%20a%20function%20(GOOGLEFINANCE).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EI%20think%20the%20reason%20for%20this%20delay%20is%20that%20the%20Excel%20team%20was%20busy%20working%20on%20certain%20features%20and%20projects%20that%20can%20not%20be%20delayed.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EAnother%20reason%20I%20believe%20is%20that%20Microsoft%20should%20first%20support%20and%20update%20its%20search%20engine%20(Bing)%20and%20the%20services%20required%20for%20this%20feature%20before%20launching%20this%20feature.%3C%2FSPAN%3E%3CBR%20%2F%3EWhile%20Google%20has%20been%20able%20to%20do%20so%20since%20it%20has%20the%20largest%20search%20engine%20in%20the%20world%2C%20and%20its%20services%20were%20ready.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3ERegards%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ofer Pillar
Occasional Contributor

For the past year I am hearing about the new excel option that will enable to import live stock values. While this option exists for a long time in Google Sheets, and it works extremely well, I am wondering why does it takes for Microsoft so much time to add this feature?

4 Replies

Hi Ofer,

 

No doubt the first to come up with this idea is Google.

The reason is that Google wants Google Sheet to compete with Excel, and to have features not found in the Excel to attract users.

 

But I think that the Excel team since that time has put this feature in their future plans, and they have recently included it differently and in more appropriate manner, as it is a data type in the Excel, while in Google Sheet, it is a function (GOOGLEFINANCE).

 

I think the reason for this delay is that the Excel team was busy working on certain features and projects that can not be delayed.

 

Another reason I believe is that Microsoft should first support and update its search engine (Bing) and the services required for this feature before launching this feature.
While Google has been able to do so since it has the largest search engine in the world, and its services were ready.

 

Regards

I am new to this and want some help in inputting info. to retrieve correct stock data. Specifically having trouble with some Canadian stocks. Most work fine. For example when I input TO.NTR i get the correct CDN stock. However when I try a CDN REIT like Granite Real Estate Investment Trust (GRT-UN) Iget nothing at all. Is there a guide somewhere. Understand Bloomberg is the source of this data. Help would be appreciated.

 

Keith

Hi Keith,

 

Unfortunately, I am currently stuck in Excel 2019, not Office 365!

So I can't access this feature to figure out the problem!

 

I suggest you ask this question in a new conversation from here.

So that other members can see it.

 

Regards,

Haytham

I have been trying for some time to import data on individual stocks that are NOT part of the new  "GET DATA-STOCKS" workflow in Excel (office 365). Specifically, I need dividend data. 

 

I have tried "GET DATA/From other sources/Web" and pasted links to my Fidelity brokerage quote page.  I have entered my username and PW in the provide credentials dialog box, to no avail.  I have also tried to load a link to a www.fool.com free quote page, and likewise this Get Data function does not display the tables.  

 

Anyone have any work arounds?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies