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

• REX Oscillator
• Volume * Price Momentum Oscillator
• Average Growth Rate
• Trade-Ideas Intraday Screener
• High Low Chart - Drawing Item
• CBOE Options Issues Traded
• Dynamic Momentum Index
• How far are the close prices from the support line
• Hhv-llv
• Intra(Short-15mt)
• More trading objects...

Fundamental Analysis

• Short selling indicator
• US Stocks: Insiders & Institutions Ownership
• Equity Valuation
• Earnings: EPS Estimates
• US Consumer Sentiment
• Dow Jones U.S. Technology Sector Index Fund survivorship bias-free database downloader
• Cash ON Hand for US stocks
• Analyst comments
• Consumer Credit Historical Data
• NSE Indices - P/E, P/B & Div. Yield values
• More trading objects...