Excel Stock Data not Updating Prices

%3CLINGO-SUB%20id%3D%22lingo-sub-1952473%22%20slang%3D%22en-US%22%3EExcel%20Stock%20Data%20not%20Updating%20Prices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1952473%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20referring%20to%20a%20model%20for%20quite%20some%20time%20now%20that%20pulls%20the%20price%20of%20stocks%20for%20data%20analysis.%20Starting%20around%20a%20week%20ago%2C%20the%20prices%20have%20not%20been%20updating%20with%20the%20stock%20and%20I%20can't%20try%20the%20issue.%20I%20tried%20restarting%20and%20updating%20Excel%20and%20contacted%20Microsoft%20support.%20I%20also%20uploaded%20the%20workbook%20online%20and%20tried%20to%20re-download%20it%20None%20of%20this%20has%20worked.%20Microsoft%20support%20recommended%20that%20I%20come%20to%20this%20discussion%20page.%20What%20could%20the%20problem%20be%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1952473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1956938%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Stock%20Data%20not%20Updating%20Prices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F889861%22%20target%3D%22_blank%22%3E%40elirethy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20hard%20to%20say.%20I%20have%20a%20spreadsheet%20into%20which%20I%20bring%20Stock%20and%20Options%20data%20I've%20downloaded%20from%20my%20broker%20(Fidelity%2C%20if%20it%20matters).%20I've%20been%20comparing%20what%20the%20Microsoft%20Excel-based%20service%20provides--which%20unfortunately%20doesn't%20include%20some%20useful%20pieces%20of%20info.%20It%20is%20still%20working%20(checked%20a%20few%20minutes%20ago).%20So%20it's%20not%20the%20service%20itself%2C%20or%20seems%20unlikely.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20post%20a%20copy%20of%20your%20spreadsheet%20itself....take%20out%20any%20personal%20or%20private%20info.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1957092%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Stock%20Data%20not%20Updating%20Prices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1957092%22%20slang%3D%22en-US%22%3EI%20have%20been%20using%20Excel%20stock%20data%2C%20maybe%20I%20should%20try%20to%20download%20it%20from%20my%20broker.%20Sorry%2C%20most%20of%20the%20information%20on%20the%20worksheet%20is%20private%20(it%E2%80%99s%20very%20condensed).%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have been referring to a model for quite some time now that pulls the price of stocks for data analysis. Starting around a week ago, the prices have not been updating with the stock and I can't try the issue. I tried restarting and updating Excel and contacted Microsoft support. I also uploaded the workbook online and tried to re-download it None of this has worked. Microsoft support recommended that I come to this discussion page. What could the problem be?

 

Thanks.

2 Replies

@elirethy 

 

It's hard to say. I have a spreadsheet into which I bring Stock and Options data I've downloaded from my broker (Fidelity, if it matters). I've been comparing what the Microsoft Excel-based service provides--which unfortunately doesn't include some useful pieces of info. It is still working (checked a few minutes ago). So it's not the service itself, or seems unlikely.

 

Can you post a copy of your spreadsheet itself....take out any personal or private info.

I have been using Excel stock data, maybe I should try to download it from my broker. Sorry, most of the information on the worksheet is private (it’s very condensed).