Jul 18 2021 02:28 PM
I am MS 365 Family user.
Sometimes formulas work but if I touch it w/o changes it stops working.
Could someone please point me in the right direction to help me understand how to add, get into and out of changing formulas in cells with stock history formulas. I then add another row with a date and copy down formulas to see which way my investments are going.
My formulas in the attached have worked in the past but I keep breaking them somehow when I go to add another row. I believe that I am missing a key piece of maybe some editing information and returning back to execute the formula(s). I also suspect that I am improperly using “ctrl enter”, the “f4” key, the “f2” key, the “escape” key and perhaps more. I am 75 and getting a little slower than I used to be. Is there a good tutorial?
I would like to know more about when and how to use these keys and more to make everything work.
And, what do I do to make the attached work where the formulas are in rows 16 through 25?
Please help.
Thank you in advance
Steve Lorentzen
Jul 19 2021 01:06 AM
@SteveL50 Can you perhaps upload a version of that file that contains bits that do not work? The formulas look just fine to me.
Jul 24 2021 03:09 PM
Jul 24 2021 04:07 PM
The sheet updated fjust fine for me. Still worked when I introduced names to avoid relative referencing.
= STOCKHISTORY(Stock, Date, Date, 0, 0, 1) * Qty
The formula spilt as an dynamic array without issue.
Jul 24 2021 04:52 PM
Jul 25 2021 01:43 AM
Sorry but, for me, the formula just works.
There may be issues with the version of 365 or its update status but others are more qualified than I to comment. @Jan Karel Pieterse
Jul 26 2021 01:21 AM
Jul 26 2021 05:41 PM
Jul 27 2021 12:51 AM