Forum Discussion

mkeller85's avatar
mkeller85
Copper Contributor
Oct 20, 2020

[52 week high] formula not working

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? 

excel
Formulas and Functions
office 365

5 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Oct 20, 2020

    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.

    • mkeller85's avatar
      mkeller85
      Copper Contributor
      Oct 20, 2020

      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. 

      • PReagan's avatar
        PReagan
        Bronze Contributor
        Oct 20, 2020

        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.