Excel: online changing data


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? 


By: Wout Remerie

Leave a Reply

Your email address will not be published. Required fields are marked *