portfolio: share price updation

[k00lfire]

i want to calculate daily worth of shares held by me.

portfolio.xlsx

name symbol shares held 250112014 26012014 27012014

the data i download from website is csv file and named as 25012014.csv 26012014.csv and data in below form

[TABLE="width: 448"]
<colgroup><col span="7" width="64"></colgroup><tbody>[TR]
[TD="width: 64"]Symbol[/TD]
[TD="width: 64"]Date[/TD]
[TD="width: 64"]Open[/TD]
[TD="width: 64"]High[/TD]
[TD="width: 64"]Low[/TD]
[TD="width: 64"]Close[/TD]
[TD="width: 64"]Volume[/TD]
[/TR]
</tbody>[/TABLE]

i want some macro which will copy stocks price which are held by in respective date columns and if there is no close price listed than it should copy yesterday price

 

[k00lfire]

bump

 

[k00lfire]

bump

 

[PaddyD]

two bumps tends to mean you haven't given people enough info to work with.

Try explaining agin - a worked example usually helps.