Investing in crypto: excel sheet

[Weuten]

Hello


I'm using a value of an external online source in excel, which changes everytime the value on that website changes. This way I can calculate my daily profit or loss (investing). The problem is that, when i'm for example 5 days later, my profits of day 1 change according to the value online at this present moment. That's annoying because I can never rely on the older values because they keep changing. How can I make sure when some values are calculated, they don't change anymore? I tried the:


IF (certain cell=notblank (for example when I add a new date);block this cell from changing;formula)


but that didn't really work, or I did it wrong.


Could someone help me?
Thanks​

 

[Fluff]

Duplicate post https://www.mrexcel.com/forum/excel...lue-pinning-calculated-cells.html#post4989324

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.