Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# RE: st: Draw an offer curve (supply curve)?

 From Nick Cox To "'statalist@hsphsun2.harvard.edu'" Subject RE: st: Draw an offer curve (supply curve)? Date Wed, 2 Nov 2011 20:48:01 +0000

```As said, you can use -separate- on -p-. Different IDs would just be superimposed and whichever was plotted last would show on top. I can't comment on what MS Excel can do.

Nick
n.j.cox@durham.ac.uk

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Guang Dai
Sent: 02 November 2011 20:42
To: statalist@hsphsun2.harvard.edu
Subject: RE: st: Draw an offer curve (supply curve)?

no, that really doesn't matter. If two identical pairs are offered by two IDs, we just assign half of the "stairstep" to one ID and color the half with the ID's color.
But I'm interested in how to do that. In excel, this is very easy, but seems not in Stata.

Guang Dai | Economist, Market Surveillance Administrator | 403.705.3183 | #500, 400 - 5th Avenue S.W., Calgary AB T2P 0L6 | www.albertamsa.ca
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
Sent: Wednesday, November 02, 2011 2:23 PM
To: 'statalist@hsphsun2.harvard.edu'
Subject: RE: st: Draw an offer curve (supply curve)?

Your own example shows that the same (quantity, price) pair can apply to different values of -ID-, so that distinguishing them is not fully possible. Otherwise you would need to apply -separate- to -p-.

Nick
n.j.cox@durham.ac.uk

G. Dai

By the way, is there any way to indicate the ID of the offered quantity, that is the stairstep in the curve? Say, can we use different colors to distinguish IDs in the offer curve?
thanks,

On Mon, Oct 24, 2011 at 7:07 AM, Brian P. Poi <bpoi@stata.com> wrote:
> G. Dai wrote:
>>
>> Dear all,
>> I have a dataset on real offering behavior and I want to draw an
>> offering curve (supply curve) from the data set.
>> One simple example of the data is following:
>>
>>
>> 1       10                         99
>> 2        23                        90
>> 1        5                          50
>> 4       30                         32
>> 3       39                         10
>> 2       30                          0
>> 4       20                          0
>> 3       20                          0
>>
>> ID is the individual participating in the trade, and quantity_offered
>> is the quantity they can offer at the price of Price_asked.
>> We can see some individuals just ask zero price for some quantities,
>> while ask a higher price for extra quantities.  My object is draw an
>> offer curve (supply curve) from the data in an efficient way because
>> the dataset  is big.
>>
>> Any suggestion is appreciated.
>> Thanks and have a great weekend!
>
> How about something like this:
>
> . input id q p
> 1       10                         99
> 2        23                        90
> 1        5                         50
> 4       30                         32
> 3       39                         10
> 2       30                          0
> 4       20                          0
> 3       20                          0
> end
>
> . sort p                  // put data in ascending price order . gen
> totalq = sum(q)     // running sum of total quantity offered
>                          // for price <= p . line p totalq,
> connect("stairstep")
>

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```