Spreadsheet: 198009d1354636452-lookup-date-and-ticker-and-return-price-example
Sheet: Sheet1

PERMNO | date | ALTPRC
10057 | 1991-01-31 00:00:00 | 5.375
10057 | 1991-02-28 00:00:00 | 6.625
10057 | 1991-03-28 00:00:00 | 6.625
10057 | 1991-04-30 00:00:00 | 6.5
10057 | 1991-05-31 00:00:00 | 6.5
10057 | 1991-06-28 00:00:00 | 6
10057 | 1991-07-31 00:00:00 | 6.875
10057 | 1991-08-30 00:00:00 | 6.625
10057 | 1991-09-30 00:00:00 | 6.25
10057 | 1991-10-31 00:00:00 | 6.375
10057 | 1991-11-29 00:00:00 | 6.375
10057 | 1991-12-31 00:00:00 | 7.25
10057 | 1992-01-31 00:00:00 | 9.625
10057 | 1992-02-28 00:00:00 | 9.75
10057 | 1992-03-31 00:00:00 | 10.25
10057 | 1992-04-30 00:00:00 | 8.125
10057 | 1992-05-29 00:00:00 | 6.625
10057 | 1992-06-30 00:00:00 | 6.125
10057 | 1992-07-31 00:00:00 | 7
10057 | 1992-08-31 00:00:00 | 6.75
10057 | 1992-09-30 00:00:00 | 6.75
10057 | 1992-10-30 00:00:00 | 7.5
10057 | 1992-11-30 00:00:00 | 9.25
10057 | 1992-12-31 00:00:00 | 8.25
10057 | 1993-01-29 00:00:00 | 8.75
10057 | 1993-02-26 00:00:00 | 8.125
10057 | 1993-03-31 00:00:00 | 8.125
10057 | 1993-04-30 00:00:00 | 9.125
10057 | 1993-05-28 00:00:00 | 10.75
10057 | 1993-06-30 00:00:00 | 11.25
10057 | 1993-07-30 00:00:00 | 11
10057 | 1993-08-31 00:00:00 | 9.25
10057 | 1993-09-30 00:00:00 | 9.5
10057 | 1993-10-29 00:00:00 | 10.375
10057 | 1993-11-30 00:00:00 | 9.5
10057 | 1993-12-31 00:00:00 | 9.5
10057 | 1994-01-31 00:00:00 | 10.5
10057 | 1994-02-28 00:00:00 | 9.375
10057 | 1994-03-31 00:00:00 | 9.375
10057 | 1994-04-29 00:00:00 | 15.25
10057 | 1994-05-31 00:00:00 | 10.875
10057 | 1994-06-30 00:00:00 | 10.375
10057 | 1994-07-29 00:00:00 | 11.375
10057 | 1994-08-31 00:00:00 | 12.5
10057 | 1994-09-30 00:00:00 | 14
10057 | 1994-10-31 00:00:00 | 13.5
10057 | 1994-11-30 00:00:00 | 10.875
10057 | 1994-12-30 00:00:00 | 10.5
10057 | 1995-01-31 00:00:00 | 15.625
10057 | 1995-02-28 00:00:00 | 14.5
10057 | 1995-03-31 00:00:00 | 16
10057 | 1995-04-28 00:00:00 | 20.75
10057 | 1995-05-31 00:00:00 | 23.375
10057 | 1995-06-30 00:00:00 | 23.625
10057 | 1995-07-31 00:00:00 | 26.5
10057 | 1995-08-31 00:00:00 | 24.75
10057 | 1995-09-29 00:00:00 | 26.75
10057 | 1995-10-31 00:00:00 | 21.875
10057 | 1995-11-30 00:00:00 | 22.75
10057 | 1995-12-29 00:00:00 | 18.75
10057 | 1996-01-31 00:00:00 | 18.625
10057 | 1996-02-29 00:00:00 | 19.25
10057 | 1996-03-29 00:00:00 | 30.875
10057 | 1996-04-30 00:00:00 | 30.125
10057 | 1996-05-31 00:00:00 | 29.625
10057 | 1996-06-28 00:00:00 | 30
10057 | 1996-07-31 00:00:00 | 30
10078 | 1991-01-31 00:00:00 | 28.375
10078 | 1991-02-28 00:00:00 | 32.125
10078 | 1991-03-28 00:00:00 | 31.75
10078 | 1991-04-30 00:00:00 | 36.75
10078 | 1991-05-31 00:00:00 | 36.875
10078 | 1991-06-28 00:00:00 | 27.875
10078 | 1991-07-31 00:00:00 | 30.625
10078 | 1991-08-30 00:00:00 | 32.25
10078 | 1991-09-30 00:00:00 | 30.25
10078 | 1991-10-31 00:00:00 | 24.75
10078 | 1991-11-29 00:00:00 | 24
10078 | 1991-12-31 00:00:00 | 28.375
10078 | 1992-01-31 00:00:00 | 30.5
10078 | 1992-02-28 00:00:00 | 34.5
10078 | 1992-03-31 00:00:00 | 28.625
10078 | 1992-04-30 00:00:00 | 27.375
10078 | 1992-05-29 00:00:00 | 27.875
10078 | 1992-06-30 00:00:00 | 26.125
10078 | 1992-07-31 00:00:00 | 26.75
10078 | 1992-08-31 00:00:00 | 26.875
10078 | 1992-09-30 00:00:00 | 31.25
10078 | 1992-10-30 00:00:00 | 35.25
10078 | 1992-11-30 00:00:00 | 31.75
10078 | 1992-12-31 00:00:00 | 33.625
10078 | 1993-01-29 00:00:00 | 39
10078 | 1993-02-26 00:00:00 | 35.125
10078 | 1993-03-31 00:00:00 | 30
10078 | 1993-04-30 00:00:00 | 27
10078 | 1993-05-28 00:00:00 | 30
10078 | 1993-06-30 00:00:00 | 29.625
10078 | 1993-07-30 00:00:00 | 29.75
10078 | 1993-08-31 00:00:00 | 26.25
10078 | 1993-09-30 00:00:00 | 24
10078 | 1993-10-29 00:00:00 | 25.5
10078 | 1993-11-30 00:00:00 | 26.625
10078 | 1993-12-31 00:00:00 | 29.125
10078 | 1994-01-31 00:00:00 | 26.5
10078 | 1994-02-28 00:00:00 | 27.125
10078 | 1994-03-31 00:00:00 | 27.375
10078 | 1994-04-29 00:00:00 | 22.375
10078 | 1994-05-31 00:00:00 | 20.875
10078 | 1994-06-30 00:00:00 | 20.625
10078 | 1994-07-29 00:00:00 | 22.25
10078 | 1994-08-31 00:00:00 | 26.5