Katelynn's Report

Katelynn's Report

(US Market)

Help










Font Size:

API access

Access Guide Briefing

All users will be granted an API token (a 20 character string) on successful registration. The API token can be found in your account information page. All tiers from tier 0 to tier 5 have API access as indicated in Access Guide. The only difference between each tiers is the number of API queries you can make each day (i.e. all tiers have access to the same content as shown below).

All API queries should be started with

https://www.katelynnsreport.com/API?token={your_api_token}&access=xxxxx

For example, if your API token is "abcdefg1234567890123", the query should be like

https://www.katelynnsreport.com/API?token=abcdefg1234567890123&access=xxxxx

Remember that all API queries are case sensitive unless otherwise specified.
A query is not counted (i.e. do not consume your daily query quota) unless it returns at least one valid record to you.
Output by default is in CSV format. To output json format add format=json to the end of your query

https://www.katelynnsreport.com/API?token=abcdefg1234567890123&access=xxxxx&format=json

Overwhelmed by complex configurations?
Don't worry, contact us for free assistance on generating the query URL you want.



SEC Filing [access=secfiling]

Retrieve SEC filings of specific CIK or trading symbol or form types

E.g. Retrieve SEC filings of AAPL for the latest filing day

https://www.katelynnsreport.com/API?token={your_api_token}&access=secfiling&symbol=AAPL

Note: Symbol must be upcased.
For simplicity reason, we do not show the main path in the remaining examples.


E.g. Retrieve SEC filings of CIK 320193 for the latest filing day

access=secfiling&cik=320193

Note: When both cik and symbol appear, cik takes precedence.


E.g. Retrieve SEC filings of AAPL from 2019-01-01 to 2019-03-01

access=secfiling&symbol=AAPL&startdate=2019-01-01&enddate=2019-03-01

Note: When startdate or enddate is not specified, default is the latest filing day.
Your can query up to 10 years of SEC filings. Each query is limited to output up to 2000 records.


E.g. Retrieve SEC filings of AAPL with form equal to 10-Q, 10-Q/A, 10-K, 10-K/A from 2015-01-01 to 2019-12-31

access=secfiling&symbol=AAPL&form_list=10-Q,10-Q/A,10-K,10-K/A&startdate=2015-01-01&enddate=2019-03-01

See below a comprehensive list of forms. Use "+" sign to represent white space in form name when making API query

1
1-A
1-A POS
1-A-W
1-A-W/A
1-A/A
1-E
1-E AD
1-E/A
1-K
1-K/A
1-SA
1-SA/A
1-U
1-U/A
1-Z
1-Z-W
1-Z/A
1/A
10-12B
10-12B/A
10-12G
10-12G/A
10-D
10-D/A
10-K
10-K/A
10-KT
10-KT/A
10-M
10-Q
10-Q/A
10-QT
10-QT/A
10KSB
10KSB/A
10QSB/A
11-K
11-K/A
11-KT
13F-HR
13F-HR/A
13F-NT
13F-NT/A
13FCONP
144
144/A
15-12B
15-12B/A
15-12G
15-12G/A
15-15D
15-15D/A
15F-12B
15F-12B/A
15F-12G
15F-12G/A
15F-15D
15F-15D/A
18-K
18-K/A
19B-4
19B-4/A
19B-4E
2-E
20-F
20-F/A
20FR12B
20FR12B/A
20FR12G
20FR12G/A
24F-2NT
24F-2NT/A
25
25-NSE
25-NSE/A
25/A
253G1
253G2
253G3
253G4
3
3/A
305B2
305B2/A
34-12H
4
4/A
40-17F1
40-17F1/A
40-17F2
40-17F2/A
40-17G
40-17G/A
40-17GCS
40-202A
40-202A/A
40-206A
40-206A/A
40-24B2
40-24B2/A
40-33
40-33/A
40-6B
40-6B/A
40-8B25
40-8F-2
40-8F-2/A
40-APP
40-APP/A
40-F
40-F/A
40-OIP
40-OIP/A
40FR12B
40FR12B/A
40FR12G
40FR12G/A
424A
424B1
424B2
424B3
424B4
424B5
424B7
424B8
424H
424H/A
424I
425
485APOS
485BPOS
485BXT
486APOS
486BPOS
486BXT
487
497
497AD
497H2
497J
497K
497VPI
497VPSUB
497VPU
5
5/A
6-K
6-K/A
6B NTC
6B ORDR
7-M
8-A12B
8-A12B/A
8-A12G
8-A12G/A
8-K
8-K/A
8-K12B
8-K12B/A
8-K12G3
8-K12G3/A
8-K15D5
8-M
8F-2 NTC
8F-2 ORDR
9-M
ABS-15G
ABS-15G/A
ABS-EE
ABS-EE/A
ADV-H-C
ADV-H-T
ADV-NR
ANNLRPT
ANNLRPT/A
APP NTC
APP ORDR
APP WD
APP WD/A
APP WDG
ARS
ARS/A
ATS-N
ATS-N-C
ATS-N-W
ATS-N/CA
ATS-N/MA
ATS-N/OFA
ATS-N/UA
AW
AW WD
C
C-AR
C-AR-W
C-AR/A
C-TR
C-TR-W
C-U
C-U-W
C-W
C/A
C/A-W
CANCELLATION-MA
CB
CB/A
CERT
CERTARCA
CERTBATS
CERTCBO
CERTNAS
CERTNYS
CFPORTAL
CFPORTAL-W
CFPORTAL/A
CORRESP
CT ORDER
D
D/A
DEF 14A
DEF 14C
DEFA14A
DEFA14C
DEFC14A
DEFC14C
DEFM14A
DEFM14C
DEFN14A
DEFR14A
DEFR14C
DEL AM
DFAN14A
DFRN14A
DOS
DOS/A
DOSLTR
DRS
DRS/A
DRSLTR
DSTRBRPT
DSTRBRPT/A
EFFECT
F-1
F-1/A
F-10
F-10/A
F-10EF
F-10POS
F-1MEF
F-3
F-3/A
F-3ASR
F-3D
F-3DPOS
F-3MEF
F-4
F-4 POS
F-4/A
F-4EF
F-4MEF
F-6
F-6 POS
F-6/A
F-6EF
F-7
F-7 POS
F-7/A
F-8
F-8 POS
F-8/A
F-80
F-80/A
F-80POS
F-N
F-N/A
F-X
F-X/A
FOCUSN
FOCUSN/A
FWP
G-405
G-405N
G-FIN
G-FIN/A
G-FINW
IRANNOTICE
MA
MA-A
MA-I
MA-I/A
MA-W
MA/A
MSD
MSD/A
MSDCO
MSDW
N-14
N-14 8C
N-14 8C/A
N-14/A
N-14MEF
N-18F1
N-18F1/A
N-1A
N-1A/A
N-2
N-2 POSASR
N-2/A
N-23C-2
N-23C-2/A
N-23C3A
N-23C3A/A
N-23C3B
N-23C3C
N-23C3C/A
N-2ASR
N-2MEF
N-3
N-3/A
N-30B-2
N-30D
N-30D/A
N-4
N-4/A
N-54A
N-54A/A
N-54C
N-6
N-6/A
N-6F
N-6F/A
N-8A
N-8A/A
N-8B-2
N-8B-2/A
N-8B-4
N-8F
N-8F NTC
N-8F ORDR
N-8F/A
N-CEN
N-CEN/A
N-CR
N-CR/A
N-CSR
N-CSR/A
N-CSRS
N-CSRS/A
N-MFP
N-MFP/A
N-MFP1
N-MFP1/A
N-MFP2
N-MFP2/A
N-MFP3
N-MFP3/A
N-PX
N-PX/A
N-Q
N-Q/A
N-VP
N-VP/A
N-VPFS
N-VPFS/A
NO ACT
NPORT-EX
NPORT-EX/A
NPORT-P
NPORT-P/A
NRSRO-CE
NRSRO-CE/A
NRSRO-UPD
NSAR-A
NSAR-A/A
NSAR-AT
NSAR-B
NSAR-B/A
NSAR-BT
NSAR-U
NSAR-U/A
NT 10-D
NT 10-K
NT 10-K/A
NT 10-Q
NT 10-Q/A
NT 11-K
NT 11-K/A
NT 15D2
NT 20-F
NT 20-F/A
NT N-CEN
NT N-MFP
NT N-MFP1
NT N-MFP2
NT NPORT-EX
NT NPORT-P
NT-NCEN
NT-NCEN/A
NT-NCSR
NT-NCSR/A
NT-NSAR
NT-NSAR/A
NTFNCEN
NTFNCSR
NTFNSAR
NTN 10K
NTN 10Q
OIP NTC
OIP ORDR
POS 8C
POS AM
POS AMI
POS EX
POS462B
POS462C
POSASR
PRE 14A
PRE 14C
PREC14A
PREC14C
PREM14A
PREM14C
PREN14A
PRER14A
PRER14C
PRRN14A
PX14A6G
PX14A6N
QRTLYRPT
QRTLYRPT/A
QUALIF
REG-NR
REVOCATION-MA
REVOKED
RW
RW WD
S-1
S-1/A
S-11
S-11/A
S-11MEF
S-1MEF
S-3
S-3/A
S-3ASR
S-3D
S-3DPOS
S-3MEF
S-4
S-4 POS
S-4/A
S-4EF
S-4MEF
S-6
S-6/A
S-8
S-8 POS
S-B
S-B/A
S-BMEF
SB-2/A
SBSE
SBSE-A
SBSE-A/A
SBSE-BD
SBSE-BD/A
SBSE-C
SBSE-W
SBSE/A
SBSEF
SBSEF-W
SBSEF/A
SC 13D
SC 13D/A
SC 13E1/A
SC 13E3
SC 13E3/A
SC 13G
SC 13G/A
SC 14D9
SC 14D9/A
SC 14F1
SC 14F1/A
SC 14N
SC 14N/A
SC TO-C
SC TO-I
SC TO-I/A
SC TO-T
SC TO-T/A
SC13E4F
SC13E4F/A
SC14D1F
SC14D1F/A
SC14D9C
SC14D9F
SCHEDULE 13D
SCHEDULE 13D/A
SCHEDULE 13G
SCHEDULE 13G/A
SD
SD/A
SDR
SDR/A
SE
SEC ACTION
SEC STAFF ACTIO
SEC STAFF LETTE
SF-1
SF-1/A
SF-1MEF
SF-3
SF-3/A
SP 15D2
SPDSCL
STOP ORDER
SUPPL
T-3
T-3/A
T-6
TA-1
TA-1/A
TA-2
TA-2/A
TA-W
TACO
TH
UPLOAD
X-17A-5
X-17A-5/A

