Cryptocurrency Data
Manage cryptocurrency markets, exchanges, trading pairs, and configure data synchronization from CoinGecko API.
CoinTrail fetches cryptocurrency data from the CoinGecko API and stores it locally for fast access. Data is updated automatically via cron jobs or can be refreshed manually.
Crypto Markets
Access cryptocurrency market data at Admin Panel > Crypto > Crypto Markets. This section displays all tracked cryptocurrencies with their current market data.
The Crypto Markets section displays all tracked cryptocurrencies with real-time market data
Market Data Fields
Each cryptocurrency record contains comprehensive market information:
| Column | Description | Data Source |
|---|---|---|
| Rank | Market capitalization ranking position | market_cap_rank |
| Name | Full cryptocurrency name (e.g., Bitcoin) | name |
| Symbol | Trading symbol (e.g., BTC, ETH) | symbol |
| Price | Current price in selected currency | current_price |
| 24h Change | Price change percentage (24 hours) | price_change_percentage_24h |
| 7d Change | Price change percentage (7 days) | price_change_percentage_7d |
| Market Cap | Total market capitalization | market_cap |
| Volume (24h) | Trading volume in last 24 hours | total_volume |
| Circulating Supply | Coins currently in circulation | circulating_supply |
Detailed Coin Information
Each cryptocurrency record also stores additional metadata:
Price Data
Current price, ATH, ATL, 24h high/low, price changes across multiple timeframes.
Supply Data
Circulating supply, total supply, max supply, fully diluted valuation.
Links & Social
Official website, whitepaper, Twitter, Telegram, Reddit, GitHub repositories.
Basic Information
CoinGecko ID, description, genesis date, hashing algorithm.
Available Actions
- View Details: View complete coin information including historical data and price charts
- Refresh Data: Manually trigger a data refresh from CoinGecko API for a specific coin
- Edit: Modify coin description, custom fields, or visibility settings
- Hide/Show: Toggle visibility on the frontend without deleting the record
Detailed view of an individual cryptocurrency with complete market data, supply info, and social links
Exchanges
Manage cryptocurrency exchange listings at Admin Panel > Crypto > Exchanges.
Exchange management interface displaying all tracked cryptocurrency exchanges
Exchange Data Fields
| Field | Type | Description |
|---|---|---|
exchange_id |
String | CoinGecko exchange identifier (e.g., "binance") |
name |
String | Exchange name (Binance, Coinbase, Kraken) |
country |
String | Headquarters country |
year_established |
Integer | Year the exchange was founded |
trust_score |
Integer | CoinGecko trust score (1-10) |
trust_score_rank |
Integer | Ranking by trust score |
trade_volume_24h_btc |
Decimal | 24-hour trading volume in BTC |
url |
URL | Exchange website URL |
centralized |
Boolean | True for CEX, false for DEX |
Exchange Types
Centralized (CEX)
Traditional exchanges like Binance, Coinbase, Kraken. Order book trading with custodial wallets.
Decentralized (DEX)
On-chain exchanges like Uniswap, PancakeSwap. Non-custodial with AMM trading.
Derivatives
Futures and options trading platforms like Binance Futures, dYdX, GMX.
Cryptocurrency Wallets
Manage cryptocurrency wallet information at Admin Panel > Crypto Data > Wallets. This section provides educational wallet content for users.
Admin Panel → Crypto Data → Wallets (/admin/wallets)
Manage cryptocurrency wallet listings with types, supported coins, and ratings
Wallet Types
Hardware Wallets
Physical devices like Ledger, Trezor, SafePal. Cold storage for maximum security.
Software Wallets
Desktop applications like Exodus, Electrum, Atomic. Hot wallets with convenience.
Mobile Wallets
Smartphone apps like Trust Wallet, MetaMask Mobile. Access on the go.
Web Wallets
Browser-based like MetaMask extension. Easy access with security trade-offs.
Wallet Data Fields
| Field | Type | Description |
|---|---|---|
name |
String | Wallet name (e.g., "Ledger Nano X") |
slug |
String | URL-friendly identifier |
type |
Select | Hardware, Software, Mobile, Web, Paper |
description |
Rich Text | Detailed wallet description and review |
logo |
Image | Wallet logo image |
website_url |
URL | Official wallet website |
supported_coins |
Multi-Select | Cryptocurrencies supported by the wallet |
platforms |
Multi-Select | Available platforms (Windows, Mac, Linux, iOS, Android) |
security_rating |
Integer | Security rating (1-5 stars) |
ease_of_use_rating |
Integer | Ease of use rating (1-5 stars) |
features |
JSON | Feature list (staking, dApp browser, exchange, etc.) |
pros |
Array | Advantages of the wallet |
cons |
Array | Disadvantages or limitations |
price |
Decimal | Price (for hardware wallets, 0 for free) |
affiliate_url |
URL | Optional affiliate purchase link |
is_featured |
Boolean | Highlight on wallets page |
is_active |
Boolean | Display on frontend |
Create and edit wallet listings with comprehensive detail fields
Wallet Comparison
Users can compare wallets on the frontend by:
- Type Filter: Filter by hardware, software, mobile, or web
- Coin Support: Find wallets supporting specific cryptocurrencies
- Platform Filter: Filter by operating system compatibility
- Feature Comparison: Side-by-side feature comparison
- Security Rating: Sort by security rating
Currency Rates
Manage fiat currency exchange rates at Admin Panel > Crypto Data > Currency Rates.
Admin Panel → Crypto Data → Currency Rates (/admin/currency-rates)
Manage fiat currency exchange rates for multi-currency support
Purpose of Currency Rates
Currency rates enable CoinTrail to display cryptocurrency prices in multiple fiat currencies:
- User Preference: Users can view prices in their preferred currency (USD, EUR, GBP, etc.)
- Accurate Conversion: Real-time conversion using up-to-date exchange rates
- Subscription Pricing: Display subscription prices in local currencies
- Payment Processing: Convert payments to the site's base currency
Currency Rate Fields
| Field | Type | Description |
|---|---|---|
code |
String | ISO 4217 currency code (USD, EUR, GBP) |
name |
String | Full currency name (US Dollar, Euro) |
symbol |
String | Currency symbol ($, €, £) |
rate |
Decimal | Exchange rate relative to USD (base currency) |
decimal_places |
Integer | Number of decimal places for display |
symbol_position |
Select | before ($100) or after (100€) |
thousands_separator |
String | Thousands separator (comma or period) |
decimal_separator |
String | Decimal separator (period or comma) |
is_active |
Boolean | Enable for user selection |
is_default |
Boolean | Default currency for new users |
updated_at |
DateTime | Last rate update timestamp |
Supported Currencies
CoinTrail supports major world currencies:
| Code | Currency | Symbol | Region |
|---|---|---|---|
| USD | US Dollar | $ | United States |
| EUR | Euro | € | Eurozone |
| GBP | British Pound | £ | United Kingdom |
| JPY | Japanese Yen | ¥ | Japan |
| CHF | Swiss Franc | Fr | Switzerland |
| CAD | Canadian Dollar | C$ | Canada |
| AUD | Australian Dollar | A$ | Australia |
| CNY | Chinese Yuan | ¥ | China |
| INR | Indian Rupee | ₹ | India |
| BRL | Brazilian Real | R$ | Brazil |
| KRW | South Korean Won | ₩ | South Korea |
| NGN | Nigerian Naira | ₦ | Nigeria |
Rate Update Source
Currency rates can be updated from multiple sources:
- Fixer.io API: Primary source for real-time exchange rates
- CoinGecko API: Includes currency conversion in cryptocurrency data
- Manual Entry: Admins can manually update rates if needed
To enable automatic currency rate updates, you need a Fixer.io API key. The free tier allows 100 requests/month which is sufficient for daily updates.
Fear & Greed Index
Manage the Crypto Fear & Greed Index display at Admin Panel > Crypto Data > Fear & Greed Index.
Admin Panel → Crypto Data → Fear & Greed Index (/admin/fear-greed)
Fear & Greed Index management with historical data and configuration
What is Fear & Greed Index?
The Crypto Fear & Greed Index measures market sentiment on a scale of 0-100. It helps users understand whether the market is driven by fear (potential buying opportunity) or greed (potential sell signal).
Index Components
The index is calculated using multiple data sources:
| Component | Weight | Description |
|---|---|---|
| Volatility | 25% | Current volatility vs 30/90-day averages |
| Market Momentum | 25% | Volume and momentum vs 30/90-day averages |
| Social Media | 15% | Twitter hashtags, Reddit activity |
| Surveys | 15% | Crypto polling platform results |
| Bitcoin Dominance | 10% | BTC market share changes |
| Google Trends | 10% | Search interest for crypto terms |
Index Value Ranges
| Value Range | Classification | Color | Meaning |
|---|---|---|---|
| 0-24 | Extreme Fear | Red | Investors are very worried, potential buying opportunity |
| 25-44 | Fear | Orange | Market is fearful, sentiment is negative |
| 45-55 | Neutral | Yellow | Market is balanced, no clear direction |
| 56-75 | Greed | Light Green | Market is optimistic, prices rising |
| 76-100 | Extreme Greed | Green | Market is euphoric, potential correction ahead |
Display Settings
| Setting | Description | Default |
|---|---|---|
show_on_homepage |
Display index widget on homepage | Yes |
show_on_coin_pages |
Display on individual coin pages | Yes |
widget_style |
Gauge, meter, or simple display | Gauge |
show_historical |
Display historical chart | Yes |
history_days |
Days of history to display | 30 |
Data Source
The index is fetched from the Alternative.me Fear & Greed Index API. The data is updated twice daily via the feargreed:update cron command.
# Manual update command
php artisan feargreed:update
# Scheduled updates (in app/Console/Kernel.php)
$schedule->command('feargreed:update')->twiceDaily(1, 13);
Tiered Update Strategy
CoinTrail uses a tiered update strategy to optimize API usage:
- Top Coins (1-100): Updated every 5 minutes for real-time accuracy
- Mid-tier Coins (101-500): Updated every 30 minutes
- Remaining Coins (500+): Updated every 6 hours
// Example API settings configuration
'coingecko_plan' => 'demo',
'coingecko_api_key' => 'your-api-key', // Required for paid plans
'enable_tiered_updates' => true,
'top_coins_count' => 100,
'top_coins_interval' => 300, // 5 minutes
'remaining_coins_interval' => 21600, // 6 hours
Global Market Data
CoinTrail tracks global cryptocurrency market statistics displayed on the homepage:
Total Market Cap
Combined market capitalization of all cryptocurrencies worldwide.
24h Volume
Total trading volume across all markets in the last 24 hours.
BTC Dominance
Bitcoin's percentage share of total market capitalization.
ETH Dominance
Ethereum's percentage share of total market cap.
Global data is stored in the settings table:
// Global data keys
global.total_market_cap
global.total_volume
global.btc_dominance
global.eth_dominance
global.active_cryptocurrencies
global.markets
global.market_cap_change_24h
global.updated_at
Fear & Greed Index
CoinTrail displays the Crypto Fear & Greed Index, a market sentiment indicator:
| Value Range | Classification | Meaning |
|---|---|---|
| 0-24 | Extreme Fear | Investors are very worried, potential buying opportunity |
| 25-44 | Fear | Market is fearful, sentiment is negative |
| 45-55 | Neutral | Market is balanced, no clear direction |
| 56-75 | Greed | Market is optimistic, prices rising |
| 76-100 | Extreme Greed | Market is euphoric, potential correction ahead |
The index is updated twice daily via the feargreed:update command. Data is fetched from the Alternative.me Fear & Greed Index API.
Manual Data Updates
You can manually trigger data updates from the admin panel or via artisan commands:
| Action | Command | Description |
|---|---|---|
| Update Top 100 Prices | php artisan crypto:update-prices --tier=top --limit=100 |
Refresh prices for top 100 coins |
| Update All Prices | php artisan crypto:update-prices --tier=all |
Refresh all coin prices (uses API quota) |
| Sync Global Data | php artisan crypto:sync-global |
Update global market statistics |
| Update Exchanges | php artisan crypto:update-exchanges |
Refresh exchange list and volumes |
| Update Fear/Greed | php artisan feargreed:update |
Refresh Fear & Greed Index |
| Sync Coin Details | php artisan crypto:sync-details --coin=bitcoin |
Sync detailed info for a specific coin |
CoinGecko API Integration | Scheduled Data Updates | API Settings Configuration