InvestorsHub Logo
Followers 3
Posts 82
Boards Moderated 0
Alias Born 09/03/2021

Re: None

Wednesday, 12/29/2021 8:03:06 AM

Wednesday, December 29, 2021 8:03:06 AM

Post# of 8734
Hi Myst,

I have shared another iteration of the ETH sheet with you in which I have now added BUY Forecast and SELL Forecast columns.

I think I have managed to calculate BUY Forecasts which allow us to set limit orders in advance and incorporate actual CASH VALUE at the time. It was a little complicated.

You will see how, from time to time, the BUY Forecast will seem to be different to the BUY Market Order in column “O”. This is because the value shown in the BUY Forecast Column takes into account the CASH VALUE available at the time, so the value shown in the BUY Forecast column is actually equal to the CASH VALUE column available at the time in instances where the BUY Market Order suggested is greater than actual CASH VALUE. In these instances, the BUY forecast simply equals remaining CASH VALUE. (This works out to equal the amount shown in the next day’s Suggest Shares Bot/Sold column.) When we have run out of CASH and are 100% invested the BUY Forecast column simply shows $0.

Take a look.

Best regards,

Alex
Join InvestorsHub

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.