No-Code LightGBM Excel Tool
Budget: $250 – $750 USD
I hold several Excel workbooks filled with time-stamped price series and technical indicators. What I need is a friction-free way to feed those files into LightGBM, let the algorithm learn the patterns, and give me back concrete trading rules—all without writing a single line of code.
Interface
I’m open-minded about how the front end looks. It could live inside Excel as an add-in, appear as custom formulas, or run as a small desktop / web app that simply accepts my spreadsheets. The only must-have is ease: choose a file, tweak a few parameters if I wish, and hit “Run.”
Core workflow
• Upload Excel files (CSV compatibility is fine too).
• Pick the target column—typically tomorrow’s return or a directional flag.
• Train a LightGBM model with sensible default hyper-parameters and cross-validation.
• Return two key outputs:
– Ranked feature importance so I know which indicators matter.
– Human-readable trading rules or “IF-THEN” decision snippets distilled from the model.
Nice-to-have extras (not mandatory)
• Quick charts that compare in-sample vs. out-of-sample performance.
• A simple toggle for regression vs. classification.
Tech notes
Python + LightGBM are perfectly fine; wrap them in Flask, Office-JS, or .NET if that yields the simplest installer for Windows 10/11. Just make sure the user experience stays point-and-click.
Acceptance
I’ll consider the project complete when I can load one of my existing spreadsheets, click a single button, and receive both an importance table and a list of interpretable trading rules in under a minute on a normal laptop.
If this sounds like your wheelhouse, let’s talk timing and milestones.
Interface
I’m open-minded about how the front end looks. It could live inside Excel as an add-in, appear as custom formulas, or run as a small desktop / web app that simply accepts my spreadsheets. The only must-have is ease: choose a file, tweak a few parameters if I wish, and hit “Run.”
Core workflow
• Upload Excel files (CSV compatibility is fine too).
• Pick the target column—typically tomorrow’s return or a directional flag.
• Train a LightGBM model with sensible default hyper-parameters and cross-validation.
• Return two key outputs:
– Ranked feature importance so I know which indicators matter.
– Human-readable trading rules or “IF-THEN” decision snippets distilled from the model.
Nice-to-have extras (not mandatory)
• Quick charts that compare in-sample vs. out-of-sample performance.
• A simple toggle for regression vs. classification.
Tech notes
Python + LightGBM are perfectly fine; wrap them in Flask, Office-JS, or .NET if that yields the simplest installer for Windows 10/11. Just make sure the user experience stays point-and-click.
Acceptance
I’ll consider the project complete when I can load one of my existing spreadsheets, click a single button, and receive both an importance table and a list of interpretable trading rules in under a minute on a normal laptop.
If this sounds like your wheelhouse, let’s talk timing and milestones.
Related categories:
Python
Visual Basic
Data Processing
Excel
C# Programming
Flask
Data Visualization
Data Analysis