Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: RE: How to calculate the time elapsed between two trading?


From   Jeetendra Aryal <jeetendra.aryal@umb.no>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: How to calculate the time elapsed between two trading?
Date   Wed, 15 Oct 2008 00:52:11 +0200

Dear Martin,
I am using Stata10 and tried to copy data sheet from stata data editor to excel spread sheet. I tried -xmlsave .., but could not solve my problem.

thanks,
Jeetendra

>-----Original Message-----
>From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
>statalist@hsphsun2.harvard.edu] On Behalf Of Martin Weiss
>Sent: Wednesday, October 15, 2008 12:27 AM
>To: statalist@hsphsun2.harvard.edu
>Subject: Re: st: RE: How to calculate the time elapsed between two
>trading?
>
>Your message is barely intelligble, and you are messing up the threads
>in
>the archive! Anyway, just -outsheet- your data to .txt. or .csv. Or, in
>Stata 10, use -xmlsave-...
>
>HTH
>Martin
>_______________________
>----- Original Message -----
>From: "Jeetendra Aryal" <jeetendra.aryal@umb.no>
>To: <statalist@hsphsun2.harvard.edu>
>Sent: Wednesday, October 15, 2008 12:23 AM
>Subject: RE: st: RE: How to calculate the time elapsed between two
>trading?
>
>
>>I have very simple question,
>> - I tried to save a data file in STATA to excel. I tried in as
>follows: I
>> just copy it from stata to excel but I have problems in the file in
>excel.
>> Some of the data are now changed in to date. can anyone help me in
>this?
>> regards,
>> Jeetendra
>>
>>>-----Original Message-----
>>>From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
>>>statalist@hsphsun2.harvard.edu] On Behalf Of Katia Bobulova
>>>Sent: Tuesday, October 14, 2008 11:09 PM
>>>To: statalist@hsphsun2.harvard.edu
>>>Subject: Re: st: RE: How to calculate the time elapsed between two
>>>trading?
>>>
>>>Dear Nick,
>>>
>>>thank you very much for your help.
>>>
>>>It is exactly what I was trying to do.
>>>
>>>Thanks
>>>
>>>Katia
>>>
>>>2008/10/14 Nick Cox <n.j.cox@durham.ac.uk>:
>>>> gen byte istrading = trading == "T"
>>>> bysort date (istrading time) : gen dt = time - time[_n-1] if
>istrading
>>>& istrading[_n-1]
>>>>
>>>> This naturally excludes differences between the last trade of a day
>>>and the first trade of the next day, as did your code here.
>>>>
>>>> Nick
>>>> n.j.cox@durham.ac.uk
>>>>
>>>> Katia Bobulova
>>>>
>>>> I have to costruct a variable for the time elapsed between two
>trading
>>>> (trading=T)
>>>>
>>>>  I have this situation:
>>>>
>>>> Date               time        control    newvariable
>>>> 02/01/2007   16:50:55        T         165000
>>>> 02/01/2007   16:50:56        T         165000
>>>> 03/01/2007   17:02:30        T         170230
>>>> 03/01/2007   18:30:20        R            .
>>>> 03/01/2007   18:32:00        T         183200
>>>>
>>>> Now the result that I would like to reach is to have new variable
>>>> which has as observations: 0 and 12970, because the first one is the
>>>> result of the diff between the first two newvariable, since they
>take
>>>> place at the same time, the second one should be the difference
>>>> between the newvariable at time 17:02:30 and the other one at
>18:32:00
>>>> (since I am considering just the obs with control=T).
>>>>
>>>> I tried to do this:
>>>>
>>>> gen newvariable= time if control=="T"
>>>> by sort date: gen newvariable1=newvariable-newvariable[_n-1]
>>>>
>>>> but I don't have the result that i would like to have, since i am
>>>> trying to calculate the time elapsed between two trading(control=T).
>>>>
>>>>
>>>> *
>>>> *   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/
>>>>
>>>*
>>>*   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/
>>
>> *
>> *   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/
>>
>
>
>*
>*   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/

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index