Forum

Notifications
Clear all

How can I stack stockhistory into single sheet?

5 Posts
2 Users
0 Reactions
59 Views
(@djackson)
Posts: 3
Active Member
Topic starter
 

This is a follow-up to my post on YouTube.

What I want to do is create a single sheet that if formatted with one row for each stock and each day.

Sort of like this:

Symbol, Date,Close, Volume

I want it to update automatically .

In the attached workbook the Combined sheet is what I am looking for.

 

Thanks,

David

 
Posted : 14/02/2023 2:55 pm
Riny van Eekelen
(@riny)
Posts: 1194
Member Moderator
 

The file did not attach. Try agan and don't forget to press "Start upload" before submitting your reply.

By the way, what YT post are you referring to?

 
Posted : 15/02/2023 12:46 am
(@djackson)
Posts: 3
Active Member
Topic starter
 

Thanks for following up.

 

This youtube video:

https://youtu.be/xzOvM164H6M

 

David

 
Posted : 15/02/2023 1:20 am
Riny van Eekelen
(@riny)
Posts: 1194
Member Moderator
 

Perhaps the attached file contains a solution that might work for you.

 
Posted : 15/02/2023 2:48 am
(@djackson)
Posts: 3
Active Member
Topic starter
 

Riny,

Thanks for sharing that workbook.

You know I think vstack is what I am looking.

 

Thanks again,

David

 
Posted : 15/02/2023 2:39 pm
Share: