Google spreadsheet : when the data in a cell changes, automatically take a record of this

I had searched the forum and found something similar here:

http://www.excelforum.com/excel-prog...ange-data.html

But I need this to be worked in online google spreadsheet.

The (sample) sheet 'RECORD' is as follows:

https://docs.google.com/spreadsheets...it?usp=sharing

The cell B1 shows NSE Index value, which changes every 2 min through google finance function.
The cell A1 shows trade time and that too will change every 2 min.

Is it possible to record every such change record of this change and populate it at the last available blank row, so ultimately, I have a full history of how this number changes during the market hours ?

Anyone, please help me.

Sorry

I misunderstood.

moderators may kindly delete the thread.