Sum of a Custom Database's Field

The built-in "GetData" function allows you to retrieve data from a custom database (fundamental, news, sentiment, put/call ratio...). It gets data for the last field's value that occurred during each trading bar.

Imagine you have a volume field (daily data) and you want to display the volume's sum in a monthly chart.
Using the "GetData" function you can get only the last volume value that occurred at the end of the each month.

Example: (Assuming you have a custom database called "my_custom_database" and a field whose name is "volume"
a = GetData("my_custom_database", "volume", LastData);

In order to get the volume's sum for each month, you can use the current function to do so. Simply type:

a = GetDataSum("my_custom_database", "volume", "");

The last volume can be used to get data for an external symbol. If this field is empty then the current analyzed symbol is used.

Technical Analysis

• Bulls and Bears Strategy
• Chande TrendScore By Symbol
• Sentiment Measure Using ETF Sector Correlations
• Backtest different Segments in your Trading System
• TSP Sentiment Survey - Percentage of Bullish and Bearish Traders
• Double Bollinger Bands Trading System
• Trading the Equity Curve
• Stop Trading Based on Your Portfolio Equity Return
• Coppock - VLT Momentum Indicator
• Breakaway Gaps
• More trading objects...

Fundamental Analysis

• S&P 500 - Price to earnings ratio
• Earnings database
• Job Creation Index
• Historical Earnings Calendar for Major Stock Exchanges
• Small Business Optimism Index
• Real Gross Domestic Product - Historical data
• Unexpected Short Selling Bars
• SocialPicks Analysis
• Two Consecutive and Positive Earnings Surprises
• AAII Asset Allocation Survey: Stock Funds, Stocks, Bond Funds, Bonds and Cash
• More trading objects...