MSFT 365 Price Change For X Number Of Days

[Data123]

I recently purchased MSFT 365 for access to Excel for stock data and was super impressed with the program and data! Then I tried to create a column header for, "Price % Change X Days" and realized STOCKHISTORY counts weekends and holidays as data days. I read about the WORKDAY solution, but this would not solve the holiday issue. Is there a way to create a formula based on days with data only OR X number of days with data?

Lastly, does one have to create a formula that shows a table with dates and prices or can a formula just show the percentage result for each symbol?

 

[Data123]

I could be wrong, but I think workday is a better option. If I don't worry about holidays right now. Can you edit this formula for (Price Change % 5 days) please;

=LET(sh,STOCKHISTORY(A2,WORKDAY(TODAY(),-7-1,1,TAKE(sh,-1)/TAKE(sh,1)-1)

Mr Excel has a link where he describes this very issue of weekends. His formula has a today()-7-1,1 to combat this issue. Excel STOCKHISTORY Never Falls On Weekend Or Holiday - 2468

You know much more than I, can his formula shown in that video at 3.19 min. be implemented in the =LET(sh,.....formula?

 

[Data123]

I could be wrong, but I think workday is a better option. If I don't worry about holidays right now. Can you edit this formula for (Price Change % 5 days) please;

=LET(sh,STOCKHISTORY(A2,WORKDAY(TODAY(),-7-1,1,TAKE(sh,-1)/TAKE(sh,1)-1)

Mr Excel has a link where he describes this very issue of weekends. His formula has a today()-7-1,1 to combat this issue. Excel STOCKHISTORY Never Falls On Weekend Or Holiday - 2468

You know much more than I, can his formula shown in that video at 3.19 min. be implemented in the =LET(sh,.....formula?

 

[Data123]

No worries that last post I did completed it. Thanks!!!

 

[awoohaw]

So, you're good? You may want to post your final formula, and mark it as a solution, so people can find it when searching.
(don't mark mine as the solution, unless it really gave you your answer - I don't think I did.). I just saw you marked it. Mark yours if it is correct.