George01380
New Member
- Joined
- Aug 24, 2015
- Messages
- 1
Hi,
I am currently working on a VBA code for share analysis and I have found a very useful spreadsheet that takes stock data from yahoo finance based on your ticker list and start and end dates that you set.
When you click 'get bulk quotes' command it retrieves date, open, high, low, close, volume and adj close data for each company, and places each companies data in a new worksheet. It also renames each worksheet to match the companies ticker.
What I want to do is manipulate the data retrieved to look at price change during the day for example. So what VBA code would I use to subtract the close price from the open price and place it in column H, for all the worksheets? The close and open price are in rows B and E on all worksheets.
The complexity is that the number of sheets can vary as well as the number of rows on each sheet. The amount of rows on each sheet will always be the same compared to each other, but can vary every time you press 'get bulk quotes' if you choose different dates.
Many thanks for any replies!
I am currently working on a VBA code for share analysis and I have found a very useful spreadsheet that takes stock data from yahoo finance based on your ticker list and start and end dates that you set.
When you click 'get bulk quotes' command it retrieves date, open, high, low, close, volume and adj close data for each company, and places each companies data in a new worksheet. It also renames each worksheet to match the companies ticker.
What I want to do is manipulate the data retrieved to look at price change during the day for example. So what VBA code would I use to subtract the close price from the open price and place it in column H, for all the worksheets? The close and open price are in rows B and E on all worksheets.
The complexity is that the number of sheets can vary as well as the number of rows on each sheet. The amount of rows on each sheet will always be the same compared to each other, but can vary every time you press 'get bulk quotes' if you choose different dates.
Many thanks for any replies!
