Re: currency download from Oanda problems

[ Message Board ] [ Archives ] [ Search ]

Posted by Chris on September 13, 2007 at 16:55:16:

In Reply to: Re: currency download from Oanda problems posted by Mark on September 13, 2007 at 16:31:11:

: : Hi Mark - having trouble importing Euro exchange rate history correctly. Am using CSV format 05/01/2002,1.11110 but my download only imports the .11110. what am I doing wrong?

: : thanks.

: : Chris

: Hi Chris,

: I assume you're using the generic 'price' import with the format string:

: MM/DD/YY,NAV

: ?

: How are you verifying the updated price? You might want to make sure and turn off "View / Exchange Rate Adjusted", and then look in the Data Register with the "Prices" data type.

: Thanks,
: Mark
: --
: Fund Manager - Portfolio Management Software

Yes - am using generic 'price' import; "View / Exchange Rate Adjusted" is turned off; using MM/DD/YY,NAV format string. Would it have anything to do with the fact that the data from Oanda provides in the CSV format includes a 4 digit year?

Thank you.

(below copied from Oanda)

Conversion Table: USD to EUR (Interbank rate)

Time period: 09/20/02 to 09/30/02.
Daily averages: 09/20/2002,1.01370
09/21/2002,1.01820
09/22/2002,1.01820
09/23/2002,1.01950
09/24/2002,1.02260
09/25/2002,1.01920
09/26/2002,1.02450
09/27/2002,1.02440
09/28/2002,1.020
09/29/2002,1.0270
09/30/2002,1.01930

Replies:

• Re: currency download from Oanda problems Mark 17:29:03 09/13/07 (3)
  • Re: currency download from Oanda problems Chris 12:44:01 09/14/07 (2)
    • Re: currency download from Oanda problems Mark 12:56:15 09/14/07 (1)
      • Re: currency download from Oanda problems Chris 13:12:41 09/14/07 (0)