phaeom
02-19-2009, 05:31 PM
Hi.
I am quite new with VBA. I am currently working on a small project. I created one macro and a button to update Dow Jones Industrial Average stock data from a website. With this data I created a virtual porfolio next to it and the value of the whole portfolio.
Now what i want to do is have a button so that when i press it it would put a current date (say in Sheet 2) and the value of the whole portfolio next to it. Ideally intraday updates will overwrite the portfolio value but will generate a new date and the portfolio value on that day the next day automatically (once i press the button though).
I know it is quite a lot with conditions in the code etc but this would be absolutely perfect.I appreciate any help or link to a possible solution.
Thanks :bow:
I am quite new with VBA. I am currently working on a small project. I created one macro and a button to update Dow Jones Industrial Average stock data from a website. With this data I created a virtual porfolio next to it and the value of the whole portfolio.
Now what i want to do is have a button so that when i press it it would put a current date (say in Sheet 2) and the value of the whole portfolio next to it. Ideally intraday updates will overwrite the portfolio value but will generate a new date and the portfolio value on that day the next day automatically (once i press the button though).
I know it is quite a lot with conditions in the code etc but this would be absolutely perfect.I appreciate any help or link to a possible solution.
Thanks :bow: