Commit Graph

61 Commits

Author SHA1 Message Date
21be9b40b7 Add PG_CONN_STR to .env.example for host-side PostgreSQL connection 2026-07-30 22:15:57 +02:00
7d702e9cbd Migrate data pipeline from SQLite to PostgreSQL + Docker setup
- Add db.py PostgreSQL abstraction layer (connection, upsert, table mgmt)
- Replace sqlite3 with psycopg2 in: live_candle_fetcher, resampler,
  data_fetcher, fetch_history, import_csv, indicators, base_strategy
- Sanitize table names (colons -> underscores) for PostgreSQL compat
- Replace INSERT OR REPLACE with ON CONFLICT upserts
- Replace pandas to_sql() with batch upsert_candles()
- Add scripts: resampler_loop, gap_detector, backup_runner, cron_scheduler
- Add migrate_sqlite_to_pg.py for one-time data migration
- Add Dockerfile, docker-compose.yml, supervisord.conf
- Add postgres/postgresql.conf tuned for 4GB RAM (Synology DS1513+)
- Add .dockerignore, .env.docker.example, secrets template
- Update requirements.txt (psycopg2-binary), .gitignore
- Add MIGRATION_PLAN.md with full plan and todo list
2026-07-30 22:14:31 +02:00
ade9b708a2 Add account data fetching and display balances in dashboard 2026-07-30 21:15:48 +02:00
76f58386dc Fix spot balance Value column to show USD value instead of raw token amount 2026-07-30 11:53:28 +02:00
a5660bf479 Change XYZ100/USTECH fallback reference to 41.10 2026-07-29 20:28:17 +02:00
a620025365 Add XYZ100/USTECH ratio indicator with 41.18 fallback reference 2026-07-29 18:16:22 +02:00
5d13280f7d Add mkts:USTECH and xyz:XYZ100 to dashboard market table 2026-07-29 18:07:17 +02:00
f6d95de49f Add GOLD/SILVER ratio indicator to dashboard
Add gold_silver_ratio indicator (xyz:GOLD / xyz:SILVER) with fallback
reference of 61.59, mirroring the existing WTI/BRENT ratio setup.
Also register xyz:GOLD and xyz:SILVER in WATCHED_COINS and data_fetcher
defaults so the candle data is fetched for the new indicator.
2026-07-29 17:02:15 +02:00
8b88aee61f Add fallback_reference for deviation when insufficient data points
Add optional min_data_points (default 100) and fallback_reference config
fields to indicator definitions. When available daily data points are
below min_data_points, the fallback_reference value is used as the
deviation reference instead of the computed mean.

Applied to ratio, price, spread, and diff_pct indicator types.
Configured WTI/BRENT ratio with fallback_reference=0.96065.
2026-07-29 09:36:35 +02:00
63bab43557 Add indicators fetcher, rich dashboard renderer, and remove trade executor/status 2026-07-29 09:11:13 +02:00
2a8ee9c8c5 Remove ASTER, PUMP, ZEC from dashboard and stop tracking their history
- Remove ASTER, PUMP, ZEC from WATCHED_COINS in main_app.py
- Remove ASTER, PUMP, ZEC from coin_id_map.json (stops market cap collection)
- Remove ASTER, PUMP, ZEC from market_cap_data.json summary
- Remove ASTER, PUMP, ZEC manual overrides from coin_id_map.py
- Remove ASTER, PUMP, ZEC from resampling_status.json (gitignored)
- Add WIKI/symbol_management.md documentation for adding/removing symbols

