wrds_read: Take variables from table in WRDS

In pietroreggiani/wrds.operator: Client for access to WRDS data from R.

Take variables from table in WRDS

Description

Before being able to open the connection, you need to follow the steps here to set up your .pgpass file.

Usage

wrds_read(query, wrds, numrows = -1, data.table = TRUE)

Arguments

query	string including the SQL query syntax for WRDS (see their webpage)
wrds	connection created with the wrds_connect() function.
numrows	number of observations you want to get, default is all the available ones.
data.table	set to FALSE if you want a normal data.frame.

Value

a data.table or .frame containing the WRDS data requested

Examples

data <- wrds_read( "select mgrname from tfn.s34 where fdate between '2013-01-02' and '2015-03-02' ", numrows=100)

pietroreggiani/wrds.operator documentation built on April 26, 2022, 12:07 a.m.