Skip to Main Content

Erasmus Data Service Centre (EDSC) manuals

Overview of manuals provided by the EDSC

Why is the stock price in CRSP preceded by a minus sign?

by Suraya Farah Gaeta on 2021-05-26T09:40:00+02:00 | 0 Comments

Sometimes you see negative stock prices in CRSP. This means that there was no closing price available for that period. Instead, the bid/ask average was used. To distinguish the bid/ask averages from actual closing prices, CRSP puts a leading dash in front of the price when the bid/ask average was used. If neither price nor bid/ask average is available, Price or Bid/Ask Average is set to zero.


 Add a Comment

0 Comments.

  Recent Posts



Finding Tobin’s Q using Eikon Datastream ‘Expressions’
Replace all formulas in Excel
Once you are finished downloading you might end up with a lot of sheets containing formulas. If you need to replace your formulas by values in all sheets at once you can use this macro.
Bloomberg doesn't export to Excel
Sometimes when you try to export to Excel nothing happens. This blogpost might help you to solve this issue.

  Subscribe



Enter your e-mail address to receive notifications of new posts by e-mail.


  Archive



  Return to Blog
This post is closed for further discussion.