E.g. Add links to child documents filed in each filing

access=secfiling&symbol=AAPL&form_list=10-Q,10-Q/A,10-K,10-K/A&startdate=2015-01-01&enddate=2019-03-01&attachdoclink=1


E.g. Retrieve SEC filings for all filers with form equal to 4,4/A on the latest filing day

access=secfiling&allfiler=1&form_list=4,4/A


Input

Parameter Argument Example Requirement Precedence Instruction
cik central index key cik=320193 conditional 1st must be presented if [symbol] and [allfiler] are absent
symbol an upcase trading symbol symbol=AAPL conditional 2nd must be presented if [cik] and [allfiler] are absent
allfiler 1 allfiler=1 conditional 3rd must be presented if [symbol] and [cik] are absent
form_list a comma seperated string form_list=4,4/A,10-Q optional take arbitrary number of form type(s)
startdate a date startdate=2019-01-01 optional default to the latest filing date
enddate a date enddate=2019-10-01 optional default to the latest filing date
the maximum difference between startdate and enddate is 10 years
attachdoclink 1 attachdoclink=1 optional attach links to child documents in the output table

Output

Field Name Description Example/Range Parameter
symbol trading symbol AAPL Default
receivedate when the filing is released by the SEC 2020-01-03 Default
date when the filing is reported to the SEC 2020-01-03 Default
cik central index key 320193 Default
name full name of the reporter Apple Inc. Default
form type of form DEF 14A Default
link link to text file of the filing edgar/data/320193/0001193125-20-001452.txt Default
doclink link to child document www.sec.gov/Archives/edgar/data/320193/000032019319000010/Financial_Report.xlsx attachdoclink=1
description dscription of child document Financial_Report attachdoclink=1
To top menu

CIK Information [access=cikinfo]

Retrieve details of CIK like name, address, phone number

E.g. Retrieve details of CIK 320193

access=cikinfo&cik=320193


E.g. Retrieve details of CIKs with entity name starts with "Apple"

access=cikinfo&byname=1&startingchars=apple

Note: startingchars is case insensitive, and by default is set to "AA".


Input

Parameter Argument Example Requirement Precedence Instruction
cik central index key cik=320193 conditional 1st must be presented if [byname] is absent
byname 1 byname=1 conditional 2nd must be presented if [cik] is absent
startingchars an alphabetic string startingchars=ABC optional case insentitive and default is AA

Output

refer to CIK to company information mapping

To top menu

Symbol to CIK mapping [access=cikinfo]

E.g. Retrieve mapping between all trading symbols and CIKs

access=symcik

Output

refer to Symbol to CIK mapping

To top menu

Fusion hunter [access=hunter]

A comprehensive screener that allows for filtering of fundamental, technical, and statistical indicators to quickly narrow down your watch list for top trading opportunity.

E.g. Retrieve stocks with close price ≥$5 and ≤$100 in the last trading day, and closed 10% higher than previous trading day, and trading volume ≥ 10000

access=hunter&close_ge=5&close_le=100&change_d_ge=10&volume_ge=10000


E.g. similar to previous query but closed ≥10% and ≤50% than previous trading day

access=hunter&close_ge=5&close_le=100&change_d_ge=10&change_d_le=50&volume_ge=10000


E.g. Retrieve stocks with significant daily price variation (≥upper 95% CI) and close price ≥$8 in the last trading day, and closed 5% higher than previous trading day

access=hunter&prcvar_d_sig95=1&close_ge=8&change_d_ge=5


E.g. same as previous query, and also ouptut price variation related fields

access=hunter&prcvar_d_sig95=1&close_ge=8&change_d_ge=5&addprcvar_d=1


E.g. similar to previous query, but require price variation ≥upper 99% CI

access=hunter&prcvar_d_sig99=1&close_ge=8&change_d_ge=5&addprcvar_d=1


E.g. similar to previous query, also require PE ratio ≥5 and ≤50, and also output pe field

access=hunter&prcvar_d_sig99=1&close_ge=8&change_d_ge=5&addprcvar_d=1&pe_ge=5&pe_le=50&addfdm_list=pe


E.g. similar to previous query, also require market capital ≥30% of industry peers, and also output market capital, market capital industry quantile field

access=hunter&prcvar_d_sig99=1&close_ge=8&change_d_ge=5&addprcvar_d=1&pe_ge=5&pe_le=50&marketcap_idsqt_ge=0.3&addfdm_list=pe,marketcap,marketcap_idsqt


E.g. Retrieve stocks with close price crossed above 20-day SMA, and have close price ≥$10, and have volume ≥10000 in the last trading day

access=hunter&close_sma20d=1&close_ge=10&volume_ge=10000


E.g. similar to previous query, also output 20-day SMA

access=hunter&close_sma20d=1&close_ge=10&volume_ge=10000&addtech_list=sma_d_20


E.g. similar to previous query, also require significant(≥99% CI) daily price variation

access=hunter&close_sma20d=1&close_ge=10&volume_ge=10000&addtech_list=sma_d_20&prcvar_d_sig99=1


E.g. similar to previous query, also require 20-day boll's band span [(BB upper - BB lower)/20-day SMA * 100%] ≥ 10%, and add 20-day bbspan to output

access=hunter&close_sma20d=1&close_ge=10&volume_ge=10000&prcvar_d_sig99=1&bbspan_ge=10&addtech_list=bbspan,sma_d_20


E.g. similar to previous query, but relax BB span to ≥5%, and require RSI(relative strength index) of 20-day SMA ≥50 (i.e. upward trend), and add 20-day SMA RSI to output

access=hunter&close_sma20d=1&close_ge=10&volume_ge=10000&prcvar_d_sig99=1&bbspan_ge=5&addtech_list=bbspan,sma_d_20,smarsi_d_20&smarsi_d_20_ge=50


E.g. similar to previous query, but require close price cross below 20-day SMA, and 20-day SMA RSI ≤50 (i.e. downward tend)

access=hunter&close_sma20d=-1&close_ge=10&volume_ge=10000&prcvar_d_sig99=1&bbspan_ge=5&addtech_list=bbspan,sma_d_20,smarsi_d_20&smarsi_d_20_le=50


E.g. Retrieve stocks with close price within 2% above daily BB lower, and have significant price variation ≥95% CI, and add BB lower to the output

access=hunter&close_pctdif_bb_d_20_lower_ge=0&close_pctdif_bb_d_20_lower_le=2&prcvar_d_sig95=1&addpctdif_bb_d_20_lower=1&addtech_list=bb_d_20_lower


E.g. similar to previous query, and also limit close price to ≥$5, and volume to ≥10000, and BB span ≥10

access=hunter&close_pctdif_bb_d_20_lower_ge=0&close_pctdif_bb_d_20_lower_le=2&prcvar_d_sig95=1&addpctdif_bb_d_20_lower=1&addtech_list=bb_d_20_lower&close_ge=5&volume_ge=10000&bbspan_ge=10


E.g. Retrieve stocks that has 100% support on daily BB lower in the past 5 trading days, and have daily BB span ≥5

access=hunter&hlsptrst_psb_bb_d_20_lower_ge=100&hlsptrst_psb_dayspan=5&bbspan_ge=5


E.g. Retrieve stocks with ≥80% resistance on 20-day SMA In the past 5 trading days, and crossed above 20-day SMA in the last trading day, and have daily BB span ≥5, and include 20-day SMA in the output

access=hunter&hlsptrst_psb_sptrst=rst&hlsptrst_psb_sma_d_20_ge=80&hlsptrst_psb_dayspan=5&close_sma20d=1&bbspan_ge=5&addtech_list=sma_d_20


E.g. similar to previous query, but require 80% resistance on 20-day SMA in the past 8 trading days, and add support/resistance possibility to output

access=hunter&hlsptrst_psb_sptrst=rst&hlsptrst_psb_sma_d_20_ge=80&hlsptrst_psb_dayspan=8&close_sma20d=1&bbspan_ge=5&addtech_list=sma_d_20&addhlsptrst_psb_list=sma_d_20


E.g. Retrieve stocks with ≥ 80% resistance on 20-day SMA in the past 8 trading days, and crossed above 20-day SMA in the last trading day, and have BB span greater than 5%. Add 20-day SMA, bbspan, and percentage difference between close price and 20-day SMA to output

access=hunter&hlsptrst_psb_sptrst=rst&hlsptrst_psb_dayspan=8&hlsptrst_psb_sma_d_20_ge=80&close_sma20d=1&bbspan_ge=5&addtech_list=sma_d_20,bbspan&addpctdif_sma_d_20=1


