| ID | Item | MySql | Category | Period | Use |
|---|---|---|---|---|---|
| 114 | Earnings ESP | earningsesp | EPS Actuals & Surprises | Last | 3 |
| 115 | Last Reported Qtr (yyyymm) | lastreportedqtryyyymm | EPS Actuals & Surprises | Q0 | 4 |
| 116 | Last Reported Fiscal Yr (yyyymm) | lastreportedfiscalyryyyymm | EPS Actuals & Surprises | F0 | 4 |
| 117 | Last EPS Report Date (yyyymmdd) | lastepsreportdateyyyymmdd | EPS Actuals & Surprises | F0 | 4 |
| 60 | # of Analysts in F0 Consensus | ofanalystsinf0consensus | EPS Estimate | F0 | 3 |
| 61 | # of Analysts in F1 Consensus | ofanalystsinf1consensus | EPS Estimate | F1 | 3 |
| 62 | # of Analysts in F2 Consensus | ofanalystsinf2consensus | EPS Estimate | F2 | 3 |
| 63 | # of Analysts in Q0 Consensus | ofanalystsinq0consensus | EPS Estimate | Q0 | 3 |
| 64 | # of Analysts in Q1 Consensus | ofanalystsinq1consensus | EPS Estimate | Q1 | 3 |
| 65 | # of Analysts in Q2 Consensus | ofanalystsinq2consensus | EPS Estimate | Q2 | 3 |
| 66 | Q0 Consensus Est. (last completed fiscal Qtr) | q0consensusestlastcompletedfiscalqtr | EPS Estimate | Q0 | 4 |
| 67 | Q1 Consensus Est. | q1consensusest | EPS Estimate | Q1 | 4 |
| 68 | Q2 Consensus Est. (next fiscal Qtr) | q2consensusestnextfiscalqtr | EPS Estimate | Q2 | 4 |
| 69 | St. Dev. F1 / F1 Consensus | stdevf1f1consensus | EPS Estimate | F1 | 3 |
| 70 | St. Dev. Q2 / Q2 Consensus | stdevq2q2consensus | EPS Estimate | Q2 | 3 |
| 71 | St. Dev. Q1 / Q1 Consensus | stdevq1q1consensus | EPS Estimate | Q1 | 3 |
| 72 | F0 Consensus Est. | f0consensusest | EPS Estimate | F0 | 5 |
| 73 | F1 Consensus Est. | f1consensusest | EPS Estimate | F1 | 5 |
| 74 | F2 Consensus Est. | f2consensusest | EPS Estimate | F2 | 5 |
| 120 | % Change Q0 Est. (4 weeks) | changeq0est4weeks | EPS Estimate Revisions | Q0 | 5 |
| ID | Item | MySql | Category | Period | Use |
Campos
| ID | Item | MySql | Category | Period | Use |
|---|---|---|---|---|---|
| 114 | Earnings ESP | earningsesp | EPS Actuals & Surprises | Last | 3 |
| 115 | Last Reported Qtr (yyyymm) | lastreportedqtryyyymm | EPS Actuals & Surprises | Q0 | 4 |
| 116 | Last Reported Fiscal Yr (yyyymm) | lastreportedfiscalyryyyymm | EPS Actuals & Surprises | F0 | 4 |
| 117 | Last EPS Report Date (yyyymmdd) | lastepsreportdateyyyymmdd | EPS Actuals & Surprises | F0 | 4 |
| 60 | # of Analysts in F0 Consensus | ofanalystsinf0consensus | EPS Estimate | F0 | 3 |
| 61 | # of Analysts in F1 Consensus | ofanalystsinf1consensus | EPS Estimate | F1 | 3 |
| 62 | # of Analysts in F2 Consensus | ofanalystsinf2consensus | EPS Estimate | F2 | 3 |
| 63 | # of Analysts in Q0 Consensus | ofanalystsinq0consensus | EPS Estimate | Q0 | 3 |
| 64 | # of Analysts in Q1 Consensus | ofanalystsinq1consensus | EPS Estimate | Q1 | 3 |
| 65 | # of Analysts in Q2 Consensus | ofanalystsinq2consensus | EPS Estimate | Q2 | 3 |
| 66 | Q0 Consensus Est. (last completed fiscal Qtr) | q0consensusestlastcompletedfiscalqtr | EPS Estimate | Q0 | 4 |
| 67 | Q1 Consensus Est. | q1consensusest | EPS Estimate | Q1 | 4 |
| 68 | Q2 Consensus Est. (next fiscal Qtr) | q2consensusestnextfiscalqtr | EPS Estimate | Q2 | 4 |
| 69 | St. Dev. F1 / F1 Consensus | stdevf1f1consensus | EPS Estimate | F1 | 3 |
| 70 | St. Dev. Q2 / Q2 Consensus | stdevq2q2consensus | EPS Estimate | Q2 | 3 |
| 71 | St. Dev. Q1 / Q1 Consensus | stdevq1q1consensus | EPS Estimate | Q1 | 3 |
| 72 | F0 Consensus Est. | f0consensusest | EPS Estimate | F0 | 5 |
| 73 | F1 Consensus Est. | f1consensusest | EPS Estimate | F1 | 5 |
| 74 | F2 Consensus Est. | f2consensusest | EPS Estimate | F2 | 5 |
| 120 | % Change Q0 Est. (4 weeks) | changeq0est4weeks | EPS Estimate Revisions | Q0 | 5 |
| ID | Item | MySql | Category | Period | Use |
Weekly Data
| Entry ID | Data | Ficheiro |
|---|---|---|
| 58 | 20/06/2021 | zacks_custom_screen_2021-06-20.csv |
| 59 | 13/06/2021 | zacks_custom_screen_2021-06-13.csv |
| 137 | 22/08/2021 | zacks_custom_screen_2021-08-22.csv |
| 138 | 15/08/2021 | zacks_custom_screen_2021-08-15.csv |
| 139 | 08/08/2021 | zacks_custom_screen_2021-08-08.csv |
| Entry ID | Data | Ficheiro |