Help please, how can I Program this in VBA step-by-step?

Project # 7-A Stock-Trading Simulation Application This application simulates the trading activity of an investor in the stock market over a period of a year (250 trading days). This investor starts with a certain amount of cash and owns sev- eral shares of a stock. The investor then uses a "buy low/sell high" trading strategy. The trad ing strategy implemented in the model is as follows. If the price of the stock increases two days in a row, the investor sells 10% of its shares. If it increases three days in a row, he sells 25% of his shares. In the other direction, if the price decreases two days in a row, the investor buys 10% more shares. For example, if he owns 500 shares, he buys 50 more shares. If the price decreases three days in a row, he buys 25% more shares. The only restriction on buying is that the investor cannot spend more than his current cash. The prie-ef the-steek is gener stock can be retrieved from Yahoo Finance page The simulation keeps track of five output measures 1) The investor's cash at the end of the year 2) The value of the investor's stock at the end of the year, 3) The gain (or loss) from the investor's cash/stock portfolio at the end of the year, rela tive to what he owned at the beginning of the year, 4) The lowest price of the stock during the year, and 5) The highest price of the stock during the year