+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 17 of 17

Condensing 1-minute forex data to 20-minute forex data

  1. #16
    Registered User
    Join Date
    07-09-2013
    Location
    Dunedin, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    76

    Re: Condensing 1-minute forex data to 20-minute forex data

    When I do the first part of the Find and Replace I end up with a column of 1's ??

    Bob M

  2. #17
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,373

    Re: Condensing 1-minute forex data to 20-minute forex data

    Initially

    A
    1
    Local time
    2
    01.07.2010 00:00:00.000 GMT+1200
    3
    01.07.2010 00:01:00.000 GMT+1200
    4
    01.07.2010 00:02:00.000 GMT+1200
    5
    01.07.2010 00:03:00.000 GMT+1200


    Replace .000* with nothing

    A
    1
    Local time
    2
    01.07.2010 00:00:00
    3
    01.07.2010 00:01:00
    4
    01.07.2010 00:02:00
    5
    01.07.2010 00:03:00


    Replace . with /

    A
    1
    Local time
    2
    1/7/2010 0:00
    3
    1/7/2010 0:01
    4
    1/7/2010 0:02
    5
    1/7/2010 0:03


    EDIT: I see in the prior post I said replace .0* with nothing.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1