Re: currency download from Oanda problems

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on September 13, 2007 at 17:29:03:

In Reply to: Re: currency download from Oanda problems posted by Chris on September 13, 2007 at 16:55:16:

: 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

Hi Chris,

The 'YY' in the format string will match a 4 digit year okay. I don't see anything wrong. How are you verifying the price that gets imported?

Maybe you could email me your CSV file, along with the investment file you're importing it into. I'll give it a try here. To get our email address, just fill out the 'contact us' email form with any simple message.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies:

• 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)