Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Plotting

    Plotting

    InvestorID InvestmentTime InvestmentType InvestmentNumber SuccessInvestments InvestmentStatus
    87967 1/2/2012 7:47 Manual Bidding 1 1 CLOSED
    87967 1/10/2012 7:15 Manual Bidding 2 2 CLOSED
    87967 3/19/2012 8:03 Manual Bidding 3 3 CLOSED
    87967 5/16/2012 7:49 Manual Bidding 4 4 CLOSED
    87967 6/19/2012 8:10 Manual Bidding 5 5 CLOSED
    87967 6/19/2012 8:21 Manual Bidding 6 6 CLOSED
    87967 7/9/2012 4:06 Manual Bidding 7 7 CLOSED
    87967 8/17/2012 8:05 Manual Bidding 8 8 CLOSED
    87967 9/5/2012 4:12 Manual Bidding 9 9 CLOSED
    87967 11/7/2012 4:07 Manual Bidding 10 10 CLOSED
    87967 1/22/2013 2:32 Manual Bidding 11 11 CLOSED
    87967 5/20/2013 4:31 Automatic Bidding 12 12 CLOSED
    87967 5/29/2013 3:49 Automatic Bidding 13 12 FAILED
    87967 5/30/2013 4:23 Automatic Bidding 14 12 FAILED
    87967 5/31/2013 8:43 Automatic Bidding 15 13 CLOSED
    87967 6/3/2013 5:27 Automatic Bidding 16 14 CLOSED
    87967 6/3/2013 8:50 Automatic Bidding 17 15 CLOSED
    87967 6/3/2013 8:59 Automatic Bidding 18 16 CLOSED
    87967 6/4/2013 5:05 Automatic Bidding 19 17 CLOSED
    87967 6/6/2013 4:31 Automatic Bidding 20 18 CLOSED
    87967 6/6/2013 6:18 Automatic Bidding 21 19 CLOSED
    87967 7/15/2013 4:47 Automatic Bidding 22 20 CLOSED
    Hello guys,
    I want to plot a graph for investors to show how when they start bidding on the platform, they start using manual type of bids. However, when they spend some time on the market, they switch to automatic bidding. How can I plot this using the variables mentioned above. I also have a variable called Experience which shows their time on market spent in days.Investment number is the number of investment attempted (1,2,3,4.......10k). InvestmentType is a variable where Manual Bidding = 0 and Automatic Bidding = 1.

    I tried this code but it didn't give me the results i want to show. It just showed me the flow of my data. My aim is to show how investors switch from manual to automatic or visa versa at a certain period of time.

    Code:
    bys InvestorId InvestmentNumber: g ManualBids = 1 if InvestmentType==0
    replace ManualBids =0 if ManualBids ==.
    replace ManualBids = sum(ManualBids)
    
    
    bys InvestorId InvestmentNumber: g AutomatedBids = 1 if InvestmentType==1
    replace AutomatedBids =0 if AutomatedBids ==.
    replace AutomatedBids = sum(AutomatedBids)
    
    
    collapse AutomatedBids ManualBids, by(InvestmentNumber)
    
    twoway (scatter ManualBids InvestmentNumber, mcolor(navy)) (scatter AutomatedBids InvestmentNumber,mcolor(maroon))
    Thanks

  • #2
    Perhaps you can share an example of what you're imagining this would look like. I read this post and your post from yesterday and it's still not clear to me what the end result should look like. Also, you used CODE delimiters for your commands, please do the same for your data. Load your data in Stata and then type dataex. Copy and paste those results into your post. If you are running an older version of Stata, type ssc install dataex if you get the error code r(199).

    Comment

    Working...
    X