Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating historical prices log (macro?)
Hi there and thanks in advance for any help you can give me . . .
I am currently daily manually logging daily historical prices into an excel worksheet. I would like to make a macro that daily takes the values (only) from a number of cells either automatically or at the push of a button and pastes them into that daily logged worksheet. If possible, I'd also like to make it so the most recent date is at the top. In other words, I'd like it to be displayed in a reverse chronological order down all the columns. Essentially, what I have been doing so far is to copy and paste all previously entered data down 1 row and then input the new data. I have looked at the discussion with subject: copy cells with a macro... dated 3/11/2005 and I thinkit's a very similar idea, however, I can't seem to translate it to work in my case, and I don't necessarily fully understand it. I am pretty green I guess . . . Thanks again, Darren |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Retrieve Historical Stock Prices? | Excel Discussion (Misc queries) | |||
Source of historical intraday stock prices? | Excel Discussion (Misc queries) | |||
updating prices for a line chart | Excel Discussion (Misc queries) | |||
Historical Stock Prices in Excel | Excel Discussion (Misc queries) | |||
Spreadsheet Historical Prices for European Stocks | Excel Worksheet Functions |