If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
|
|
|
|
#1 |
|
+ 1
Join Date: May 2006
Posts: 3,924
|
I got price data time series for stocks in excel.
Problem is that the data is downloaded from datastream, and this results in a desimal error (or rather, it forgets to put desimals into the number, the end result being that that instead of having a stock price of 12,12345 it shows as 12112345, meaning that the place where the , (or . depending on region) is supposed to be, is not there). Is there an easy way to make excel put a , behind the first 2 numbers in each time series? (cannot do it by hand, as its 2600+ observations for 20 different stocks)
__________________
"I'm going to get rich when i figure out how to stab people over the internet" |
|
|
|
| Thread Tools | |
| Display Modes | |
|
|