E.g. similar to previous query, but require a more stringent definition of resistance (i.e high price must be within ≤1% region below specific line to be considered as resistance event)

access=hunter&hlsptrst_psb_sptrst=rst&hlsptrst_psb_dayspan=8&hlsptrst_psb_pctx10trhd=10&hlsptrst_psb_sma_d_20_ge=80&close_sma20d=1&bbspan_ge=5&addtech_list=sma_d_20,bbspan&addpctdif_sma_d_20=1


E.g. Retrieve stocks with ≥ 80% resistance (≤1.5% region) on daily pivot point in the past 5 trading days, and closed above daily pivot point in the last trading day, and have BB span greater than 5%. Add pivot point, bbspan, and percentage difference between close price and daily pivot point to output

access=hunter&hlsptrst_psb_sptrst=rst&hlsptrst_psb_dayspan=5&hlsptrst_psb_pctx10trhd=15&hlsptrst_psb_pivotpoint=80&close_pctdif_pivotpoint_ge=0&bbspan_ge=5&addtech_list=bbspan,pivotpoint&addpctdif_pivotpoint=1


E.g. Retrieve stocks closed 20% higher, and force include AAPL, IBM, NKE into hunting results

access=hunter&change_d_ge=20&force_list=AAPL,IBM,NKE


Tips: By setting close price (or any other parameters) to an unreasonable level, we can retrieve results only for a user defined list of symbols

access=hunter&close_le=0.0001&force_list=AAPL,IBM,NKE


Summarize hunting results

Query results from [access=hunter] can be further summarized by adding [getstat=1] to obtain the count and percentage of qualified stocks grouped by sector and industry. Note that when this option is enabled, the limit (max = 50 records) on the hunting results will be removed.

E.g. Summaize the stocks with close price ≥ 10% higher than previous trading day

access=hunter&change_d_ge=10&getstat=1


Overwhelmed by complex configurations?
Don't worry, contact us for free assistance on generating the query URL you want.


Input toggle

