I see that you are working on a grid bot. I've been looking for weeks for a grid that can work with Margin like the ones at Pionex do. That would be a killer feature that I'd be happy to compensate for!

Describe the bug
Even though my Binance balance is 1000 EUR, InsufficientFunds error is raised when bot_config has starting_balance = 500 and initial_entry_allocation = 20. However, when I try with starting_balance = 100 and initial_entry_allocation = 20 no error appears.

It is important to mention that the error shows up when the bot is trying to place the Sell order.

To Reproduce
Set bot_config to the following, ensure you have more than 500 EUR in your Binance balance. Then run defineBot() and executeBot().

bot_config = {
	'name': 'bot0',
        'test_run': False,
	'exchange': exchange_binance,
	'symbols': ['BTC/EUR', 'ETH/EUR', 'ADA/EUR'],
	'starting_balance': 500.00,
	'strategy': {
		'class': BBRSIStrategy,
		'params': {
			'bb_len': 20,
			'n_std': 2.0,
			'rsi_len': 14,
			'rsi_overbought': 60,
			'rsi_oversold': 40,
		}
	},
	'timeframe': '5m',
	'entry_settings': {
		'initial_entry_allocation': 20,
		'signal_distance': 0.1
	},
	'exit_settings': {
		'take_profit': 2,
		'stop_loss_value': 1
	},
	'display_status': True
}

Expected behavior
InsufficientFunds error should not be raised when the Binance balance is greater than the starting_balance.

Screenshots

Desktop (please complete the following information):

• OS: Windows 10
• Browser: N/A
• Version: pyjuque 0.1.1.9

Additional context
Typically it happens placing the second Sell order, but occasionally it happened during the first Sell order.

Running the bot on multiple symbols. 1m timeframe. After a while all the filled buy orders get this error:

INFO:pyjuque.Engine.BotController:FILLED BUY order on BNB/USDT, try exit.
INFO:pyjuque.Engine.BotController:Error placing order for BNB/USDT:
(<class 'ccxt.base.errors.InsufficientFunds'>, InsufficientFunds('binance Account has insufficient balance for requested action.'), <traceback object at 0x7f9db3739ec0>)

I tried playing around with removing take profit, changing 'signal_distance' to market orders. But the issue remains.

The bot is unable to evaluate stop loss or exit signals after this error occurred for a symbol.

Help is appreciated!

Thanks

Describe the bug
A clear and concise description of what the bug is.
I have bee using pyjuque in test mode and also in live mode. I see the bot getting a signal and trying to place the order. While doing so I get like the same kind of error on both of my exchanges. I use bitpanda and kraken.
for Bitpanda the error is
{"error":"INVALID_CLIENT_UUID"}

for Kranken I get this
<class 'ccxt.base.errors.ExchangeError'>
kraken {"error":["EGeneral:Invalid arguments:userref"]}

I am new to python programming so I am not quite sure. I was going through the code and I always get to a point where the custom_order_id is being involved.

Expected behavior
calling ccxt.createorder directly leads to an order being palced on the exchange without error.

Desktop (please complete the following information):

• OS: windows 10
  using pycharm21.1 and python 3.8.5

In the code I saw that for the uuid4 the dashes were replaced/removed. So maybe thats the reason for the uuid being faulty.

Thanks
Jochen

Hello,
I tried to use the code. (Second strategy).
but I keep getting this error and I just don't know where the problem is.
That is the code:

import time

Imports for the strategy

import pandas_ta as ta

Importing these to be able to run this example

from the main pyjuque folder

from os.path import abspath, pardir, join
import sys
curr_path = abspath(file)
root_path = abspath(join(curr_path, pardir, pardir))
sys.path.append(root_path)

Import for defining the bot

from pyjuque.Bot import defineBot

Import for defining the Strategy

from pyjuque.Strategies import StrategyTemplate

Defines the strategy

