[52 week high] formula not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1798292%22%20slang%3D%22en-US%22%3E%5B52%20week%20high%5D%20formula%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1798292%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20where%20I%20track%20my%20portfolio%20data.%20I%20have%20attached%20a%20sample.%20It%20appears%20that%20the%20%22%5B52%20week%20high%5D%22%20formula%20is%20not%20working%20properly.%20It%20shows%20up%20as%20the%20same%20price%20as%20the%20current%20%22Price%22%20for%20most%20securities.%20While%20this%20is%20in%20theory%20possible%2C%20the%20%22Price%22%20is%20below%20the%20%22%5BPrevious%20close%5D%22%2C%20so%20therefore%20it%20appears%20incorrect.%20Is%20this%20a%20known%20issue%3F%20How%20can%20it%20be%20resolved%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1798292%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1799394%22%20slang%3D%22en-US%22%3ERe%3A%20%5B52%20week%20high%5D%20formula%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1799394%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F838823%22%20target%3D%22_blank%22%3E%40mkeller85%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20used%20in%20this%20spreadsheet%20is%20not%20a%20main%20function%20of%20Microsoft%20Excel.%20It%20appears%20to%20be%20either%20from%20an%20add-on%20or%20UDF%20(user-defined%20function).%20The%20issue%20might%20not%20be%20the%20formula%20but%20rather%20the%20source%20of%20the%20data%20that%20the%20formula%20is%20referencing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1799465%22%20slang%3D%22en-US%22%3ERe%3A%20%5B52%20week%20high%5D%20formula%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1799465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3BAre%20you%20sure%3F%20Thanks%20for%20the%20response.%20I%20did%20not%20install%20any%20add-ons%2C%20my%20understanding%20was%20that%20this%20is%20part%20of%20the%20added%20functionality%20that%20comes%20with%20Office%20365%20and%20the%20ability%20to%20import%20stock%20data.%20It%20should%20be%20linked%20to%20Refinitiv%20as%20the%20data%20provider.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a spreadsheet where I track my portfolio data. I have attached a sample. It appears that the "[52 week high]" formula is not working properly. It shows up as the same price as the current "Price" for most securities. While this is in theory possible, the "Price" is below the "[Previous close]", so therefore it appears incorrect. Is this a known issue? How can it be resolved? 

5 Replies

Hello @mkeller85,

 

The formula used in this spreadsheet is not a main function of Microsoft Excel. It appears to be either from an add-on or UDF (user-defined function). The issue might not be the formula but rather the source of the data that the formula is referencing.

@PReagan Are you sure? Thanks for the response. I did not install any add-ons, my understanding was that this is part of the added functionality that comes with Office 365 and the ability to import stock data. It should be linked to Refinitiv as the data provider. 

@mkeller85,

 

My apologies, you are correct. I am not an Office 365 subscriber and was not aware of this feature. I will have to defer any possible solutions to the rest of the community.

@PReagan Seems like nobody else knows either. Thought I'd get a response from a Microsoft rep in this forum. 

@mkeller85 

 

That is odd. 

 

I'd suggest clicking on the Flag to report bad data

 

Wyn

 

image.png