Parameter Argument Example Requirement Precedence Instruction
recdate a date recdate=2020-01-08 optional default to the latest trading day
scope a string scope=market optional ['market'(default),'sector','industry']
seccode sector codea seccode=SEC001 optional default is SEC001 (i.e. energy sector)
idscode industry codea idscode=IDS00010 optional default is IDS00010 (i.e. property/casualty/life/health/specialty insurers)
Technical metrics
force_list a comma separated string force_list=AAPL,IBM,NKE optional symbols appeared in the force_list will always appear in the hunting results
close[_ge/_le] a floating number close=20
close_ge=5
close_le=300
close_ge=5&close_le=300
optional [_ge] represents ≥
[_le] represents ≤
[>0]
change_d a floating number refer to close optional interday percentage change of close price
x52wk_high a floating number refer to close optional 52-week high
[>0]
x52wk_low a floating number refer to close optional 52-week low
[>0]
volume an integer refer to close optional daily trading volume
[>0]
volume_idsqt a floating number refer to close optional industry quntile of volume
[0~1]
volume_secqt a floating number refer to close optional sector quntile of volume
[0~1]
volume_allqt a floating number refer to close optional market quntile of volume
[0~1]
volume_average an integer refer to close optional 5-day average volume
[>0]
previous_open_w a floating number refer to close optional open price of previous week
[>0]
previous_high_w a floating number refer to close optional high price of previous week
[>0]
previous_low_w a floating number refer to close optional low price of previous week
[>0]
previous_close_w a floating number refer to close optional close price of previous week
[>0]
sma_d_5 a floating number refer to close optional 5-day SMA
[>0]
sma_d_10 a floating number refer to close optional 10-day SMA
[>0]
sma_d_20 a floating number refer to close optional 20-day SMA
[>0]
sma_d_50 a floating number refer to close optional 50-day SMA
[>0]
sma_w_5 a floating number refer to close optional 5-week SMA
[>0]
sma_w_10 a floating number refer to close optional 10-week SMA
[>0]
sma_w_20 a floating number refer to close optional 20-week SMA
[>0]
sma_w_50 a floating number refer to close optional 50-week SMA
[>0]
sd_d_20 a floating number refer to close optional 20-day SD
[>0]
sd_w_20 a floating number refer to close optional 20-week SD
[>0]
rsi_d_5* a floating number refer to close optional 5-day RSI
[0~100]
rsi_d_14* a floating number refer to close optional 14-day RSI
[0-100]
rsi_w_5* a floating number refer to close optional 5-week RSI
[0~100]
rsi_w_14* a floating number refer to close optional 14-week relative strength index
[0~100]
smarsi_d_10* a floating number refer to close optional RSI of 10-day SMA
[0~100]
smarsi_d_20* a floating number refer to close optional RSI of 20-day SMA
[0~100]
smarsi_w_10* a floating number refer to close optional RSI of 10-week SMA
[0~100]
smarsi_w_20* a floating number refer to close optional RSI of 20-week SMA
[0~100]
k_d_14_3_3 a floating number refer to close optional 14-day stochastic slow k
[0~100]
d_d_14_3_3 a floating number refer to close optional 14-day stochastic slow d
[0~100]
j_d_14_3_3* a floating number refer to close optional 14-day stochastic slow j
[-200~300]
kmd_d_14_3_3 a floating number refer to close optional 14-day k - d
[-100~100]
k_w_9_3_3 a floating number refer to close optional 9-week stochastic slow k
[0~100]
d_w_9_3_3 a floating number refer to close optional 9-week stochastic slow d
[0~100]
j_w_9_3_3* a floating number refer to close optional 9-week stochastic slow j
[-200~300]
kmd_w_9_3_3 a floating number refer to close optional 9-week k - d
[-100~100]
bbw_d_20_2* a floating number refer to close optional daily BB width (BBU - BBL)/20-day SMA
[>0]
bbspan a floating number refer to close optional bbspan = bbw_d_20_2 * 100, a shortcut for bbw_d_20_2
bbp_d_20_2 a floating number refer to close optional daily BB percentage (close - BBL)/(BBU - BBL) * 100%
bbc_d_s1* a floating number refer to close optional daily BB constrain
[>0]
bbw_w_20_2* a floating number refer to close optional weekly BB width (BBU - BBL)/20-week SMA
[>0]
bbspan_w a floating number refer to close optional bbspan_w = bbw_w_20_2 * 100, a shortcut for bbw_d_20_2
bbp_w_20_2 a floating number refer to close optional weekly BB percentage (close - BBL)/(BBU - BBL) * 100%
bbc_s1* a floating number refer to close optional weekly BB constrain
[>0]
cci_d_20 a floating number refer to close optional 20-day commodity channel index
[-700~700]
cci_w_20 a floating number refer to close optional 20-week commodity channel index
[-700~700]
hcd* a floating number refer to close optional (52-week high - close)/close
[≥0]
lcd* a floating number refer to close optional (52-week low - close)/close
[≤0]
Inter-day crossover & non-crossover approach
close_sma10d an integer refer to close optional close price crosses 10-day SMA
1/-1 for cross above/below, respectively
2/-2 for approaching 1% region from above/below, respectively
3/-3 for approaching 2% region from above/below, respectively
close_sma20d an integer refer to close optional refer to close_sma10d
close_sma50d an integer refer to close optional refer to close_sma10d
close_sma10w an integer refer to close optional refer to close_sma10d
close_sma20w an integer refer to close optional refer to close_sma10d
close_sma50w an integer refer to close optional refer to close_sma10d
close_bbld an integer refer to close optional close price crosses daily BB lower band
refer to close_sma10d
close_bbud an integer refer to close optional daily BB upper band
refer to close_sma10d
close_bblw an integer refer to close optional weekly BB lower band
refer to close_sma10d
close_bbuw an integer refer to close optional weekly BB upper band
refer to close_sma10d
sma10d_sma20d an integer refer to close optional 1/-1 for cross above/below, respectively
sma10d_sma50d an integer refer to close optional refer to sma10d_sma20d
sma20d_sma50d an integer refer to close optional refer to sma10d_sma20d
sma10w_sma20w an integer refer to close optional refer to sma10d_sma20d
sma10w_sma50w an integer refer to close optional refer to sma10d_sma20d
sma20w_sma50w an integer refer to close optional refer to sma10d_sma20d
sma20w_sma50w an integer refer to close optional refer to sma10d_sma20d
rsi14d_20 an integer refer to close optional 14-day RSI crosses 20
refer to sma10d_sma20d
rsi14d_50 an integer refer to close optional refer to sma10d_sma20d
rsi14d_80 an integer refer to close optional refer to sma10d_sma20d
rsi5d_20 an integer refer to close optional refer to sma10d_sma20d
rsi5d_50 an integer refer to close optional refer to sma10d_sma20d
rsi5d_80 an integer refer to close optional refer to sma10d_sma20d
rsi14w_20 an integer refer to close optional refer to sma10d_sma20d
rsi14w_50 an integer refer to close optional refer to sma10d_sma20d
rsi14w_80 an integer refer to close optional refer to sma10d_sma20d
rsi5w_20 an integer refer to close optional refer to sma10d_sma20d
rsi5w_50 an integer refer to close optional refer to sma10d_sma20d
rsi5w_80 an integer refer to close optional refer to sma10d_sma20d
smarsi20w_20 an integer refer to close optional refer to sma10d_sma20d
smarsi20w_50 an integer refer to close optional refer to sma10d_sma20d
smarsi20w_80 an integer refer to close optional refer to sma10d_sma20d
smarsi10w_20 an integer refer to close optional refer to sma10d_sma20d
smarsi10w_50 an integer refer to close optional refer to sma10d_sma20d
smarsi10w_80 an integer refer to close optional refer to sma10d_sma20d
smarsi20d_20 an integer refer to close optional refer to sma10d_sma20d
smarsi20d_50 an integer refer to close optional refer to sma10d_sma20d
smarsi20d_80 an integer refer to close optional refer to sma10d_sma20d
smarsi10d_20 an integer refer to close optional refer to sma10d_sma20d
smarsi10d_50 an integer refer to close optional refer to sma10d_sma20d
smarsi10d_80 an integer refer to close optional refer to sma10d_sma20d
k9w_20 an integer refer to close optional refer to sma10d_sma20d
k9w_80 an integer refer to close optional refer to sma10d_sma20d
k_d9w an integer refer to close optional refer to sma10d_sma20d
k14d_20 an integer refer to close optional refer to sma10d_sma20d
k14d_80 an integer refer to close optional refer to sma10d_sma20d
k_d14d an integer refer to close optional refer to sma10d_sma20d
cci20d_m100 an integer refer to close optional 20-day CCI crosses -100 line
refer to sma10d_sma20d
cci20d_p100 an integer refer to close optional 20-day CCI crosses +100 line
refer to sma10d_sma20d
cci20d_m200 an integer refer to close optional refer to sma10d_sma20d
cci20d_p200 an integer refer to close optional refer to sma10d_sma20d
cci20w_m100 an integer refer to close optional refer to sma10d_sma20d
cci20w_p100 an integer refer to close optional refer to sma10d_sma20d
cci20w_m200 an integer refer to close optional refer to sma10d_sma20d
cci20w_p200 an integer refer to close optional refer to sma10d_sma20d
Intra-day high/low cross
hlcross_sma_d_10 an integer refer to close optional 1/-1 for cross and closed above/below sma_d_10, respectively
0 for no cross
hlcross_sma_d_20 an integer refer to close optional refer to sma_d_10
hlcross_sma_d_50 an integer refer to close optional refer to sma_d_10
hlcross_bb_d_20_lower an integer refer to close optional refer to sma_d_10
hlcross_bb_d_20_upper an integer refer to close optional refer to sma_d_10
hlcross_sma_w_10 an integer refer to close optional refer to sma_d_10
hlcross_sma_w_20 an integer refer to close optional refer to sma_d_10
hlcross_sma_w_50 an integer refer to close optional refer to sma_d_10
hlcross_bb_w_20_lower an integer refer to close optional refer to sma_d_10
hlcross_bb_w_20_upper an integer refer to close optional refer to sma_d_10
hlcross_pivotpoint an integer refer to close optional refer to sma_d_10
hlcross_previous_high an integer refer to close optional refer to sma_d_10
hlcross_previous_low an integer refer to close optional refer to sma_d_10
hlcross_previous_close an integer refer to close optional refer to sma_d_10
hlcross_pivotpoint_w an integer refer to close optional refer to sma_d_10
hlcross_previous_high_w an integer refer to close optional refer to sma_d_10
hlcross_previous_low_w an integer refer to close optional refer to sma_d_10
hlcross_previous_close_w an integer refer to close optional refer to sma_d_10
hlcross_x52wk_high an integer refer to close optional refer to sma_d_10
hlcross_x52wk_low an integer refer to close optional refer to sma_d_10
Intra-day high/low support/resistance
hlsptrst_sma_d_10 a floating number refer to close optional a positive/negative floating number represents the percentage of daily low/high above/below corresponding line
e.g. hlsptrst_sma_d_10_le=5.5&hlsptrst_sma_d_10_ge=0 means daily low above sma_d_10 and no greater than sma_d_10*105.5%
hlsptrst_sma_d_20 a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_sma_d_50 a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_bb_d_20_lower a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_bb_d_20_upper a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_sma_w_10 a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_sma_w_20 a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_sma_w_50 a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_bb_w_20_lower a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_bb_w_20_upper a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_pivotpoint a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_previous_high a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_previous_low a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_previous_close a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_pivotpoint_w a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_previous_high_w a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_previous_low_w a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_previous_close_w a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_x52wk_high a floating number refer to close optional refer to hlsptrst_sma_d_10
hlsptrst_x52wk_low a floating number refer to close optional refer to hlsptrst_sma_d_10
Multi-day high/low support/resistance possibility
dayspan an integer dayspan=5 optional the number of trading days used to calculate spt/rst possibility
[5(default),6,7,8,9,10]
pctx10trhd an integer pctx10trhd=20 optional the percentage(x10) threshold used to define spt/rst
[10,15,20(default)]
sptrst a string sptrst=spt optional specify spt/rst for support/resistance, respectively
['spt'(default),'rst']
hlsptrst_psb_sma_d_10 an integer refer to close optional in the last [dayspan] trading days, the possibility of sma_d_10 functions as a support(or resistance) line
[0~100]
hlsptrst_psb_sma_d_20 an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_sma_d_50 an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_bb_d_20_lower an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_bb_d_20_upper an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_sma_w_10 an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_sma_w_20 an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_sma_w_50 an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_bb_w_20_lower an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_bb_w_20_upper an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_pivotpoint an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_previous_high an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_previous_low an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_previous_close an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_pivotpoint_w an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_previous_high_w an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_previous_low_w an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_previous_close_w an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_x52wk_high an integer refer to close optional refer to hlsptrst_psb_sma_d_10
hlsptrst_psb_x52wk_low an integer refer to close optional refer to hlsptrst_psb_sma_d_10
Percentage difference from close price
close_pctdif_p_close a floating number refer to close optional percentage difference of current close price to previous trading day
e.g.close_pctdif_p_close_ge=5.5 represents current close is ≥5.5% higher than close price of previous trading day
close_pctdif_p_open a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_p_high a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_p_low a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_previous_open_w a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_previous_close_w a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_previous_high_w a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_previous_low_w a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_x52wk_high a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_x52wk_low a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_sma_d_5 a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_sma_d_10 a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_sma_d_20 a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_sma_d_50 a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_sma_w_5 a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_sma_w_10 a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_sma_w_20 a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_sma_w_50 a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_bb_d_20_upper a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_bb_d_20_lower a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_bb_w_20_upper a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_bb_w_20_lower a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_pivotpoint a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_pivotpoint_w a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_predb a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_l90b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_l95b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_l99b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_u90b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_u95b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_u99b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_basic_predb a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_basic_l90b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_basic_l95b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_basic_l99b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_basic_u90b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_basic_u95b a floating number refer to close optional refer to close_pctdif_p_close
close_pctdif_fr_trend_basic_u99b a floating number refer to close optional refer to close_pctdif_p_close
Price variation
prcvar_d_sig95 1 prcvar_d_sig95=1 optional whether require daily price variation ≥ upper 95% CI
prcvar_d_sig99 1 prcvar_d_sig99=1 optional whether require daily price variation ≥ upper 99% CI
prcvar_w_sig95 1 prcvar_w_sig95=1 optional whether require weekly price variation ≥ upper 95% CI
prcvar_w_sig99 1 prcvar_w_sig99=1 optional whether require weekly price variation ≥ upper 99% CI
Fundamental
eps a floating number refer to close optional earnings per share
oeps a floating number refer to close optional operating income per share
bps a floating number refer to close optional book value per share
rps a floating number refer to close optional revenue per share
pe* a floating number refer to close optional price to earnings ratio
poe* a floating number refer to close optional price to operating income ratio
p2b* a floating number refer to close optional price to book value
peg* a floating number refer to close optional price to earnings growth
forward_pe* a floating number refer to close optional forward PE
cfops a floating number refer to close optional operating cash flow per share
pcfo* a floating number refer to close optional price to operating cash flow
fcfps a floating number refer to close optional free cash flow per share
pfcf* a floating number refer to close optional price to free cash flow
beta a floating number refer to close optional
debt_equity_ratio* a floating number refer to close optional
leverage_ratio* a floating number refer to close optional
interest_coverage* a floating number refer to close optional
quick_ratio* a floating number refer to close optional
current_ratio* a floating number refer to close optional
gross_margin* a floating number refer to close optional in percentage
operating_margin* a floating number refer to close optional in percentage
net_profit_margin* a floating number refer to close optional in percentage
income_growth* a floating number refer to close optional in percentage
sales_growth* a floating number refer to close optional in percentage
return_on_assets* a floating number refer to close optional in percentage
return_on_equity* a floating number refer to close optional in percentage
return_on_capital* a floating number refer to close optional in percentage
dividend_rate a floating number refer to close optional in percentage
payout_ratio* a floating number refer to close optional in percentage
institutional_ownership* a floating number refer to close optional ratio
yield* a floating number refer to close optional in percentage
assets* a floating number refer to close optional in $1000
revenue* a floating number refer to close optional in $1000
netincome* a floating number refer to close optional in $1000
equity* a floating number refer to close optional in $1000
marketcap* a floating number refer to close optional in $1000
shares_outstanding a floating number refer to close optional in Million
one_year_target a floating number refer to close optional in USD

* Has industry, sector, and market quantile values available, refer to volume for format of parameter and argument

a check sector/industry code mapping
b check Quantitative Chart for definition of fr_trend, fr_trend_basic

Output toggle

