given that i have a portfolio of 4 stocks. how do i calculatefive-day 99%-Value at Risk of my portfolio using the historical simulation approach using excel.

additional related question : so the stock i was tasked with was from 23 march to 2 april, it is clearly over 5 day and so when and how do i download data if necessary.

please clearly state which data is available and if possible how to obtain them.