Advanced Quotes and Custom Databases Function

The current function retrieves data from the quotes or a custom database then performs a calculation on the different values that occurred within each analyzed bar.

Here is an example:

Imagine you are working with monthly data and you want to return the average close price (daily data) for each monthly bar. In this case, you can simply type the following instructions in your chart's formula:

a = GetDataAdv("eod", "close", "", "avg");
plot(a, "Avg Close");

Brief explanation of the different fields:

Field 1: Specify the database to use. Either you can use "eod" (EOD database), "intraday" (Intraday database), "tick" (Tick database) or you can type the name of the custom database.

Field 2: Specify the field. For a custom database, it is one of the fields that belong to that database. For built-in databases, you can use "close, open, high, low, volume or openint".

Field 3: The symbol name to analyze. Set an empty string to get data for the currently analyzed symbol.

Field 4: The calculation method:

count: The number of values that occurred within each bar
sum: The sum of the values
avg: The average of the values
first: The first value
last: The last value
max: The highest value
min: The lowest value

Technical Analysis

• Accumulation Distribution Indicator (AD)
• Close Price Above Cursor
• Simple pattern detection rules using close and open prices
• Is New Bar
• mov avrages
• 10-bar moving average return for S&P 500 stocks
• TFS Tether Line
• Coppock - VLT Momentum Indicator
• Fractal Adaptive Moving Average - FRAMA
• Avgerage Correlation
• More trading objects...

Fundamental Analysis

• Small Business Optimism Index
• Forex Trading Indicator - Better than expected Economic Calendar Events
• Recent Insider Buying and Selling for US Stocks
• Distress Index - Economic measure
• Economic Confidence Index
• Business Outlook Survey diffusion indexes
• Historical Stock Market News
• Dow Jones U.S. Technology Sector Index Fund survivorship bias-free database downloader
• Insiders' Blog stories
• Analyst Days Since Last Rating
• More trading objects...