cannot run on the first time, force update some packages.

[div4r4k]

Hello, I realized of the existence of this project, tried to run it on my windows 10 machine..

This is the output when I tried to run it.

C:\binance-trade-bot\binance-trade-bot>python backtest.py
Traceback (most recent call last):
File "C:\binance-trade-bot\binance-trade-bot\backtest.py", line 3, in
from binance_trade_bot import backtest
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot_init_.py", line 1, in
from .backtest import backtest
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\backtest.py", line 8, in
from .binance_api_manager import BinanceAPIManager
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\binance_api_manager.py", line 10, in
from .binance_stream_manager import BinanceCache, BinanceOrder, BinanceStreamManager, OrderGuard
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\binance_stream_manager.py", line 11, in
from .config import Config
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\config.py", line 5, in
from .models import Coin
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\models_init_.py", line 5, in
from .pair import Pair
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\models\pair.py", line 8, in
class Pair(Base):
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\models\pair.py", line 22, in Pair
select([func.count(Coin.symbol) == 2])
File "C:\ProgramData\anaconda3\Lib\site-packages\sqlalchemy\sql_selectable_constructors.py", line 485, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5338, in init
coercions.expect(
File "C:\ProgramData\anaconda3\Lib\site-packages\sqlalchemy\sql\coercions.py", line 395, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\ProgramData\anaconda3\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1132, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\Lib\site-packages\sqlalchemy\sql\coercions.py", line 695, in _raise_for_expected
super()._raise_for_expected(
File "C:\ProgramData\anaconda3\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.BinaryExpression object at 0x0000023DD881ABD0>]. Did you mean to say select(<sqlalchemy.sql.elements.BinaryExpression object at 0x0000023DD881ABD0>)?

Python 3.12.3

Please help and thanks in advance.

[div4r4k]

Here is my config file:

[binance_user_config]

All config params are explained in depth in the repo.

API key and Secret key created on Binance

api_key=
api_secret_key=

Starting coin, leave empty when it's the bridge.

It has to be in the supported_coin_list

current_coin=

#Bridge coin of your choice
bridge=USDT

#com or us, depending on region
tld=com

#Defines how long the scout history is stored
hourToKeepScoutHistory=1

#Defines to use either scout_margin or scout_multiplier
use_margin=no

It's recommended to use something between 3-7 as scout_multiplier

scout_multiplier=5

#It's recommended to use something between 0.3 and 1.2 as scout_margin
scout_margin=0.8

Controls how many seconds bot should wait between analysis of current prices

scout_sleep_time=1

Pre-configured strategies are default and multiple_coins

strategy=multiple_coins

Controls how many minutes to wait before cancelling a limit order (buy/sell) and returning to "scout" mode.

0 means that the order will never be cancelled prematurely.

buy_timeout=20
sell_timeout=20

[div4r4k]

By the way, I have installed SqlAlchemy 2.0.38

[carlosmiei]

@div4r4k Thanks for reporting it, we will try to analyze this issue soon.

[carlosmiei]

@div4r4k HUm locally seems to be working fine to me

[Zhongheng-Cheng]

@div4r4k Try downgrading sqlalchemy to <=1.4, for example pip install sqlalchemy==1.4.15.

The syntax of the code is based on sqlalchemy 1.4+, which is different from sqlalchemy 2.0+.

[div4r4k]

Well, I create a new virtual environment using conda, could install specific version that @Zhongheng-Cheng suggested.
Now I am getting this:

python -m binance_trade_bot
2025-04-14 00:04:02,973 - crypto_trading_logger - INFO - Starting
Please provide the api secret and license token of your lucit license! Read this article for more information: https://medium.lucit.tech/87b0088124a8
LUCIT License Manager is shutting down!
Traceback (most recent call last):
File "", line 198, in _run_module_as_main
File "", line 88, in run_code
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot_main.py", line 5, in
main()
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\crypto_trading.py", line 18, in main
manager = BinanceAPIManager(config, db, logger, config.TESTNET)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\binance_api_manager.py", line 33, in init
self.setup_websockets()
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\binance_api_manager.py", line 36, in setup_websockets
self.stream_manager = BinanceStreamManager(
^^^^^^^^^^^^^^^^^^^^^
File "C:\binance-trade-bot\binance-trade-bot\binance_trade_bot\binance_stream_manager.py", line 81, in init
self.bw_api_manager = BinanceWebSocketApiManager(
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "unicorn_binance_websocket_api\manager.py", line 276, in unicorn_binance_websocket_api.manager.BinanceWebSocketApiManager.init
File "unicorn_binance_websocket_api\licensing_manager.py", line 141, in unicorn_binance_websocket_api.licensing_manager.LucitLicensingManager.init
unicorn_binance_websocket_api.licensing_exceptions.NoValidatedLucitLicense: Please provide the api secret and license token of your lucit license! Read this article for more information: https://medium.lucit.tech/87b0088124a8

This bot requires a license to use it?