Results 1 to 5 of 5

Automatic Currency Data and Time Generation

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2014
    Location
    Tehran, Iran
    MS-Off Ver
    2010
    Posts
    2

    Automatic Currency Data and Time Generation

    Hello guys,

    I want to make a historical dataset of the latest currency rates values, in two columns.
    Occurrence Time and Rate.
    for example;
    I've connected to "MSN Money" service via the following path:
    Data > Existing Connections > "MSN MoneyCentral ..." service. as you can see in the uploaded file. It provides latest currency rates every refresh interval.
    I've set the values to be refreshed every 1 min.
    Now, I want two columns, one (Rate column) representing every 1min value of Euro/USD to be located below the last recorded one dynamically, and one (Date Column) to record the occurrence date/time next to rate column automatically, as soon as rate values are generated.

    It means if I leave it alone for one hour, I should expect to see a 60x2 table containing below sample information which are generated automatically:

    12/11/2014 12:00 1.2445
    12/11/2014 12:01 1.2446
    12/11/2014 12:02 1.2443
    .
    .
    .
    12/11/2014 12:59 1.2440

    Any clue would be highly appreciated
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic generation of Start time, end time and total time in excel
    By dreamwarden in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2013, 08:03 PM
  2. Automatic email generation
    By Saky in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-06-2010, 10:50 AM
  3. Excel 2007 : Automatic Chart generation
    By hoobnb1 in forum Excel General
    Replies: 1
    Last Post: 10-19-2010, 09:23 AM
  4. Automatic number generation.
    By BM in forum Excel General
    Replies: 1
    Last Post: 08-14-2006, 09:40 AM
  5. Automatic E-Mail Generation
    By pikus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2005, 03:50 PM

Tags for this Thread

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