I am trying to calculate the change in dividend for many firms over time, based on daily stock return data and for this, I have run into the problem that I am unable to write a command that uses the next nonmissing value. My first idea would be to calculate it as:
Code:
by fakeID: replace divd = divd[_n-1] if missing(divd)
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long datadate str88 conm double divd float divchange 14375 "A.P. MOLLER - MAERSK A/S B" 300 . 14376 "A.P. MOLLER - MAERSK A/S B" . . 14378 "A.P. MOLLER - MAERSK A/S B" . . 14381 "A.P. MOLLER - MAERSK A/S B" . . 14382 "A.P. MOLLER - MAERSK A/S B" . . 14383 "A.P. MOLLER - MAERSK A/S B" . . 14384 "A.P. MOLLER - MAERSK A/S B" . . 14385 "A.P. MOLLER - MAERSK A/S B" . . 14389 "A.P. MOLLER - MAERSK A/S B" . . 14390 "A.P. MOLLER - MAERSK A/S B" . . 14391 "A.P. MOLLER - MAERSK A/S B" . . 14392 "A.P. MOLLER - MAERSK A/S B" . . 14395 "A.P. MOLLER - MAERSK A/S B" . . 14396 "A.P. MOLLER - MAERSK A/S B" . . 14397 "A.P. MOLLER - MAERSK A/S B" . . 14398 "A.P. MOLLER - MAERSK A/S B" . . 14399 "A.P. MOLLER - MAERSK A/S B" . . 14402 "A.P. MOLLER - MAERSK A/S B" . . 14403 "A.P. MOLLER - MAERSK A/S B" . . 14404 "A.P. MOLLER - MAERSK A/S B" . . 14405 "A.P. MOLLER - MAERSK A/S B" . . 14406 "A.P. MOLLER - MAERSK A/S B" . . 14409 "A.P. MOLLER - MAERSK A/S B" . . 14410 "A.P. MOLLER - MAERSK A/S B" . . 14411 "A.P. MOLLER - MAERSK A/S B" . . 14412 "A.P. MOLLER - MAERSK A/S B" . . 14413 "A.P. MOLLER - MAERSK A/S B" . . 14416 "A.P. MOLLER - MAERSK A/S B" . . 14417 "A.P. MOLLER - MAERSK A/S B" . . 14418 "A.P. MOLLER - MAERSK A/S B" . . 14419 "A.P. MOLLER - MAERSK A/S B" . . 14420 "A.P. MOLLER - MAERSK A/S B" . . 14423 "A.P. MOLLER - MAERSK A/S B" . . 14424 "A.P. MOLLER - MAERSK A/S B" . . 14425 "A.P. MOLLER - MAERSK A/S B" . . 14426 "A.P. MOLLER - MAERSK A/S B" . . 14427 "A.P. MOLLER - MAERSK A/S B" . . 14430 "A.P. MOLLER - MAERSK A/S B" . . 14431 "A.P. MOLLER - MAERSK A/S B" . . 14432 "A.P. MOLLER - MAERSK A/S B" . . 14433 "A.P. MOLLER - MAERSK A/S B" . . 14434 "A.P. MOLLER - MAERSK A/S B" . . 14437 "A.P. MOLLER - MAERSK A/S B" . . 14438 "A.P. MOLLER - MAERSK A/S B" . . 14439 "A.P. MOLLER - MAERSK A/S B" . . 14440 "A.P. MOLLER - MAERSK A/S B" . . 14441 "A.P. MOLLER - MAERSK A/S B" . . 14444 "A.P. MOLLER - MAERSK A/S B" . . 14445 "A.P. MOLLER - MAERSK A/S B" . . 14446 "A.P. MOLLER - MAERSK A/S B" . . 14447 "A.P. MOLLER - MAERSK A/S B" . . 14448 "A.P. MOLLER - MAERSK A/S B" . . 14451 "A.P. MOLLER - MAERSK A/S B" . . 14452 "A.P. MOLLER - MAERSK A/S B" . . 14453 "A.P. MOLLER - MAERSK A/S B" . . 14454 "A.P. MOLLER - MAERSK A/S B" . . 14455 "A.P. MOLLER - MAERSK A/S B" . . 14458 "A.P. MOLLER - MAERSK A/S B" . . 14459 "A.P. MOLLER - MAERSK A/S B" . . 14460 "A.P. MOLLER - MAERSK A/S B" . . 14461 "A.P. MOLLER - MAERSK A/S B" . . 14462 "A.P. MOLLER - MAERSK A/S B" . . 14465 "A.P. MOLLER - MAERSK A/S B" . . 14466 "A.P. MOLLER - MAERSK A/S B" . . 14467 "A.P. MOLLER - MAERSK A/S B" . . 14468 "A.P. MOLLER - MAERSK A/S B" . . 14469 "A.P. MOLLER - MAERSK A/S B" . . 14472 "A.P. MOLLER - MAERSK A/S B" . . 14473 "A.P. MOLLER - MAERSK A/S B" . . 14474 "A.P. MOLLER - MAERSK A/S B" . . 14475 "A.P. MOLLER - MAERSK A/S B" . . 14476 "A.P. MOLLER - MAERSK A/S B" . . 14479 "A.P. MOLLER - MAERSK A/S B" . . 14480 "A.P. MOLLER - MAERSK A/S B" . . 14481 "A.P. MOLLER - MAERSK A/S B" . . 14482 "A.P. MOLLER - MAERSK A/S B" . . 14483 "A.P. MOLLER - MAERSK A/S B" . . 14486 "A.P. MOLLER - MAERSK A/S B" . . 14487 "A.P. MOLLER - MAERSK A/S B" . . 14488 "A.P. MOLLER - MAERSK A/S B" . . 14489 "A.P. MOLLER - MAERSK A/S B" . . 14490 "A.P. MOLLER - MAERSK A/S B" . . 14493 "A.P. MOLLER - MAERSK A/S B" . . 14494 "A.P. MOLLER - MAERSK A/S B" . . 14495 "A.P. MOLLER - MAERSK A/S B" . . 14496 "A.P. MOLLER - MAERSK A/S B" . . 14497 "A.P. MOLLER - MAERSK A/S B" . . 14500 "A.P. MOLLER - MAERSK A/S B" . . 14501 "A.P. MOLLER - MAERSK A/S B" . . 14502 "A.P. MOLLER - MAERSK A/S B" . . 14503 "A.P. MOLLER - MAERSK A/S B" . . 14504 "A.P. MOLLER - MAERSK A/S B" . . 14507 "A.P. MOLLER - MAERSK A/S B" . . 14508 "A.P. MOLLER - MAERSK A/S B" . . 14509 "A.P. MOLLER - MAERSK A/S B" . . 14510 "A.P. MOLLER - MAERSK A/S B" . . 14511 "A.P. MOLLER - MAERSK A/S B" . . 14514 "A.P. MOLLER - MAERSK A/S B" . . 14515 "A.P. MOLLER - MAERSK A/S B" . . 14516 "A.P. MOLLER - MAERSK A/S B" . . 14517 "A.P. MOLLER - MAERSK A/S B" . . 14518 "A.P. MOLLER - MAERSK A/S B" . . 14521 "A.P. MOLLER - MAERSK A/S B" . . 14522 "A.P. MOLLER - MAERSK A/S B" . . 14523 "A.P. MOLLER - MAERSK A/S B" . . 14524 "A.P. MOLLER - MAERSK A/S B" . . 14525 "A.P. MOLLER - MAERSK A/S B" . . 14528 "A.P. MOLLER - MAERSK A/S B" . . 14529 "A.P. MOLLER - MAERSK A/S B" . . 14530 "A.P. MOLLER - MAERSK A/S B" . . 14531 "A.P. MOLLER - MAERSK A/S B" . . 14532 "A.P. MOLLER - MAERSK A/S B" . . 14535 "A.P. MOLLER - MAERSK A/S B" . . 14536 "A.P. MOLLER - MAERSK A/S B" . . 14537 "A.P. MOLLER - MAERSK A/S B" . . 14538 "A.P. MOLLER - MAERSK A/S B" . . 14539 "A.P. MOLLER - MAERSK A/S B" . . 14542 "A.P. MOLLER - MAERSK A/S B" . . 14543 "A.P. MOLLER - MAERSK A/S B" . . 14544 "A.P. MOLLER - MAERSK A/S B" . . 14545 "A.P. MOLLER - MAERSK A/S B" . . 14546 "A.P. MOLLER - MAERSK A/S B" . . 14549 "A.P. MOLLER - MAERSK A/S B" . . 14550 "A.P. MOLLER - MAERSK A/S B" . . 14551 "A.P. MOLLER - MAERSK A/S B" . . 14552 "A.P. MOLLER - MAERSK A/S B" . . 14553 "A.P. MOLLER - MAERSK A/S B" . . 14556 "A.P. MOLLER - MAERSK A/S B" . . 14557 "A.P. MOLLER - MAERSK A/S B" . . 14558 "A.P. MOLLER - MAERSK A/S B" . . 14559 "A.P. MOLLER - MAERSK A/S B" . . 14560 "A.P. MOLLER - MAERSK A/S B" . . 14563 "A.P. MOLLER - MAERSK A/S B" . . 14564 "A.P. MOLLER - MAERSK A/S B" . . 14565 "A.P. MOLLER - MAERSK A/S B" . . 14566 "A.P. MOLLER - MAERSK A/S B" . . 14567 "A.P. MOLLER - MAERSK A/S B" . . 14570 "A.P. MOLLER - MAERSK A/S B" . . 14571 "A.P. MOLLER - MAERSK A/S B" . . 14572 "A.P. MOLLER - MAERSK A/S B" . . 14573 "A.P. MOLLER - MAERSK A/S B" . . 14574 "A.P. MOLLER - MAERSK A/S B" . . 14577 "A.P. MOLLER - MAERSK A/S B" . . 14578 "A.P. MOLLER - MAERSK A/S B" . . 14579 "A.P. MOLLER - MAERSK A/S B" . . 14580 "A.P. MOLLER - MAERSK A/S B" . . 14581 "A.P. MOLLER - MAERSK A/S B" . . 14584 "A.P. MOLLER - MAERSK A/S B" . . 14585 "A.P. MOLLER - MAERSK A/S B" . . 14586 "A.P. MOLLER - MAERSK A/S B" . . 14587 "A.P. MOLLER - MAERSK A/S B" . . 14588 "A.P. MOLLER - MAERSK A/S B" . . 14591 "A.P. MOLLER - MAERSK A/S B" . . 14592 "A.P. MOLLER - MAERSK A/S B" . . 14593 "A.P. MOLLER - MAERSK A/S B" . . 14594 "A.P. MOLLER - MAERSK A/S B" . . 14595 "A.P. MOLLER - MAERSK A/S B" . . 14598 "A.P. MOLLER - MAERSK A/S B" . . 14599 "A.P. MOLLER - MAERSK A/S B" . . 14600 "A.P. MOLLER - MAERSK A/S B" . . 14601 "A.P. MOLLER - MAERSK A/S B" . . 14605 "A.P. MOLLER - MAERSK A/S B" . . 14606 "A.P. MOLLER - MAERSK A/S B" . . 14607 "A.P. MOLLER - MAERSK A/S B" . . 14608 "A.P. MOLLER - MAERSK A/S B" . . 14612 "A.P. MOLLER - MAERSK A/S B" . . 14613 "A.P. MOLLER - MAERSK A/S B" . . 14614 "A.P. MOLLER - MAERSK A/S B" . . 14615 "A.P. MOLLER - MAERSK A/S B" . . 14616 "A.P. MOLLER - MAERSK A/S B" . . 14619 "A.P. MOLLER - MAERSK A/S B" . . 14620 "A.P. MOLLER - MAERSK A/S B" . . 14621 "A.P. MOLLER - MAERSK A/S B" . . 14622 "A.P. MOLLER - MAERSK A/S B" . . 14623 "A.P. MOLLER - MAERSK A/S B" . . 14626 "A.P. MOLLER - MAERSK A/S B" . . 14627 "A.P. MOLLER - MAERSK A/S B" . . 14628 "A.P. MOLLER - MAERSK A/S B" . . 14629 "A.P. MOLLER - MAERSK A/S B" . . 14630 "A.P. MOLLER - MAERSK A/S B" . . 14633 "A.P. MOLLER - MAERSK A/S B" . . 14634 "A.P. MOLLER - MAERSK A/S B" . . 14635 "A.P. MOLLER - MAERSK A/S B" . . 14636 "A.P. MOLLER - MAERSK A/S B" . . 14637 "A.P. MOLLER - MAERSK A/S B" . . 14640 "A.P. MOLLER - MAERSK A/S B" . . 14641 "A.P. MOLLER - MAERSK A/S B" . . 14642 "A.P. MOLLER - MAERSK A/S B" . . 14643 "A.P. MOLLER - MAERSK A/S B" . . 14644 "A.P. MOLLER - MAERSK A/S B" . . 14647 "A.P. MOLLER - MAERSK A/S B" . . 14648 "A.P. MOLLER - MAERSK A/S B" . . 14649 "A.P. MOLLER - MAERSK A/S B" . . 14650 "A.P. MOLLER - MAERSK A/S B" . . 14651 "A.P. MOLLER - MAERSK A/S B" . . 14654 "A.P. MOLLER - MAERSK A/S B" . . 14655 "A.P. MOLLER - MAERSK A/S B" . . 14656 "A.P. MOLLER - MAERSK A/S B" . . 14657 "A.P. MOLLER - MAERSK A/S B" . . 14658 "A.P. MOLLER - MAERSK A/S B" . . 14661 "A.P. MOLLER - MAERSK A/S B" . . 14662 "A.P. MOLLER - MAERSK A/S B" . . 14663 "A.P. MOLLER - MAERSK A/S B" . . 14664 "A.P. MOLLER - MAERSK A/S B" . . 14665 "A.P. MOLLER - MAERSK A/S B" . . 14668 "A.P. MOLLER - MAERSK A/S B" . . 14669 "A.P. MOLLER - MAERSK A/S B" . . 14670 "A.P. MOLLER - MAERSK A/S B" . . 14671 "A.P. MOLLER - MAERSK A/S B" . . 14672 "A.P. MOLLER - MAERSK A/S B" . . 14675 "A.P. MOLLER - MAERSK A/S B" . . 14676 "A.P. MOLLER - MAERSK A/S B" . . 14677 "A.P. MOLLER - MAERSK A/S B" . . 14678 "A.P. MOLLER - MAERSK A/S B" . . 14679 "A.P. MOLLER - MAERSK A/S B" . . 14682 "A.P. MOLLER - MAERSK A/S B" . . 14683 "A.P. MOLLER - MAERSK A/S B" . . 14684 "A.P. MOLLER - MAERSK A/S B" . . 14685 "A.P. MOLLER - MAERSK A/S B" . . 14686 "A.P. MOLLER - MAERSK A/S B" . . 14689 "A.P. MOLLER - MAERSK A/S B" . . 14690 "A.P. MOLLER - MAERSK A/S B" . . 14691 "A.P. MOLLER - MAERSK A/S B" . . 14692 "A.P. MOLLER - MAERSK A/S B" . . 14693 "A.P. MOLLER - MAERSK A/S B" . . 14696 "A.P. MOLLER - MAERSK A/S B" . . 14697 "A.P. MOLLER - MAERSK A/S B" . . 14698 "A.P. MOLLER - MAERSK A/S B" . . 14699 "A.P. MOLLER - MAERSK A/S B" . . 14700 "A.P. MOLLER - MAERSK A/S B" . . 14703 "A.P. MOLLER - MAERSK A/S B" . . 14704 "A.P. MOLLER - MAERSK A/S B" . . 14705 "A.P. MOLLER - MAERSK A/S B" . . 14706 "A.P. MOLLER - MAERSK A/S B" . . 14707 "A.P. MOLLER - MAERSK A/S B" . . 14710 "A.P. MOLLER - MAERSK A/S B" . . 14711 "A.P. MOLLER - MAERSK A/S B" . . 14712 "A.P. MOLLER - MAERSK A/S B" . . 14713 "A.P. MOLLER - MAERSK A/S B" . . 14714 "A.P. MOLLER - MAERSK A/S B" . . 14717 "A.P. MOLLER - MAERSK A/S B" . . 14718 "A.P. MOLLER - MAERSK A/S B" . . 14719 "A.P. MOLLER - MAERSK A/S B" . . 14725 "A.P. MOLLER - MAERSK A/S B" . . 14726 "A.P. MOLLER - MAERSK A/S B" . . 14727 "A.P. MOLLER - MAERSK A/S B" . . 14728 "A.P. MOLLER - MAERSK A/S B" . . 14731 "A.P. MOLLER - MAERSK A/S B" . . 14732 "A.P. MOLLER - MAERSK A/S B" . . 14733 "A.P. MOLLER - MAERSK A/S B" . . 14734 "A.P. MOLLER - MAERSK A/S B" . . 14735 "A.P. MOLLER - MAERSK A/S B" . . 14738 "A.P. MOLLER - MAERSK A/S B" . . 14739 "A.P. MOLLER - MAERSK A/S B" . . 14740 "A.P. MOLLER - MAERSK A/S B" . . 14741 "A.P. MOLLER - MAERSK A/S B" 330 . end format %d datadate
Peter Ljungbeck
0 Response to Calculating change using last nonmissing value
Post a Comment