Automatically new row to save feed as a number

Hi there.
I am coming to you with some issues.

I receive feed of some data that it is refreshed every 1-3s. Feed can be placed in excel cell using some special formula, and it is refreshed automaticly by the software.

Issue 1) Is it possible to save this feed as a number in separate different cell, that it will be not changed anymore with next refreshment of the feed?

Issue 2) Is it possible to make action from issue 1) every (x) seconds in another row, automaticly?

If yes, how to do it?

Thank you in advance for your help.

EDIT: please check image:

\1