Extreme Deviation Automatic Price Targeting - "X_DEV" - Bitcoin

[AIMAGIC]

Hi Myst,

I have shared an ETH sheet with you that incorporates a new formula in the Shares Bot column. Take a look.

Doing this turned out to be a bit complicated. I also had to adjust the formula in the CASH VALUE column - column "V".

Previously, the CASH VALUE column also linked to the CLOSE column - column "E".

Now, the formula in the CASH VALUE column adds or subtracts from the CASH VALUE based on the correct BUY or SELL amount. Take a look.

In the ETH sheet I have shared with you, by correcting the CASH VALUE calculation from row to row, there is a dramatic performance improvement. I have yet to test this on other plays.

Experiment with the sheet and please confirm this is the case as well.

Aside from the above, the sheet includes your most recent SELL Market Order and BUY Market Order formulas.

The sheet also incorporates the “1-day lag” version of the formulas in the SELL Market Order and BUY Market Order columns. In other words, following the way XDEV is designed to work, it uses the previous day's XDEV factor in order to allow limit orders to be set in advance.

The above is certainly progress. However, at this stage, we still lack the functionality to set Limit Orders in advance.

We need to replicated the following on the sheet:



As shown in the picture, each row will have to show the amount to BUY and SELL, covering both eventualities in advance, to allow us to set limits orders.

I will try and add 2 new columns to the sheet and title them BUY Forecast and SELL Forecast and have them show the BUY or SELL amounts to set as limit orders.

Entering the OHLC information into the spreadsheet the next day will confirm which of the two options was hit - or none at all - and the existing calculations on the sheet will update the sheet in the usual way.

However, as in the picture above, we need to calculate both options in advance in each row in order to set limit orders in advance.

Kind regards,

Alex