Existing data in market_data.db is preserved; only new data collection stops.
2026-07-28 09:43:39 +02:00
68e528c1f6 Restructured hedger modules: moved CLP hedger and auto hedger into separate folders, updated data fetchers and main app, removed deprecated files 2026-07-28 08:26:14 +02:00
e1b3c5814b hedge and auto hedger in separate folders 2025-12-16 14:19:24 +01:00
109ef7cd24 optimalized parameters 2025-12-15 09:33:32 +01:00
b85fcb8246 fixed hedge_status.json 2025-12-14 22:11:36 +01:00
e31079cdbb clp hedge zones 2025-12-14 19:03:50 +01:00
84242f3654 CLP auto hedge 2025-12-12 23:49:50 +01:00
aeaae84750 remove market_data.db-shm from tracking 2025-11-11 10:56:47 +01:00
89b8e53092 Create AGENTS.md file for tracking agent usage and improvements
- Added comprehensive agent documentation and usage tracking
- Created session history table with dates and agent usage
- Documented sessionsummary agent configuration and features
- Included agent improvement ideas and maintenance guidelines
- Established framework for tracking agent effectiveness over time
- Provides centralized location for agent-related information
2025-11-11 10:25:05 +01:00
eaceeb7e3b Add final session summary for DashboardDataFetcher fix
- Documented debugging session that resolved critical path resolution error
- Added comprehensive session summary covering problem identification, solution, and testing
- Recorded decisions made and files modified during the fix
- Included next steps for ongoing monitoring and improvement
- Maintained structured format consistent with sessionsummary agent specifications
2025-11-11 10:23:19 +01:00
25e9a22a8e Fix DashboardDataFetcher path resolution error
- Use absolute path for status file to ensure consistency across subprocess execution
- Add os.makedirs() call to ensure _logs directory exists
- Prevents 'No such file or directory' error when running as subprocess
- Fixes issue: [Errno 2] No such file or directory: '_logs/trade_executor_status.json.tmp'
2025-11-11 00:38:07 +01:00
8494583779 Organize project files and add session summaries
- Create .temp folder for examples and temporary files
- Update .gitignore to include .temp/ directory
- Move model_comparison_examples.md to .temp folder
- Add session summaries to GEMINI.md for current development work
- Remove obsolete documentation files (IMPROVEMENT_ROADMAP.md, PROJECT_REVIEW_AND_PROPOSALS.md, README.md)
- Maintain clean project structure with proper file organization
2025-11-11 00:32:35 +01:00
aea341792e ci: ignore .opencode directory 2025-11-10 22:41:50 +01:00
e8d7db2743 Merge remote-tracking branch 'origin/web_socket' 2025-11-10 09:23:44 +01:00
bdd2d607cd Delete _data/strategy_status_sma_cross_2.json 2025-11-10 08:19:06 +00:00
ac843b0f82 sdk remove 2025-11-10 08:59:07 +01:00
b8ad857ca4 ignore 2025-11-10 08:57:57 +01:00
bf88c16383 "Stop tracking sdk files" 2025-11-10 08:54:56 +01:00
3000a366be gitignore 2025-11-10 08:54:02 +01:00
f8afdc1ab1 Delete _data/strategy_status_sma_cross_2.json 2025-11-09 21:50:34 +00:00
fd7b208fff Merge branch 'web_socket' of https://git.kapuscinski.pl/ditus/hyper into web_socket 2025-11-09 22:08:04 +01:00
1165060bc0 deleted 2025-11-09 22:07:14 +01:00
0210bc93bc Delete _data/market_data.db-shm 2025-11-09 18:43:59 +00:00
596fcde0bf bid, ask, last traded price 2025-11-04 13:34:49 +01:00
5f9109c3a9 size taken from monitored wallet 2025-11-02 22:38:31 +01:00
d650bb5fe2 updated fast orders 2025-11-02 19:56:40 +01:00
93363750ae fixes, old way to handle strategies 2025-10-27 21:54:33 +01:00
541a71d2a6 new strategies 2025-10-25 21:51:25 +02:00
76a858a7df detailed info about wallets 2025-10-25 19:59:13 +02:00
fe5cc8e1d1 market cap fixes 2025-10-25 19:58:52 +02:00
5805601218 tmiestamp_ms column added to all tables as primary key 2025-10-22 22:22:13 +02:00
afbb4e4976 wallet info 2025-10-21 23:53:06 +02:00
75c0cc77cc save market cap of all coins 2025-10-21 23:52:32 +02:00
5a05f0d190 resampler much faster 2025-10-21 23:07:07 +02:00
cac4405866 live market 2025-10-21 15:09:53 +02:00
2eef7dbc17 live market web socket 2025-10-21 15:09:14 +02:00
70f3d48336 live market websocket and monitoring wallets 2025-10-20 20:46:48 +02:00
64f7866083 WALK-FORWARD testing 2025-10-18 18:40:50 +02:00
6812c481e5 backword forward strategy 2025-10-18 18:29:06 +02:00
2b55851136 wiki 2025-10-18 15:55:53 +02:00