class BBRSIStrategy(StrategyTemplate):
""" Bollinger Bands x RSI """
def init(self, rsi_len = 8, bb_len = 100, rsi_ob = 50, rsi_os = 50):
self.rsi_ob = rsi_ob
self.rsi_os = rsi_os
self.bb_len = bb_len
self.rsi_len = rsi_len

    # the minimum number of candles needed to compute our indicators
    self.minimum_period = max(100, bb_len, rsi_len)

# the bot will call this function with the latest data from the exchange 
# passed through df; this function computes all the indicators needed
# for the signal
def setUp(self, df):
    df['rsi'] = ta.rsi(df['close'], self.rsi_len)
    df['lbb'], df['mbb'], df['ubb'], df['bb_width'] = ta.bbands(df['close'], self.bb_len)
    self.dataframe = df

# the bot will call this function with the latest data and if this 
# returns true, our bot will place an order
def checkLongSignal(self, i = None):
    """ if the rsi had a sudden increase this candle or the previous one, 
    and one of the previous three values of the rsi was under the oversold 
    level, and the price just crossed over the lower bollinger band, buy"""
    df = self.dataframe
    if i == None:
        i = len(df) - 1
    if i < 3:
        return False
    if (df["rsi"][i] / df["rsi"][i-1] > 1.2) and \
        (df["rsi"][i-1] < self.rsi_os \
            or df["rsi"][i-2] < self.rsi_os \
            or df["rsi"][i-3] < self.rsi_os):
        if ((df["open"][i] < df["lbb"][i] < df["close"][i]) and \
            (df["open"][i-1] < df["lbb"][i-1] and df["close"][i-1] < df["lbb"][i-1])):
            return True
    if (df["rsi"][i-1] / df["rsi"][i-2] > 1.2) and \
        (df["rsi"][i-1] < self.rsi_os \
            or df["rsi"][i-2] < self.rsi_os \
            or df["rsi"][i-3] < self.rsi_os):
        if (df["close"][i-3] < df["lbb"][i-3] and df["close"][i-2] < df["lbb"][i-2] \
            and df["close"][i-1] > df["lbb"][i-1] and df["close"][i] > df["lbb"][i]):
            return True
    return False

# we don't exit on signal, only on take profit pr stop loss level reached
def checkShortSignal(self, i = None):
    return False

Defines the overall configuration of the bot

bot_config = {
# Name of the bot, as stored in the database
'name' : 'my_bot',

# exchange information (fill with your api key and secret)
'exchange' : {
    'name' : 'binance',
    'params' : {
        'api_key': '...',
        'secret' : '...'
    },
},

# symbols to trade on
'symbols' : ['LINK/BTC', 'ETH/BTC'],

# starting balance for bot
'starting_balance' : 0.0005,

# strategy class / function (here we define the entry and exit strategies.)
# this bot places an entry order when the 'checkLongSignal' function of 
# the strategy below retruns true
'strategy': {
    'class': BBRSIStrategy,
    'params': {
        'rsi_len' : 8, 
        'bb_len' : 100, 
        'rsi_ob' : 50, 
        'rsi_os' : 50
    }
},

# when the bot receives the buy signal, the order is placed according 
# to the settings specified below
'entry_settings' : {

    # between 0 and 100, the % of the starting_balance to put in an order
    'initial_entry_allocation': 100,

    # number between 0 and 100 - 1% means that when we get a buy signal, 
    # we place buy order 1% below current price. if 0, we place a market 
    # order immediately upon receiving signal
    'signal_distance': 0.3
},

# This bot exits when our filled orders have reached a take_profit % above 
# the buy price, or a stop_loss_value % below it
'exit_settings' : {

    # take profit value between 0 and infinity, 3% means we place our sell 
    # orders 3% above the prices that our buy orders filled at
    'take_profit' : 3,

    # stop loss value in percent - 10% means stop loss at 10% below our 
    # buy order's filled price
    'stop_loss_value': 10
},

# will the bot display its status / current performing action in the terminal
'display_status' : True

}

Runs the bot in an infinite loop, stoppable from the terminal with CTRL + C

def Main():
bot_controller = defineBot(bot_config)
while True:
try:
bot_controller.executeBot()
except KeyboardInterrupt:
return

    time.sleep(60)

