Note : Solution will be at Google sheet in proper and Correct way. - Starting in Cell Q31, every time the tool shows in
Posted: Fri Jun 10, 2022 11:58 am
Note : Solution will be at Google sheet in proper and Correct
way.
- 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
way.
- Note Solution Will Be At Google Sheet In Proper And Correct Way Starting In Cell Q31 Every Time The Tool Shows In 1 (108.89 KiB) Viewed 90 times
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