I am new to WRDS and was trying to get data from WRDS for Compustat Monthly Updates - Supplemental Short Interest File. The criteria I used for search was date range Jan 2000 to Mar 2000 and one specific ticker code. But am getting an “ERROR: Column cik could not be found in the table/view identified with the correlation name A.”

Am not using ‘CIK’ for search.

Can someone tell me what this error is and how I can fix this?

hi Mishra,

I’ve not seen such an error before—did you solve it in the meanwhile?

Best Regards,

Joost

I think that was problem with error message. Now its showing “ERROR: Column TIC could not be found in the table/view identified with the correlation name A.”  This makes sense since am searching with ticker (TIC). However, it gets weirder again when I try to search with set of GVKeys instead of ticker. This time also I get the same error “ERROR: Column TIC could not be found in the table/view identified with the correlation name A.”

Mishra - 21 June 2016 12:45 PM

I think that was problem with error message. Now its showing “ERROR: Column TIC could not be found in the table/view identified with the correlation name A.”  This makes sense since am searching with ticker (TIC). However, it gets weirder again when I try to search with set of GVKeys instead of ticker. This time also I get the same error “ERROR: Column TIC could not be found in the table/view identified with the correlation name A.”

Please find attached a screenshot of the error. It would be great if anyone can help me with this since I need this data for my research work.

hi Mishra,

Could it be that somewhere ticker symbol was selected? In the last line “extra variables ...” it includes TIC.

Best Regards,

Joost

I had selected CUSIP and Ticker in the Query variables option. It was my understanding that this option is to choose the variables needed in the output file. I guess am wrong then, am I?

The error in the image that you attached gives me the impression that there is no ticker variable on the dataset. (so if you run the same query without selecting ticker it may work).

J.

Am getting similar error if I select any key (like CUSIP, SIC, CIK) from query variables option. Just to clarify, what exactly does the query variables do? Does it restrict the query somehow? Because we are not giving any values for these variables.

Ok—maybe that is the problem. You can use these variables to filter the results. Can you make a screenshot of that part of the form (form filled out)?

J.

Please find attached the screenshots

hi Mishra,

I’m afraid I don’t know what is going on—it is time to email the ‘real’ wrds helpdesk.

Best,

Joost

Thank you! I will do that.