The Spreadsheet provides a familiar grid-based interface for working with data, formulas, and formatting — similar to Excel, but integrated with Hedgehog's metrics and live market data.
2. Getting Started
Open Spreadsheet from the Start Menu or the Navigation Bar.
Click any cell to start entering data.
Type values directly, or type a formula beginning with = to compute a value.
The expression bar at the bottom shows and allows editing of the current cell's formula.
3. Entering Data
Click a cell and type to enter a value.
Formulas begin with = and use HHLang expressions, e.g., =AAPL.close().last().
Press Enter to confirm the entry, Escape to cancel.
The expression bar at the bottom of the window shows the full formula for the selected cell.
4. Cell Operations
Operation
Shortcut
Copy
Ctrl+C
Cut
Ctrl+X
Paste
Ctrl+V
Undo
Ctrl+Z
Redo
Ctrl+Y
Drag to fill — drag the cell corner handle to extend a formula or value across adjacent cells.
Insert/delete — insert or delete rows and columns from the ribbon or context menu.
Merge cells — combine multiple cells into one from the ribbon.
5. Formatting
The Home ribbon tab provides formatting controls:
Font — family, size, bold, italic, underline, text color.
Alignment — horizontal (left, center, right) and vertical (top, middle, bottom).
Number format — general, number, currency, percentage, date/time, and decimal places.
Cell background — set a fill color for selected cells.
Borders — add and style cell borders.
Styles — apply pre-built formatting combinations.
6. Conditional Formatting
Apply rules that automatically format cells based on their values:
Single cell rules — color cells based on a condition (e.g., highlight negative numbers in red).
Heat map / gradient — apply a color scale across a range of values.
Uniqueness rules — highlight unique or duplicate values.
7. Grouping
Group rows or columns to create collapsible outlines, useful for organizing hierarchical data. Click the outline controls (+/-) to expand or collapse groups. Ungroup to remove outline levels.
8. Ribbon Tabs
Home
Clipboard, font, alignment, number format, styles, cells (insert/delete), editing, grouping, and insert controls.
Calculation
Trigger recalculation of all formulas in the spreadsheet.
9. Tips
Use HHLang functions in formulas to pull live market data directly into cells.
Export data from a Chart to a Spreadsheet to perform further analysis on chart data.
Use conditional formatting to quickly spot outliers or important values.