Skip to content

Instantly share code, notes, and snippets.

@erikcs
Last active May 10, 2016 18:47
Show Gist options
  • Save erikcs/34c8b00c2e27ca3b64728f9d3bf19787 to your computer and use it in GitHub Desktop.
Save erikcs/34c8b00c2e27ca3b64728f9d3bf19787 to your computer and use it in GitHub Desktop.
wrds-formtypes
>>dbGetQuery(wrds, wrap("SELECT periodEndDate, companyId, TotTermLoans,
periodTypeName, formType
FROM CIQ.WRDS_SUMMARY
WHERE companyId=18527 AND YEAR(periodEndDate)=2008
ORDER BY periodEndDate, formType"))
periodEndDate companyId TotTermLoans periodTypeName formType
1 2008-03-31 18527 NA YTD 6-K
2 2008-03-31 18527 NA YTD 6-K
3 2008-03-31 18527 NA LTM 6-K
4 2008-03-31 18527 NA Quarterly 6-K
5 2008-03-31 18527 NA LTM 6-K
6 2008-03-31 18527 NA Quarterly 6-K
7 2008-06-30 18527 NA YTD 6-K
8 2008-06-30 18527 NA LTM 6-K
9 2008-06-30 18527 NA Quarterly 6-K
10 2008-06-30 18527 NA Semi-Annual 6-K
11 2008-06-30 18527 NA Quarterly 6-K
12 2008-06-30 18527 NA YTD 6-K
13 2008-06-30 18527 NA LTM 6-K
14 2008-09-30 18527 NA Quarterly 6-K
15 2008-09-30 18527 NA LTM 6-K
16 2008-09-30 18527 NA YTD 6-K
17 2008-09-30 18527 NA YTD Interim PR
18 2008-09-30 18527 NA Quarterly Interim PR
19 2008-09-30 18527 NA LTM Interim PR
20 2008-12-31 18527 6.7287 LTM 20-F
21 2008-12-31 18527 6.7287 YTD 20-F
22 2008-12-31 18527 NA Semi-Annual 20-F
23 2008-12-31 18527 9.0986 YTD 20-F
24 2008-12-31 18527 6.7287 YTD 20-F
25 2008-12-31 18527 6.7287 Annual 20-F
26 2008-12-31 18527 9.0986 Quarterly 20-F
27 2008-12-31 18527 6.7287 Quarterly 20-F
28 2008-12-31 18527 6.7287 LTM 20-F
29 2008-12-31 18527 9.0986 LTM 20-F
30 2008-12-31 18527 6.7287 Annual 20-F
31 2008-12-31 18527 9.0986 Annual 20-F
32 2008-12-31 18527 NA Quarterly 6-K
33 2008-12-31 18527 NA LTM Annual PR
34 2008-12-31 18527 NA YTD Annual PR
35 2008-12-31 18527 NA Annual Annual PR
36 2008-12-31 18527 NA Semi-Annual Annual PR
37 2008-12-31 18527 NA LTM Annual PR
38 2008-12-31 18527 NA Annual Annual PR
39 2008-12-31 18527 NA YTD Annual PR
40 2008-12-31 18527 NA Quarterly Interim PR
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment