Note : Solution will be at Google sheet in proper and Correct way.

Column D2 (User interface) has to be linked with column B4 (tool). TOOL SHEET:

- Starting in Cell Q31, every time the tool shows in column N to buy, the initial investment shown (in the user Interface sheet), has to be converted into shares (at the following day opening price). This changes every time the tool changes from buy to sell and viceversa. (That formula and calculation has to be created) - The information on the user interface has to be formulated and show the results given by the tool.

- if the user decides only to invest in long positions (buy low sell high, then the tool has to provide the information), but if the user wants to invest a percentage of the investment also in short positions (buy high sell low), the tool has to calculate and show the values of that investment.

- I would also like to graph and show in the

user interface the different returns from

the investment, as well as monthly and Yearly returns

Column D2 (User interface) has to be linked with column B4 (tool). TOOL SHEET: - Starting in Cell Q31, every time the tool shows in column N to buy, the initial investment shown (in the user Interface sheet), has to be converted into shares (at the following day opening price). This changes every time the tool changes from buy to sell and viceversa. (That formula and calculation has to be created) The information on the user interface has to be formulated and show the results given by the tool. - if the user decides only to invest in long positions (buy low sell high, then the tool has to provide the information), but if the user wants to invest a percentage of the investment also in short positions (buy high sell low), the tool has to calculate and show the values of that investment. - I would also like to graph and show in the user interface the different returns from the investment, as well as monthly and yearly returns Column D2 (User interface) has to be linked with column B4 (tool). TOOL SHEET: - Starting in Cell Q31, every time the tool shows in column N to buy, the initial investment shown (in the user Interface sheet), has to be converted into shares (at the following day opening price). This changes every time the tool changes from buy to sell and viceversa. (That formula and calculation has to be created) The information on the user interface has to be formulated and show the results given by the tool. - if the user decides only to invest in long positions (buy low sell high, then the tool has to provide the information), but if the user wants to invest a percentage of the investment also in short positions (buy high sell low), the tool has to calculate and show the values of that investment. - I would also like to graph and show in the user interface the different returns from the investment, as well as monthly and yearly returns