perfecttip
New Member
- Joined
- Mar 3, 2009
- Messages
- 48
I have a sheet which fetches stocks data from the web and copies them in different fields. All these fields keep getting refreshed every minute and more often than not, they change.
What I am looking for is this:
A sheet which will have a full row dedicated to timestamps. Beneath that row, will appear these stock names which are appearing in my current sheet. One row will be dedicated to each stock name and the more number of times it appears in my current sheet, it gets appended to the new sheet beneath the timestamp at which it was fetched. If any name appears for the first time, it gets a place at the bottom of all the names in the 1st column.Maybe this will require a lot of size horizontally, and hence we may replace the text my some small indicative text or colour.
Now say at 9 am, my sheet shows X,Y and Z. At 9.05 am, it shows X, Y, Z and B. At 9.10 am, it shows X,Z, A and B.
then the required sheet should be as follows.
At 9 am, the first column in the first row will show 9 am. The there will appear three more rows beneath with X, Y and Z in them. At 9.05. the first column will have one added field containing B and the row of B will contain an indicator underneath the 9.05 am column and so on.
What I am looking for is this:
A sheet which will have a full row dedicated to timestamps. Beneath that row, will appear these stock names which are appearing in my current sheet. One row will be dedicated to each stock name and the more number of times it appears in my current sheet, it gets appended to the new sheet beneath the timestamp at which it was fetched. If any name appears for the first time, it gets a place at the bottom of all the names in the 1st column.Maybe this will require a lot of size horizontally, and hence we may replace the text my some small indicative text or colour.
Now say at 9 am, my sheet shows X,Y and Z. At 9.05 am, it shows X, Y, Z and B. At 9.10 am, it shows X,Z, A and B.
then the required sheet should be as follows.
At 9 am, the first column in the first row will show 9 am. The there will appear three more rows beneath with X, Y and Z in them. At 9.05. the first column will have one added field containing B and the row of B will contain an indicator underneath the 9.05 am column and so on.