Hello,
I have been trying to transform intraday data (downloaded from Bloomberg into an excel file) so that it is easily read by stata. I attach a picture of the data.
The code I have used is:
gen str ts= substr(A, 1, 2502) + " " + substr(A, 25, 4)
gen double dt = clock(ts, "DMY hms ")
*ideally I would use this last sentence to translate the dates, specifying for stata Y/M/D/H/m/s... however this function generates as many missing values as observations (2502).
How can I solve this problem?
So far I have been following the steps in this document: https://www.stata.com/manuals13/u24.pdf
Array
Related Posts with inputting intraday data from bloomberg
Testing individual coefficients across different regressionsI want to understand the different impact of education and number of children on the probability of …
Question about reghdfe commandDear all.When we use reghdfe to run pannel fixed-effects model,which kind of Rsq should we report in…
variable-coefficient panel data modelDear all.If I want to use variable-coefficient panel data model ,which Stata command can I use? Raym…
-xtoverid-Dear Statalists, I am new here and need help to download the community-contributed command -xtoveri…
Question about graph plotDear all.I have plot two graphs, namely, figure A and figure B. now I want to embed figure B into fi…
Subscribe to:
Post Comments (Atom)
0 Response to inputting intraday data from bloomberg
Post a Comment