data saving

[Priyank Saxena]

I have an excel in which stocks price is updated continuously, which can be per second or once in many seconds. I want to record those all prices. Is there anyway to save these all prices in some array or matrix in excel.

 

[AVK]

In excel by formula update data not automatically save. As you required second to second.
Secondly, which version you use 2003, 2007, 2013, 2016.

For Excel 2007: One way to do this, but minimum time given 1 minutes.
>Go to "Office Button"
>Click on "Excel option"
> Go to Save
> In save workbook, "Save AutoRecover information every" Select Minutes
> Click on "Ok"

Or using vba you can do this.
File attach

 

[Priyank Saxena]

Thanks for the reply...

I'm using excel 2013.

I'm comfortable with doing this in VBA, can you please help me with that.

▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[AVK]

already file attach.