if name == 'main':
Main()

okex exchange now didn't work - api change from api-v3 to api-v5
pip install ccxt==1.56.29 --no-deps
fix this problem

Description
When I run a bot for the first time I am getting this error:

InvalidRequestError: One or more mappers failed to initialize - can't proceed with initialization of other mappers. Triggering mapper: 'mapped class EntrySettingsModel->entry_settings'. Original exception was: Could not determine join condition between parent/child tables on relationship EntrySettingsModel.bots - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression.

Traceback

Traceback (most recent call last):

  File "E:\TradingBot\Tests\Bot\pyjuque\test.py", line 70, in <module>
    main()

  File "E:\TradingBot\Tests\Bot\pyjuque\test.py", line 59, in main
    bot_controller = defineBot(bot_config)

  File "E:\Programs\anaconda3\lib\site-packages\pyjuque\Bot.py", line 75, in defineBot
    bot_controller = _defineTaBot(bot_config)

  File "E:\Programs\anaconda3\lib\site-packages\pyjuque\Bot.py", line 85, in _defineTaBot
    bot_model = session.query(TABotModel).filter_by(name=bot_name).first()

  File "E:\Programs\anaconda3\lib\site-packages\sqlalchemy\orm\session.py", line 1584, in query
    return self._query_cls(entities, self, **kwargs)

  File "E:\Programs\anaconda3\lib\site-packages\sqlalchemy\orm\query.py", line 199, in __init__
    self._set_entities(entities)

  File "E:\Programs\anaconda3\lib\site-packages\sqlalchemy\orm\query.py", line 227, in _set_entities
    self._set_entity_selectables(self._entities)

  File "E:\Programs\anaconda3\lib\site-packages\sqlalchemy\orm\query.py", line 258, in _set_entity_selectables
    ent.setup_entity(*d[entity])

  File "E:\Programs\anaconda3\lib\site-packages\sqlalchemy\orm\query.py", line 4292, in setup_entity
    self._with_polymorphic = ext_info.with_polymorphic_mappers

  File "E:\Programs\anaconda3\lib\site-packages\sqlalchemy\util\langhelpers.py", line 883, in __get__
    obj.__dict__[self.__name__] = result = self.fget(obj)

  File "E:\Programs\anaconda3\lib\site-packages\sqlalchemy\orm\mapper.py", line 2158, in _with_polymorphic_mappers
    configure_mappers()

  File "E:\Programs\anaconda3\lib\site-packages\sqlalchemy\orm\mapper.py", line 3276, in configure_mappers
    raise e

System Information:

• OS: Windows 10
• Anaconda 3
• Spyder 4.1.4

Branch:

• master

Additional info
I am not sure which tables are involved, am I missing something?
testbot.txt

Get error, when entry_settings -> signal_distance = 0

quantity = quote_qty / desired_price
TypeError: unsupported operand type(s) for /: 'decimal.Decimal' and 'NoneType'

When having more then one pair in open Sell orders recive Order Not Found from Binance code: -2013, msg: Order does not exists.

Issue is only on testing False condition (works great in test mode) and only if more then one pair is in sell ored pool.

Hello,

I have the typical loop in my file:

def main():
	bot_controller = defineBot(bot_config)

	while True:
		try:
			bot_controller.executeBot()
		except KeyboardInterrupt:
			return

		sleep(15)

However, when I hit ctrl+c the terminal appears to react but not actually stop the program:

Am I misunderstanding something?

Thanks

Describe the bug

I added more funds in the exchange but pyjuque didn't notice because it's still using the starting/current balance from the database instead letting me update the balance:
INFO:pyjuque.Engine.BotController:Error placing order
<class 'ccxt.base.errors.InsufficientFunds'>

I manually sold the coin on the market. But pyjuque didn't notice it and kept on trying to access the record in the database and notify about it. Is there any to get rid of the old/expired records in the database?
INFO:pyjuque.Engine.BotController:Error getting data from the exchange for updating open order

