Excel problem

  Housten 09 Oct 11
Locked

Good afternoon,

What I want/would like to do I think is not possible, but I am going to ask anyway! We have some shares and I download prices from our broker’s site to a spreadsheet, but only the following day. So yesterday – the 8th – I obtained the share prices of the 7th. What I have is a column beside this that takes the price and deducts from the previous day’s price [ in this case the 6th ], so I know the daily change. But to do this I have to edit the first share listed and then copy and paste to all the other shares. Does anyone know if there is an instruction that I can write/give Excel that will do it automatically? I realise that I will probably have to continue doing the editing/pasting on Tuesdays because of the 3 day delay, but it would be nice to have it done automatically the rest of the time!!

Many thanks in anticipation

  Housten 10 Oct 11

Good afternoon,

Doesn't anyone have an idea whether or not what I wish to do is even possible?

Any help/thoughts would be very much appreciated.

Advertisement

This thread is now locked and can not be replied to.

Windows 10 Home vs Windows 10 Pro comparison: Here are the extra features you get in the Pro version

Why Formula-e needs to go faster

Found Studio reveals the making of the Unleashed, Uncut Peugeot 208 viral

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message