Tws execel api-saving calculation

Discussion in 'Programming' started by alibaba500, Apr 9, 2012.

  1. Hello

    I am developing a feature, that reads real time ticker price and messure time fream. To do that, i have the following iputs: for example cell a1 read the time that a certain finance news published and cell b2 will get the ticker price, folow this published time. The expected output: cell c1 we show the price every 10 min. since the finance news was publices, cell d1 will calculate the price aftter 20 min. ans so. I having trouble tp program this lop with VB. Doe's anyone know how I can save the data in a cell every 10 min. so that I can calculate the interval time. Is this only possible using VBA?

    Dan.