Workday data into daily data (known values)

 

Hi, 

I have data for Apple stock prices since 2010. Since there is no trading on weekends or holidays, some of the dates are missing, for example: 



04/01/10 30.5729
05/01/10 30.6257
06/01/10 30.1386
07/01/10 30.0829
08/01/10 30.2829
11/01/10 30.0157
12/01/10 29.6743

I need to convert this into daily data in order to calculate forward prices. Is there a way to paste the values above into a column of daily values, without individually matching each value with the right date? 

For example, the data above would look like: 



04/01/10 30.5729
05/01/10 30.6257
06/01/10 30.1386
07/01/10 30.0829
08/01/10 30.2829
09/01/10  
10/01/10  
11/01/10 30.0157
12/01/10 29.6743

I would then go on to fill the missing values with “last known” price. It just seems too painful to have to match every price with the corresponding date individually. 

 

Thanks in advance 🙂 

By: Katie

22 thoughts on “Workday data into daily data (known values)

  1. Acheter Reductil en ligne

    Today, I went to the beach front with my children. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is entirely off topic but I had to tell someone!

  2. Comprare Melanotan 2

    I think this is among the so much vital information for me. And i’m happy studying your article. However want to observation on some common things, The website taste is wonderful, the articles is truly excellent : D. Good activity, cheers

  3. Sibutril Online Kaufen

    Hello there! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a extraordinary job!

  4. ephedrin kaufen

    hello there and thanks in your info – I’ve definitely picked up anything new from right here. I did on the other hand expertise a few technical issues the usage of this site, as I experienced to reload the website a lot of instances prior to I may just get it to load correctly. I had been thinking about in case your hosting is OK? Now not that I am complaining, but slow loading instances times will very frequently affect your placement in google and could damage your high quality rating if advertising and ***********|advertising|advertising|advertising and *********** with Adwords. Anyway I am including this RSS to my e-mail and can look out for much more of your respective interesting content. Ensure that you replace this again very soon..

  5. Acquista Insulina Per Diabetici In Linea

    Howdy! This is kind of off topic but I need some guidance from an established blog. Is it hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about creating my own but I’m not sure where to begin. Do you have any tips or suggestions? With thanks

  6. Ephedrine online kaufen

    Definitely imagine that which you stated. Your favorite justification appeared to be on the net the easiest factor to be mindful of. I say to you, I definitely get irked while folks think about worries that they plainly do not recognise about. You managed to hit the nail upon the top and defined out the entire thing with no need side effect , other folks can take a signal. Will likely be again to get more. Thanks

  7. ig

    I’m not sure why but this web site is loading extremely slow for me.
    Is anyone else having this issue or is it a issue
    on my end? I’ll check back later on and see if the problem still exists.

  8. Asuncion Economou

    Whats up very cool web site!! Man .. Excellent .. Amazing .. I’ll bookmark your site and take the feeds additionally…I am glad to find so many useful info right here within the publish, we need develop more techniques on this regard, thank you for sharing. . . . . .

Comments are closed.