CSV Export & Import Workflow

Complete TradingView to Algo Trade Analytics CSV Workflow

Bridge your TradingView strategy signals with Algo Trade Analytics using the CSV workflow. This method is perfect for analyzing historical strategy performance and comparing backtesting results with live execution.

Overview

The CSV workflow involves two main steps:

1. Export strategy alerts from TradingView to CSV format
2. Import the CSV data into Algo Trade Analytics for signal vs execution analysis

This method is ideal for:

• Historical strategy analysis
• Backtesting validation
• One-time data migration
• Manual signal review

For real-time automation, consider using Webhook Integration instead.

Part 1: TradingView CSV Export

Step 1: Configure Strategy Alerts

In your TradingView Pine Script strategy, ensure you have proper alert conditions:

//@version=5
strategy("My Strategy", overlay=true)

// Your strategy logic here
longCondition = ta.crossover(ta.sma(close, 14), ta.sma(close, 28))
shortCondition = ta.crossunder(ta.sma(close, 14), ta.sma(close, 28))

if longCondition
    strategy.entry("Long", strategy.long)
    // Alert for CSV export
    alert("BUY," + str.tostring(close) + "," + str.tostring(time))

if shortCondition
    strategy.entry("Short", strategy.short)
    // Alert for CSV export
    alert("SELL," + str.tostring(close) + "," + str.tostring(time))

Step 2: Set Up TradingView Alert

1. Right-click on your chart and select “Add Alert”
2. Condition: Select your strategy and “alert() function calls”
3. Options:
   • Frequency: “Once Per Bar Close” (recommended)
   • Enable “Webhook URL” checkbox
4. Message: Use this format for Algo Trade Analytics compatibility:

   {"action": "{{plot("action")}}", "price": {{close}}, "time": "{{time}}", "symbol": "{{ticker}}"}

Step 3: Export Alert Log to CSV

1. Navigate to TradingView Alert Log
2. Filter alerts by your strategy
3. Select timeframe for export
4. Download as CSV file

Required CSV Format

Your CSV should contain these columns:

Column	Description	Example
action	BUY or SELL	BUY
symbol	Trading symbol	AAPL
price	Signal price	150.25
time	UTC timestamp	2024-01-15T14:30:00Z
quantity	Position size (optional)	100

Common Export Issues

❌ Problem: Missing timestamps ✅ Solution: Ensure your alert includes {{time}} placeholder

❌ Problem: Incorrect price data
✅ Solution: Use {{close}} for current bar close price

❌ Problem: Mixed signal formats ✅ Solution: Standardize BUY/SELL action naming

Part 2: Algo Trade Analytics CSV Import

Step 1: Access Import Interface

1. Login to Algo Trade Analytics dashboard
2. Navigate to “Data Import” section
3. Select “CSV Import” option

Step 2: Upload and Validate

1. Choose your CSV file
2. Map columns to Algo Trade Analytics fields:
   • Action → Signal Type
   • Price → Signal Price
   • Time → Signal Time
   • Symbol → Trading Symbol
3. Preview data mapping
4. Validate format and timestamps

Step 3: Import Configuration

Configure import settings:

• Time Zone: Match your TradingView timezone
• Duplicate Handling: Skip or overwrite
• Signal Processing: Enable/disable signal filtering

Step 4: Review Import Results

After import completion:

• Verify signal count matches expectations
• Check for any failed imports
• Review data in signals dashboard

Data Validation & Quality Checks

Automatic Validations

Algo Trade Analytics automatically checks:

• ✅ Valid timestamp format
• ✅ Numeric price values
• ✅ Recognized symbol format
• ✅ Valid action types (BUY/SELL)

Manual Review Checklist

Before analysis, verify:

• Signal timing matches your strategy
• Price levels are reasonable
• No duplicate signals
• Complete time coverage

Next Steps: Analysis

Once imported, you can:

1. Compare Signals vs Execution in the analytics dashboard
2. Identify Execution Gaps between signals and actual trades
3. Export Results back to Pine Script for TradingView visualization
4. Optimize Strategy based on execution analysis

Troubleshooting

Import Errors

Error: “Invalid timestamp format” Solution: Ensure timestamps are in ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ)

Error: “Unknown symbol”
Solution: Use standard symbol naming (e.g., “AAPL” not “NASDAQ:AAPL”)

Error: “Duplicate signals detected” Solution: Check for multiple alerts on same bar, clean data before import

Performance Issues

Slow Import: Large CSV files (>10MB) may take several minutes Memory Errors: Split large files into smaller chunks (<5MB each)

Advanced Tips

Batch Processing

• Import multiple strategies separately for comparison
• Use consistent naming conventions
• Tag imports with strategy version numbers

Data Enrichment

• Add custom fields for strategy parameters
• Include market condition tags
• Note any manual intervention signals

Related Documentation

• Webhook Integration - For real-time automation
• Pine Script Export - Export results back to TradingView
• Strategy Configuration - Optimize your TradingView setup