Hi All,
Hope you are having a great day and thank you in advance for taking the time to look at my post!
I am struggling to find a solution to solve the following issue, i am a proficient excel user but am new to Macro's. Ultimately i am trying to pull specific data from an array in order to create a line chart with just specific data.
I have a large array of data in which i have the price points of various stocks, therefore in column A i have the dates for the past 5 years. Horizontally and in row 1 i have the ticker symbols for each stock.
Step 1:
For a certain product, i have a specified inception date, for example 01/02/2018. The dates however go back 5 years and i do not need everything older than the specified date. How do i copy and paste the dates from this certain date up the the current date (which is specified in cell A2 of the array).
*Note, for different products the inception date will change so this has to be variable*
Step 2:
For those dates i now need to show the corresponding price points for the certain ticker symbols. My current idea is to use Index(Match(Match)) in order to find each individual data point based on the ticker symbol at the top and the corresponding date however if you guys can think of any better way then please enlighten me
.
I hope you get the idea and thanks again for your help!
All the best,
Crypsis
Hope you are having a great day and thank you in advance for taking the time to look at my post!
I am struggling to find a solution to solve the following issue, i am a proficient excel user but am new to Macro's. Ultimately i am trying to pull specific data from an array in order to create a line chart with just specific data.
I have a large array of data in which i have the price points of various stocks, therefore in column A i have the dates for the past 5 years. Horizontally and in row 1 i have the ticker symbols for each stock.
Step 1:
For a certain product, i have a specified inception date, for example 01/02/2018. The dates however go back 5 years and i do not need everything older than the specified date. How do i copy and paste the dates from this certain date up the the current date (which is specified in cell A2 of the array).
*Note, for different products the inception date will change so this has to be variable*
Step 2:
For those dates i now need to show the corresponding price points for the certain ticker symbols. My current idea is to use Index(Match(Match)) in order to find each individual data point based on the ticker symbol at the top and the corresponding date however if you guys can think of any better way then please enlighten me
. I hope you get the idea and thanks again for your help!
All the best,
Crypsis