Field Name Description Example/Range Parameter
symbol trading symbol AAPL Default
name full name of security issuer Apple Inc. Default
sector technology Default
industry computer manufacturing Default
recdate the record date 2020-01-03 Default
Technical metrics
open open price of record date 297.15 Default
high daily high of record date 300.58 Default
low daily low of record date 296.50 Default
close close price of record date 297.43 Default
volume volume of record date 34113137 Default*
change_d percentage change of close price relative to previous trading day -0.972 Default
x52wk_high 52-week high 300.6 [addtech=1] [addtech_list=x52wk_high]
x52wk_low 52-week low 142 [addtech=1] [addtech_list=x52wk_low]
previous_open_w open price of previous week 280.53 [addtech=1] [addtech_list=previous_open_w]
previous_close_w close price of previous week 289.8 [addtech=1] [addtech_list=previous_close_w]
previous_high_w high price of previous week 293.97 [addtech=1] [addtech_list=previous_high_w]
previous_low_w low price of previous week 280.37 [addtech=1] [addtech_list=previous_low_w]
sma_d_5 5-day SMA 294.55 [addtech=1] [addtech_list=sma_d_5]
sma_d_10 10-day SMA 289.04 [addtech=1] [addtech_list=sma_d_10]
sma_d_20 20-day SMA 280.97 [addtech=1] [addtech_list=sma_d_20]
sma_d_50 50-day SMA 267.46 [addtech=1] [addtech_list=sma_d_50]
sma_w_5 5-week SMA 282.51 [addtech=1] [addtech_list=sma_w_5]
sma_w_10 10-week SMA 272.33 [addtech=1] [addtech_list=sma_w_10]
sma_w_20 20-week SMA 247.47 [addtech=1] [addtech_list=sma_w_20]
sma_w_50 50-week SMA 213.35 [addtech=1] [addtech_list=sma_w_50]
sd_d_20 20-day close price standard deviation 10.07 [addtech=1] [addtech_list=sd_d_20]
sd_w_20 20-week close price standard deviation 27.98 [addtech=1] [addtech_list=sd_w_20]
bb_d_20_lower 20-day BB lower boundary 260.84 [addtech=1] [addtech_list=bb_d_20_lower]
bb_d_20_upper 20-day BB upper boundary 301.11 [addtech=1] [addtech_list=bb_d_20_upper]
bb_w_20_lower 20-week BB lower boundary 191.52 [addtech=1] [addtech_list=bb_w_20_lower]
bb_w_20_upper 20-week BB upper boundary 303.43 [addtech=1] [addtech_list=bb_w_20_upper]
pivotpoint daily pivotpoint [addtech=1] [addtech_list=pivotpoint]
pivotpoint_w weekly pivotpoint [addtech=1] [addtech_list=pivotpoint_w]
rsi_d_5 5-day RSI 0~100 [addtech=1] [addtech_list=rsi_d_5]
rsi_d_5_idsqt industry quantile of 5-day RSI 0~1 [addtechidsqt=1] [addtech_list=rsi_d_5_idsqt]
rsi_d_5_secqt sector quantile of 5-day RSI 0~1 [addtechsecqt=1] [addtech_list=rsi_d_5_secqt]
rsi_d_5_allqt market quantile of 5-day RSI 0~1 [addtechallqt=1] [addtech_list=rsi_d_5_allqt]
rsi_d_14 14-day RSI 0~100 [addtech=1] [addtech_list=rsi_d_14]*
rsi_w_5 5-week RSI 0~100 [addtech=1] [addtech_list=rsi_w_5]*
rsi_w_14 14-week RSI 0~100 [addtech=1] [addtech_list=rsi_w_14]*
smarsi_d_10 RSI of 10-day SMA 0~100 [addtech=1] [addtech_list=smarsi_d_10]*
smarsi_d_20 RSI of 20-day SMA 0~100 [addtech=1] [addtech_list=smarsi_d_20]*
smarsi_w_10 RSI of 10-week SMA 0~100 [addtech=1] [addtech_list=smarsi_w_10]*
smarsi_w_20 RSI of 20-week SMA 0~200 [addtech=1] [addtech_list=smarsi_w_20]*
k_d_14_3_3 14-day stochastic slow k 0~100 [addtech=1] [addtech_list=k_d_14_3_3]
d_d_14_3_3 14-day stochastic slow d 0~100 [addtech=1] [addtech_list=d_d_14_3_3]
j_d_14_3_3 14-day stochastic slow j 98 [addtech=1] [addtech_list=j_d_14_3_3]*
kmd_d_14_3_3 k - d 0~100 [addtech=1] [addtech_list=kmd_d_14_3_3]
k_w_9_3_3 9-week stochastic slow k 0~100 [addtech=1] [addtech_list=k_w_9_3_3]
d_w_9_3_3 9-week stochastic slow d 0~100 [addtech=1] [addtech_list=d_w_9_3_3]
j_w_9_3_3 9-week stochastic slow j 98 [addtech=1] [addtech_list=j_w_9_3_3]*
kmd_w_9_3_3 k - d 0~100 [addtech=1] [addtech_list=kmd_w_9_3_3]
bbw_d_20_2 daily BB width (BBU - BBL)/20-day SMA 0.143 [addtech=1] [addtech_list=bbw_d_20_2]*
bbspan bbw_d_20_2 * 100, a shortcut for bbw_d_20_2 14.3 [addtech=1] [addtech_list=bbspan]
bbp_d_20_2 daily BB percentage (close - BBL)/(BBU - BBL) * 100% 90.87 [addtech=1] [addtech_list=bbp_d_20_2]
bbc_d_s1 daily BB constrain >0 [addtech=1] [addtech_list=bbc_d_s1]
bbw_w_20_2 weekly BB width (BBU - BBL)/20-week SMA 0.45 [addtech=1] [addtech_list=bbw_w_20_2]*
bbspan_w bbw_w_20_2 * 100, a shortcut for bbw_w_20_2 45 [addtech=1] [addtech_list=bbspan_w]
bbp_w_20_2 weekly BB percentage (close - BBL)/(BBU - BBL) * 100% 90.87 [addtech=1] [addtech_list=bbp_w_20_2]
bbc_s1 weekly BB constrain >0 [addtech=1] [addtech_list=bbc_s1]
cci_d_20 20-day CCI 145.75 [addtech=1] [addtech_list=cci_d_20]
cci_w_20 20-week CCI 133.31 [addtech=1] [addtech_list=cci_w_20]
hcd (52-week high - close)/close 0.01 [addtech=1] [addtech_list=hcd]*
lcd (52-week low - close)/close 0.01 [addtech=1] [addtech_list=lcd]*
bbc_d_s1 daily BB constrain 0.964 [addtech=1] [addtech_list=bbc_d_s1]*
Inter-day crossover & non-crossover approach
close_sma10d 1/-1 for cross above/below
2/-2 for approaching 1% region from above/below
3/-3 for approaching 2% region from above/below, respectively
[addtradingsignal=1] [addtradingsignal_list=]
close_sma20d refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_sma20d]
close_sma50d refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_sma50d]
close_sma10w refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_sma10w]
close_sma20w refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_sma20w]
close_sma50w refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_sma50w]
close_bbld refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_bbld]
close_bbud refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_bbud]
close_bblw refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_bblw]
close_bbuw refer to close_sma10d [addtradingsignal=1] [addtradingsignal_list=close_bbuw]
sma10d_sma20d 1/-1 for cross above/below, respectively [addtradingsignal=1] [addtradingsignal_list=sma10d_sma20d]
sma10d_sma50d refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=sma10d_sma50d]
sma20d_sma50d refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=sma20d_sma50d]
sma10w_sma20w refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=sma10w_sma20w]
sma10w_sma50w refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=sma10w_sma50w]
sma20w_sma50w refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=sma20w_sma50w]
rsi14d_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi14d_20]
rsi14d_50 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi14d_50]
rsi14d_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi14d_80]
rsi5d_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi5d_20]
rsi5d_50 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi5d_50]
rsi5d_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi5d_80]
rsi14w_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi14w_20]
rsi14w_50 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi14w_50]
rsi14w_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi14w_80]
rsi5w_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi5w_20]
rsi5w_50 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi5w_50]
rsi5w_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=rsi5w_80]
smarsi20w_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi20w_20]
smarsi20w_50 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi20w_50]
smarsi20w_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi20w_80]
smarsi10w_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi10w_20]
smarsi10w_50 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi10w_50]
smarsi10w_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi10w_80]
smarsi20d_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi20d_20]
smarsi20d_50 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi20d_50]
smarsi20d_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi20d_80]
smarsi10d_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi10d_20]
smarsi10d_50 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi10d_50]
smarsi10d_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=smarsi10d_80]
k9w_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=k9w_20]
k9w_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=k9w_80]
k_d9w refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=k_d9w]
k14d_20 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=k14d_20]
k14d_80 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=k14d_80]
k_d14d refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=k_d14d]
cci20d_m100 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=cci20d_m100]
cci20d_p100 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=cci20d_p100]
cci20d_m200 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=cci20d_m200]
cci20d_p200 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=cci20d_p200]
cci20w_m100 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=cci20w_m100]
cci20w_p100 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=cci20w_p100]
cci20w_m200 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=cci20w_m200]
cci20w_p200 refer to sma10d_sma20d [addtradingsignal=1] [addtradingsignal_list=cci20w_p200]
Intra-day high/low cross
sma_d_10 1/-1 for cross and closed above/below sma_d_10, respectively
0 for no cross
[addhlcross=1] [addhlcross_list=sma_d_10]
sma_d_20 refer to sma_d_10 [addhlcross=1] [addhlcross_list=sma_d_20]
sma_d_50 refer to sma_d_10 [addhlcross=1] [addhlcross_list=sma_d_50]
bb_d_20_lower refer to sma_d_10 [addhlcross=1] [addhlcross_list=bb_d_20_lower]
bb_d_20_upper refer to sma_d_10 [addhlcross=1] [addhlcross_list=bb_d_20_upper]
sma_w_10 refer to sma_d_10 [addhlcross=1] [addhlcross_list=sma_w_10]
sma_w_20 refer to sma_d_10 [addhlcross=1] [addhlcross_list=sma_w_20]
sma_w_50 refer to sma_d_10 [addhlcross=1] [addhlcross_list=sma_w_50]
bb_w_20_lower refer to sma_d_10 [addhlcross=1] [addhlcross_list=bb_w_20_lower]
bb_w_20_upper refer to sma_d_10 [addhlcross=1] [addhlcross_list=bb_w_20_upper]
pivotpoint refer to sma_d_10 [addhlcross=1] [addhlcross_list=pivotpoint]
previous_high refer to sma_d_10 [addhlcross=1] [addhlcross_list=previous_high]
previous_low refer to sma_d_10 [addhlcross=1] [addhlcross_list=previous_low]
previous_close refer to sma_d_10 [addhlcross=1] [addhlcross_list=previous_close]
pivotpoint_w refer to sma_d_10 [addhlcross=1] [addhlcross_list=pivotpoint_w]
previous_high_w refer to sma_d_10 [addhlcross=1] [addhlcross_list=previous_high_w]
previous_low_w refer to sma_d_10 [addhlcross=1] [addhlcross_list=previous_low_w]
previous_close_w refer to sma_d_10 [addhlcross=1] [addhlcross_list=previous_close_w]
x52wk_high refer to sma_d_10 [addhlcross=1] [addhlcross_list=x52wk_high]
x52wk_low refer to sma_d_10 [addhlcross=1] [addhlcross_list=x52wk_low]
Intra-day high/low support/resistance
sma_d_10 a positive/negative floating number represents the percentage of daily low/high above/below corresponding line 5.5 (i.e. daily low is 5.5% above sma_d_10) [addhlsptrst=1] [addhlsptrst_list=sma_d_10]
sma_d_20 refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=sma_d_20]
sma_d_50 refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=sma_d_50]
bb_d_20_lower refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=bb_d_20_lower]
bb_d_20_upper refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=bb_d_20_upper]
sma_w_10 refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=sma_w_10]
sma_w_20 refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=sma_w_20]
sma_w_50 refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=sma_w_50]
bb_w_20_lower refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=bb_w_20_lower]
bb_w_20_upper refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=bb_w_20_upper]
pivotpoint refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=pivotpoint]
previous_close refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=previous_close]
previous_high refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=previous_high]
pivotpoint_w refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=pivotpoint_w]
previous_close_w refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=previous_close_w]
previous_low_w refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=previous_low_w]
previous_high_w refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=previous_high_w]
x52wk_high refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=x52wk_high]
x52wk_low refer to sma_d_10 [addhlsptrst=1] [addhlsptrst_list=x52wk_low]
Multi-day high/low support/resistance possibility
dayspan the number of trading days used to calculate spt/rst possibility 5~10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=dayspan]
pctx10trhd the percentage(x10) threshold used to define spt/rst 20 (i.e 2%) [addhlsptrst_psb=1] [addhlsptrst_psb_list=pctx10trhd]
sptrst the row is for support or resistance possibility either 'spt' or 'rst' [addhlsptrst_psb=1] [addhlsptrst_psb_list=sptrst]
sma_d_10 in the last [dayspan] trading days, the possibility of sma_d_10 functions as a support(or resistance) line [0-100] [addhlsptrst_psb=1] [addhlsptrst_psb_list=sma_d_10]
sma_d_20 refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=sma_d_20]
sma_d_50 refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=sma_d_50]
bb_d_20_lower refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=bb_d_20_lower]
bb_d_20_upper refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=bb_d_20_upper]
sma_w_10 refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=sma_w_10]
sma_w_20 refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=sma_w_20]
sma_w_50 refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=sma_w_50]
bb_w_20_lower refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=bb_w_20_lower]
bb_w_20_upper refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=bb_w_20_upper]
pivotpoint refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=pivotpoint]
previous_close refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=previous_close]
previous_high refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=previous_high]
pivotpoint_w refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=pivotpoint_w]
previous_close_w refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=previous_close_w]
previous_low_w refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=previous_low_w]
previous_high_w refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=previous_high_w]
x52wk_high refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=x52wk_high]
x52wk_low refer to sma_d_10 [addhlsptrst_psb=1] [addhlsptrst_psb_list=x52wk_low]
Percentage difference from close price
close_pctdif_x52wk_high in percentage addpctdif_x52wk_high=1
close_pctdif_x52wk_low in percentage addpctdif_x52wk_low=1
close_pctdif_p_open open price of previous trading day
in percentage
addpctdif_p_open=1
close_pctdif_p_close close price of previous trading day
in percentage
addpctdif_p_close=1
close_pctdif_p_high high price of previous trading day
in percentage
addpctdif_p_high=1
close_pctdif_p_low low price of previous trading day
in percentage
addpctdif_p_low=1
close_pctdif_previous_open_w open price of previous week
in percentage
addpctdif_previous_open_w=1
close_pctdif_previous_close_w low price of previous week
in percentage
addpctdif_previous_close_w=1
close_pctdif_previous_high_w high price of previous week
in percentage
addpctdif_previous_high_w=1
close_pctdif_previous_low_w low price of previous week
in percentage
addpctdif_previous_low_w=1
close_pctdif_sma_d_5 in percentage addpctdif_sma_d_5=1
close_pctdif_sma_d_10 in percentage addpctdif_sma_d_10=1
close_pctdif_sma_d_20 in percentage addpctdif_sma_d_20=1
close_pctdif_sma_d_50 in percentage addpctdif_sma_d_50=1
close_pctdif_sma_w_5 in percentage addpctdif_sma_w_5=1
close_pctdif_sma_w_10 in percentage addpctdif_sma_w_10=1
close_pctdif_sma_w_20 in percentage addpctdif_sma_w_20=1
close_pctdif_sma_w_50 in percentage addpctdif_sma_w_50=1
close_pctdif_bb_d_20_upper in percentage addpctdif_bb_d_20_upper=1
close_pctdif_bb_d_20_lower in percentage addpctdif_bb_d_20_lower=1
close_pctdif_bb_w_20_upper in percentage addpctdif_bb_w_20_upper=1
close_pctdif_bb_w_20_lower in percentage addpctdif_bb_w_20_lower=1
close_pctdif_pivotpoint in percentage addpctdif_pivotpoint=1
close_pctdif_pivotpoint_w in percentage addpctdif_pivotpoint_w=1
Price variation
prcvar_d price variation of corresponding trading day addprcvar_d=1
prcvar_d_mean 10-day average price variation addprcvar_d=1
prcvar_d_sig95 upper 95% CI of 10-day price variation addprcvar_d=1
prcvar_d_sig99 upper 99% CI of 10-day price variation addprcvar_d=1
prcvar_w price variation of previous week addprcvar_w=1
prcvar_w_mean 10-week average price variation addprcvar_w=1
prcvar_w_sig95 upper 95% CI of 10-week price variation addprcvar_w=1
prcvar_w_sig99 upper 99% CI of 10-week price variation addprcvar_w=1
Fundamental
eps earnings per share 12.44 [addfdm=1] [addfdm_list=eps]
oeps operating income per share 14.39 [addfdm=1] [addfdm_list=oeps]
bps book value per share 20.37 [addfdm=1] [addfdm_list=bps]
rps revenue per share 58.55 [addfdm=1] [addfdm_list=rps]
pe price to earnings ratio 23.92 [addfdm=1] [addfdm_list=pe]*
poe price to operating income ratio 20.67 [addfdm=1] [addfdm_list=poe]*
p2b price to book value 14.60 [addfdm=1] [addfdm_list=p2b]*
peg price to earnings growth 1.91 [addfdm=1] [addfdm_list=peg]*
forward_pe forward PE 22.52 [addfdm=1] [addfdm_list=forward_pe]*
cfops operating cash flow per share 15.62 [addfdm=1] [addfdm_list=cfops]
pcfo price to operating cash flow 19.05 [addfdm=1] [addfdm_list=pcfo]*
fcfps free cash flow per share [addfdm=1] [addfdm_list=fcfps]
pfcf price to free cash flow [addfdm=1] [addfdm_list=pfcf]*
beta [addfdm=1] [addfdm_list=beta]
debt_equity_ratio 2.74 [addfdm=1] [addfdm_list=debt_equity_ratio]*
leverage_ratio 3.72 [addfdm=1] [addfdm_list=leverage_ratio]*
interest_coverage 19.38 [addfdm=1] [addfdm_list=interest_coverage]*
quick_ratio 1.50 [addfdm=1] [addfdm_list=quick_ratio]*
current_ratio 1.54 [addfdm=1] [addfdm_list=current_ratio]*
gross_margin in percentage 37.82 [addfdm=1] [addfdm_list=gross_margin]*
operating_margin in percentage 24.57 [addfdm=1] [addfdm_list=operating_margin]*
net_profit_margin in percentage 21.24 [addfdm=1] [addfdm_list=net_profit_margin]*
income_growth in percentage -3.11 [addfdm=1] [addfdm_list=income_growth]*
sales_growth in percentage 1.81 [addfdm=1] [addfdm_list=sales_growth]*
return_on_assets in percentage 16.32 [addfdm=1] [addfdm_list=return_on_assets]*
return_on_equity in percentage 61.06 [addfdm=1] [addfdm_list=return_on_equity]*
return_on_capital in percentage 15.49 [addfdm=1] [addfdm_list=return_on_capital]*
dividend_rate in percentage 3.02 [addfdm=1] [addfdm_list=dividend_rate]
payout_ratio in percentage 24.28 [addfdm=1] [addfdm_list=payout_ratio]*
institutional_ownership ratio 0.63 [addfdm=1] [addfdm_list=institutional_ownership]*
yield in percentage 1.02 [addfdm=1] [addfdm_list=yield]*
assets in $1000 338516000 [addfdm=1] [addfdm_list=assets]*
revenue in $1000 260174000 [addfdm=1] [addfdm_list=revenue]*
netincome in $1000 55256000 [addfdm=1] [addfdm_list=netincome]*
equity in $1000 90488000 [addfdm=1] [addfdm_list=equity]*
marketcap in $1000 1321560308.950 [addfdm=1] [addfdm_list=marketcap]*
shares_outstanding in Million 4443.265 [addfdm=1] [addfdm_list=shares_outstanding]
one_year_target in USD 279.62 [addfdm=1] [addfdm_list=one_year_target]
Annotation
ipoyear [addanno=1] [addanno_list=ipoyear]
exchange [addanno=1] [addanno_list=exchange]
idscode [addanno=1] [addanno_list=idscode
seccode [addanno=1] [addanno_list=seccode]

* Has industry, sector, and market quantile values available for configuration. Refer to rsi_d_5 for format of parameter and argument.
Note: to include multiple arguments (e.g ipoyear and exchange), use comma seperated string like "addanno_list=ipoyear,exchange"

To top menu

Insider Trading [access=insidertrading]

Retrieve insider tradings history of specific security issuer by querying CIK or trading symbol. Retrieve insider filings of specific entity by repeorter CIK, for specific date range

E.g. Retrieve insider tradings filed on the last trading day by security issuer with CIK 320193

access=insidertrading&icik=320193


E.g. similar to previous query, and limit to insider filings between 2019-01-01 and 2019-01-30

access=insidertrading&icik=320193&startdate=2019-01-01&enddate=2019-01-30

Note: startdate and enddate by default are the last trading day


E.g. Retrieve filings of symbol AAPL between 2019-01-01 and 2019-01-30

access=insidertrading&symbol=AAPL&startdate=2019-01-01&enddate=2019-01-30


E.g. Retrieve all insider tradings between 2019-01-01 and 2019-01-30

access=insidertrading&allfiler=1&startdate=2019-01-01&enddate=2019-01-30

Note: output up to 2000 records


E.g. similar to pervious query, and limit to transactions with code P and S (i.e. open market purchase and sell)

access=insidertrading&allfiler=1&startdate=2019-01-01&enddate=2019-01-30&code_list=P,S

Overwhelmed by complex configurations?
Don't worry, contact us for free assistance on generating the query URL you want.

Input

Parameter Argument Example Requirement Precedence Instruction
icik issuer central index key icik=320193 conditional 1st must be presented if [symbol] [rcik] [allfiler] are absent
symbol an upcase trading symbol symbol=AAPL conditional 2nd must be presented if [icik] [rcik] [allfiler] are absent
rcik reporter central index key rcik=1565801 conditional 3rd must be presented if [icik] [symbol] [allfiler] are absent
allfiler 1 allfiler=1 conditional 4th must be presented if [symbol] [rcik] [icik] are absent
code_list a comma seperated string code_list=A,S,P optional the transaction code typea
form_list a comma seperated string form_list=4,4/A,5,5/A optional form type
possible options are [4,4/A,3,3/A,5,5/A]
startdate a date startdate=2019-01-01 optional default to the latest filing date
enddate a date enddate=2019-01-10 optional default to the latest filing date
the maximum difference between startdate and enddate is 3 years

a See form 4 for comprehensive list of valid transaction code

Output

Field Name Description Example/Range Parameter
fdate filing date 2019-11-07 Default
derive whether a derivative security 'n' for non-derivative
'y' for derivative
Default
formtype type of filing 4,4/A,3,3/A,5,5/A Default
reporter name of reporter LEVINSON ARTHUR D Default
rcik reporter CIK 1214128 Default
relation relationship with the security issuer Director Default
trandate date when transaction was conducted 2019-11-05 Default
origsubdate if an amendment filing, the date of original submission 2019-10-10 Default
sectype security type common stock Default
acname account name 'Direct' for direct account of the reporter
other string for indirect account
Default
operation acquisition or disposition acq,dsp Default
symbol trading symbol AAPL Default
icik issuer CIK 320193 Default
companyname name of security issuer Apple Inc. Default
code transaction code S Default
oprdatesta operation start date
useful for multiple operations conducted in different date
2019-11-15 Default
oprdateend operation end date
2019-11-15 Default
exsdate execution date of derivative security 2019-11-15 Default
amount overall transashares of all 37394 Default
cost average per share cost 257.79 Default
remain remaining shares 1133283 Default
metainfo '//' delimited transaction records 2|2019-10-15|F|11508|235.32|46311//3|2019-10-16|S|12459|234.04|33852 Default
shares_outstanding in million 4519.18 Default
doclink link to original filing www.sec.gov/Archives/edgar/data/320193/000032019319000121/xslF345X03/wf-form4_157316940649990.xml Default
To top menu

Sector Code Mapping [access=seccode]

Retrieve mapping between sector code and sector name

access=seccode



Industry Code Mapping [access=idscode]

Retrieve mapping between industry code and industry name

access=idscode

To top menu

Insider Holding [access=insiderholding]

Retrieve the latest insider holding details for specific company by trading symbol or CIK.

E.g. Retrieve insider holding information for AAPL

access=insiderholding&symbol=AAPL


E.g. Retrieve insider holding information for CIK 320193

access=insiderholding&icik=320193


Input

Parameter Argument Example Requirement Precedence Instruction
icik issuer CIK icik=320193 conditional 1st must be presented if [symbol] is absent
symbol an upcase trading symbol symbol=AAPL conditional 2nd must be presented if [icik] is absent

Output

Field Name Description Example/Range Parameter
symbol trading symbol AAPL Default
cik the CIK associated with the trading symbol 320193 Default
recdate the date the mapping was first recorded Default
fdate the latest filing date of the reporter 2020-01-02 Default
icik the issuer CIK 320193 Default
issuername name of issuer APPLE INC. Default
rcik reporter CIK 1214156 Default
reporter name of reporter COOK TIMOTHY D Default
relation relation of reporter with issuer CEO Default
sharesnew the latest holding shares 847969 Default
fdateold the previous filing date before the latest filing date 2019-08-27 Default
sharesold the holding shares reported on fdateold 854849 Default
To top menu

Top Insider Trading [access=topinsidertrading]

Retrieve stocks with top insider acquisition or disposition under specific transaction code*

* For acquisitions, code P (open market purchase), L (small acquisition), and I (at discretion of broker) are counted. For dispositions, code S (open market sell), D (sell back to issuer) and I (at discretion of broker) are counted. Other codes like code F (tax payment by security), G (gift) are less important in decision making and not considered.

E.g. Retrieve stocks with top acquisition transaction count in the past 3 months

access=topinsidertrading&monthback=3&orderby=count


E.g. Retrieve stocks with top acquisition shares amount in the past 6 months

access=topinsidertrading&monthback=6&orderby=amount


E.g. Retrieve stocks with top disposition shares percentage relative to outstanding shares in the past 3 months in energy sector*

access=topinsidertrading&operation=dsp&scope=sector&seccode=SEC001&monthback=3&orderby=pctso

* check sector/industry code mapping


Overwhelmed by complex configurations?
Don't worry, contact us for free assistance on generating the query URL you want.

Input

Parameter Argument Example Requirement Precedence Instruction
operation a 3-character string operaiton=acq optional acq for acquisition
dsp for disposition
['acq'(default),'dsp']
monthback an integer monthback=3 optional summarize trading statistics for the last n months
[3(default),6]
orderby a string orderby=count optional how the results be ordered(descendingly)
['count'(default),'amount','pctso']
scope a string scope=market optional ['market'(default),'sector','industry']
limit an integer limit=20 optional limit the number of records to output
[0~50]
seccode sector codea seccode=SEC001 optional default is SEC001 (i.e. energy sector)
idscode industry codea idscode=IDS00010 optional default is IDS00010 (i.e. property/casualty/life/health/specialty insurers)

a check sector/industry code mapping

Output

Field Name Description Example/Range Parameter
symbol trading symbol AAPL Default
name full name of security issuer Apple Inc. Default
idscode industry code IDS00730 Default
seccode sector code SEC004 Default
sector sector name technology Default
industry industry name computer manufacturing Default
monthback trace back to last n months 3 Default
acqcnt count of acquisition transactions 18 Default
acqamt total shares amount of acquisition transactions 105210 Default
acqidsqt industry quantile of acqcnt 0~1 Default
acqsecqt sector quantile of acqcnt 0~1 Default
acqallqt market quantile of acqcnt 0~1 Default
acqpctso percentage of acqamt to outstanding shares 0~100 Default
acqtotalcost total cost (in USD) of acquisition transactions 31563000 Default
dspcnt count of disposition transactions 2 Default
dspamt total shares amount of disposition transactions 5000 Default
dspidsqt industry quantile of dspcnt 0~1 Default
dspsecqt sector quantile of dspcnt 0~1 Default
dspallqt market quantile of dspcnt 0~1 Default
dsppctso percentage of dspamt to outstanding shares 0~100 Default
dsptotalcost total cost (in USD) of disposition transactions 1500000 Default
shares_outstanding outstanding shares (in million) as of the last transaction date 4443.265 Default
x52wk_high 52-week high 312.67 Default
x52wk_low 52-week low 149.22 Default
recdate the latest trading day 2019-12-23 Default
close close price on recdate 284 Default
To top menu

Investment Company CIK [access=ivccik]

Retrieve a comprehensive list of mappings between investment company name and CIK

access=ivccik

Output

Field Name Description Example/Range Parameter
cik central index key 1067983 Default
name full name of investment company BERKSHIRE HATHAWAY INC Default
To top menu

Investment Company Holding [access=ivcholding]

Retrieve portfolio holdings of specific investment company at security level, or grouped by sector, industry

E.g. Retrieve holdings of CIK 1067983 (i.e. BERKSHIRE HATHAWAY INC) for the latest period grouped by industry

access=ivcholding&cik=1067983&grouping=industry


E.g. Retrieve holdings of CIK 1067983 (i.e. BERKSHIRE HATHAWAY INC) for the first quarter of 2019

access=ivcholding&cik=1067983&grouping=security&period=2019-03-31


Input

Parameter Argument Example Requirement Precedence Instruction
cik central index key cik=1067983 required cik of an investment companya
period a date period=2019-03-31 optional four periods per year
default is the latest reporting period
['YYYY-03-31','YYYY-06-30','YYYY-09-30','YYYY-12-31']
grouping a string grouping=industry required ['sector','industry','security']

a Check Investment Company CIK

Output

Field Name Description Example/Range Parameter
name full name of investment company BERKSHIRE HATHAWAY INC Default
cik central index key 1067983 Default
period reporting period 2019-09-30 Default
idscode industry code IDS00010 grouping=industry
industry industry name property/casualty/life/health/specialty insurers grouping=industry
seccode sector code SEC001 grouping=sector
sector sector name energy grouping=sector
value holding value in $1000 1494386 [grouping=industry] [grouping=sector]
chg change in holding value ($1000) at the discretion of portfolio managera 40028 [grouping=industry] [grouping=sector]
gstidsec internal security identifier USSEC00490148H grouping=security
shamount shares amount 483300 grouping=security
shvalue shares value in $1000 860637 grouping=security
issuername name of security issuer AMAZON COM INC grouping=security
class security class COM grouping=security

a The overall acquisition/disposition dollar amount calculated by multiplying changes in shares amount with deduced per share prices.

To top menu

Top Investment Company Trading [access=topivctrading]

Retrieve stocks with top acquisition or disposition by investment companies

E.g. Retrieve stocks with top investment company acquisition in the latest period, ordered by transaction count(descendingly)

access=topivctrading&operation=acq


E.g. similar to previous query, and set period to first quarter of 2019

access=topivctrading&operation=acq&period=2019-03-31


E.g. similar to previous query, and limit search scope to energy sector

access=topivctrading&scope=sector&seccode=SEC001&operation=acq&period=2019-03-31


E.g. similar to previous query, but look for top dispositions

access=topivctrading&scope=sector&seccode=SEC001&operation=dsp&period=2019-03-31

Overwhelmed by complex configurations?
Don't worry, contact us for free assistance on generating the query URL you want.


Input

Parameter Argument Example Requirement Precedence Instruction
operation a 3-char string operation=acq optional 'acq' for acquisition
'dsp' for disposition
['acq'(default),'dsp']
period a date period=2019-03-31 optional four periods per year
default is the latest reporting period
['YYYY-03-31','YYYY-06-30','YYYY-09-30','YYYY-12-31']
orderby a string orderby=count optional ['count'(default),'amount','acq2dspcnt','acq2dspamt']
limit an integer limit=20 optional 0~50
scope a string scope=market optional ['market'(default),'sector','industry']
seccode sector codea seccode=SEC001 optional default is SEC001 (i.e. energy sector)
idscode industry codea idscode=IDS00010 optional default is IDS00010 (i.e. property/casualty/life/health/specialty insurers)

a check sector/industry code mapping


Output

Field Name Description Example/Range Parameter
symbol trading symbol XOM Default
name full name of security issuer Exxon Mobil Corporation Default
exchange stock exchange NYS Default
gstidsec internal security identifier USSEC0064Q2291 Default
idscode industry code IDS00380 Default
seccode sector code SEC001 Default
sector sector name energy Default
industry industry name oil & gas production Default
period reporting period 2019-03-31 Default
aproxprc approximate transaction price 80.88 Default
acqnewcnt count of transactions establishing brand new position 111 Default
acqnewamt shares amount of transactions establishing brand new position 5923584 Default
acqchgcnt count of acquisition(not brand new) transactions 1038 Default
acqchgamt shares amount of acquisition(not brand new) transactions 93565061 Default
acqidsqt industry quantile of acqnewcnt + acqchgcnt 0~1 Default
acqsecqt sector quantile of acqnewcnt + acqchgcnt 0~1 Default
acqallqt market quantile of acqnewcnt + acqchgcnt 0~1 Default
acqpctso percentage of acqnewamt + acqchgamt to shares outstanding 2.35 Default
dspnewcnt count of sold out transactions 88 Default
dspnewamt shares amount of sold out transactions 45740152 Default
dspchgcnt count of disposition(not sold out) transactions 1126 Default
dspchgamt shares amount of disposition(not sold out) transactions 53481761 Default
dspidsqt industry quantile of dspnewcnt + dspchgcnt 0~1 Default
dspsecqt sector quantile of dspnewcnt + dspchgcnt 0~1 Default
dspallqt market quantile of dspnewcnt + dspchgcnt 0~1 Default
dsppctso percentage of dspnewamt + dspchgamt to shares outstanding 2.34 Default
shares_outstanding outstanding shares in Million 4234.802431 Default
acq2dspcnt ratio of acqnewcnt + acqchgcnt to dspnewcnt + dspchgcnt 0.947 Default
acq2dspamt ratio of acqnewamt + acqchgamt to dspnewamt + dspchgamt 1.00 Default
x52wk_high 52-week high 83.49 Default
x52wk_low 52-week low 66.31 Default
previous_close close price of the latest trading day 69.2 Default
To top menu

Income Statement [access=incomestatement]

Retrieve original or trailing 12 months(TTM) income statement for specific CIK or trading symbol

E.g. Retrieve original income statement for AAPL

access=incomestatement&mode=original&symbol=AAPL


E.g. similar to previous query, and trace back 3 years(i.e. 36 months)

access=incomestatement&mode=original&symbol=AAPL&monthback=36


E.g. similar to previous query, but query TTM income statement

access=incomestatement&mode=TTM&symbol=AAPL&monthback=36


Input

Parameter Argument Example Requirement Precedence Instruction
cik central index key cik=320193 conditional 1st must be presented if [symbol] is absent
symbol an upcase trading symbol symbol=AAPL conditional 2nd must be presented if [cik] is absent
mode a string mode=original optional ['original'(default),'TTM']
monthback an integer monthback=12 optional [>0]

Output

refer to Income Statement

To top menu

Balance Sheet [access=balancesheet]

Retrieve balance sheet for specific CIK or trading symbol

E.g. Retrieve balance sheet for AAPL

access=balancesheet&symbol=AAPL


E.g. similar to previous query, and trace back 3 years(i.e. 36 months)

access=balancesheet&symbol=AAPL&monthback=36


Input

Parameter Argument Example Requirement Precedence Instruction
cik central index key cik=320193 conditional 1st must be presented if [symbol] is absent
symbol an upcase trading symbol symbol=AAPL conditional 2nd must be presented if [cik] is absent
monthback an integer monthback=12 optional [>0]

Output

refer to Balance Sheet

To top menu

Cash FLow

Retrieve cash flow statement for specific CIK or trading symbol

E.g. Retrieve original cash flow statement for AAPL

access=cashflow&mode=original&symbol=AAPL


E.g. similar to previous query, and trace back 3 years(i.e. 36 months)

access=cashflow&mode=original&symbol=AAPL&monthback=36


Input

Parameter Argument Example Requirement Precedence Instruction
cik central index key cik=320193 conditional 1st must be presented if [symbol] is absent
symbol an upcase trading symbol symbol=AAPL conditional 2nd must be presented if [cik] is absent
mode a string mode=original optional ['original'(default),'TTM']
monthback an integer monthback=12 optional [>0]

Output

refer to Cash Flow

To top menu

Fundamental Query

Retrieve fundamental indicators and associated quantile rankings for specific CIK or trading symbol, or all trading symbols of specific record date
Note: fundamental data is recorded every saturday

Retrieve fundamental data for CIK 320193 for the latest record date

access=fundamental&cik=320193


Retrieve fundamental data for AAPL for the first half of 2019 (i.e. between 2019-01-01 to 2019-06-30)

access=fundamental&symbol=AAPL&startdate=2019-01-01&enddate=2019-06-30


Retrieve fundamental data for all trading symbols on 2019-01-05

access=fundamental&recdate=2019-01-05


Input

Parameter Argument Example Requirement Precedence Instruction
cik central index key cik=320193 conditional 1st must be presented if [symbol] [recdate] are absent
symbol an upcase trading symbol symbol=AAPL conditional 2nd must be presented if [cik] [recdate] are absent
recdate a date recdate=2019-01-05 conditional 3rd must be presented if [cik] [symbol] are absent
startdate a date startdate=2019-01-01 optional default to the latest record date
enddate a date enddate=2019-10-01 optional default to the latest record date

Output

refer to Fundamental Indicators

To top menu