I noticed the bot forgot to update match_order_id in the order table. I'm trying to figure out how to add some maintenance function in the bot to let it populate the match_order_id from current_order_id from pair table when it detects the match_order_id is blank...

Once in a while, the stop loss is putting a the buy match_order_id in sell match_order_id during cancel sell but the bot didn't notice it forgot to submit the order, which caused the match_order_id different from the order.id.

I was able to copy and paste the id into match_order_id manually to get the bot to stop screaming about orders not found. There's a lot of manual update on the database by hand because I can't seem to find the codes to fix the bott so it won't have mismatch id or NULL id.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

FTX has futures. They have symbols like ETH-PERP.

If I try to load up this symbol I get the error:

  File ".../lib/python3.9/site-packages/pyjuque/Bot.py", line 65, in defineBot
    quote_asset = symbols[0].split('/')[1]
IndexError: list index out of range

can you please help me to get your project working......I love the concept and want to use this to trade but cant get it to start up

C:\Users\mayhe\OneDrive\Desktop\pyjuque-master\pyjuque-master\venv\Scripts\python.exe "C:\Program Files\JetBrains\PyCharm Community Edition 2021.1.1\plugins\python-ce\helpers\pydev\pydevd.py" --multiproc --qt-support=auto --client 127.0.0.1 --port 53101 --file C:/Users/mayhe/OneDrive/Desktop/pyjuque-master/pyjuque-master/main.py
Connected to pydev debugger (build 211.7142.13)
Traceback (most recent call last):
File "C:\Program Files\JetBrains\PyCharm Community Edition 2021.1.1\plugins\python-ce\helpers\pydev\pydevd.py", line 1483, in _exec
pydev_imports.execfile(file, globals, locals) # execute the script
File "C:\Program Files\JetBrains\PyCharm Community Edition 2021.1.1\plugins\python-ce\helpers\pydev_pydev_imps_pydev_execfile.py", line 18, in execfile
exec(compile(contents+"\n", file, 'exec'), glob, loc)
File "C:/Users/mayhe/OneDrive/Desktop/pyjuque-master/pyjuque-master/main.py", line 17
'exchange' :
^
SyntaxError: invalid syntax

Process finished with exit code 1
Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

Hi Tudor,

I noticed that even though my bot_config has 'symbols': ['BTC/USDT', 'ETH/USDT'], in the DB table called pair 3 symbols show up (BTC, ETH and ADA) and ADA appears as active. Also ADA appears in the terminal when I executeBot().

Is the bot respecting my bot_config?

Thank you!

Description
When i am execute the python file examples/try_order_management.py in feature/order_management,
i will get following error stack:

$ python examples/try_order_management.py 
Getting active pairs:
Traceback (most recent call last):
  File "examples/try_order_management.py", line 73, in <module>
    Main()
  File "examples/try_order_management.py", line 63, in Main
    execute_bot(
  File "E:\Develop\pyjuque\bot\Engine\OrderManagement.py", line 16, in execute_bot
    active_pairs = bot.getActivePairs(session)
AttributeError: 'NoneType' object has no attribute 'getActivePairs'

System Information

• Windows 10 Professional
• VS Code V1.48.1
• Python 3.8.2

Additional Info
I think some values are not set in the database at this point, so it deliver a NoneType Error. I hope you can help me at this point to figure what the problem is in this case.

Thank you very much!

I cant seem to get this bot to work, can i get some beginner instructions on this matter

Hello @tudorelu,

I came across your Github account through another user and saw that you are creating an Algo Trading System and posting via YouTube. Awesome!

I noticed that you are using pyti for TA but it seems to have gone stale nearly two years ago. I was wondering if you would be interested in trying and incorporating Pandas TA into your project? It is built to be compatible with Pandas as an DataFrame extension, correlated with TA Lib (for common indicators), other popular indicators like TTM Squeeze and Trend, and much more! Also check out some Examples for implementation and features.

Thanks for your time,
Kevin Johnson

How to use the the open buy order time out?
i dont know how to use this parameter......or whats the time format to use this option