generic price import

[flight]

Mark,

Is this format string acceptable for importing generic (.txt file) prices?

09/22/09 3.50
09/23/09 3.25
09/24/09 3.55
09/25/09 3.05
09/28/09 4.25
09/29/09 4.25
09/30/09 4.70
10/01/09 4.36
10/02/09 4.14
10/05/09 4.09
10/06/09 3.56
10/07/09 3.42
10/08/09 3.50
10/09/09 3.10
10/12/09 3.25
10/13/09 3.20
10/14/09 3.16
10/15/09 3.00
10/16/09 2.88
10/19/09 2.99
10/20/09 3.30
10/21/09 3.27
10/22/09 3.96
10/23/09 3.80
10/26/09 3.84
10/27/09 4.03
10/28/09 3.84
10/29/09 3.40
10/30/09 3.29
11/02/09 3.27
11/03/09 3.50
11/04/09 3.44
11/05/09 3.16
11/06/09 3.56
11/09/09 3.40
11/10/09 3.85
11/11/09 3.84
11/12/09 3.95
11/13/09 3.38
11/16/09 3.37
11/17/09 3.27
11/18/09 3.44
11/19/09 3.39
11/20/09 3.14
11/23/09 3.20
11/24/09 3.25
11/25/09 3.48
11/27/09 3.10
11/30/09 3.13
12/01/09 3.16
12/02/09 3.17
12/03/09 3.06
12/04/09 3.10
12/07/09 3.00
12/08/09 3.05
12/09/09 3.15
12/10/09 2.88
12/11/09 2.93
12/14/09 3.15
12/15/09 3.14
12/16/09 3.10
12/17/09 2.79
12/18/09 2.99
12/21/09 2.78
12/22/09 2.74
12/23/09 2.59
12/24/09 2.70
12/28/09 2.84
12/29/09 2.93
12/30/09 2.92
12/31/09 2.80

[Mark]

Hi flight,

Yes. You would use the format string:

MM/DD/YY NAV

and "Specify" the symbol.

[flight]

I thought so, but got the message "the specified input format did not match any lines in the imported file".

I used the one ending in PRN format

[Mark]

Hi flight,

I just test imported it using these settings, and it worked correctly. Did you look at your price file with a text editor? If you're viewing it in Excel there may be other formatting characters you're not seeing. I've attached the file I imported so you can try it too. The format string is:

MM/DD/YY NAV

and you must "Specify" the symbol, but not the date.

[flight]

that txt file didn't work either. i attached a screen shot.

[Mark]

Hi flight,

You aren't entering the format string. In the edit box that says "Input Format", you can type directly in there. You don't have to just press the down arrow and choose one of the recent ones. Type directly in that box, and enter:

MM/DD/YY NAV

which is the format of your data and that file.

[flight]

That worked. Thanks Mark!

[flight]

Mark,

Is this a valid import for transactions:

SYMB,TRAN,MM/DD/YY,ANUM,BNUM,CNUM

GSIP BUY 07/30/12 15.95 62.6959 0
VSIP BUY 07/30/12 15.40 64.9351 0
GSIP BUY 09/27/12 16.81 34.652 0
VSIP BUY 09/27/12 16.10 36.1801 0
GSIP BUY 10/11/12 16.53 30.248 0
VSIP BUY 10/11/12 16.09 31.0752 0
GSIP BUY 10/12/12 16.53 30.248 0
VSIP BUY 10/12/12 15.99 31.2695 0
VSIP BUY 10/24/12 15.90 31.4465 0
GSIP BUY 10/24/12 16.19 30.8833 0
GSIP BUY 10/24/12 16.19 13.8975 0
VSIP BUY 10/24/12 15.90 14.1509 0
GSIP BUY 12/11/12 16.56 60.3865 0
VSIP BUY 12/11/12 16.14 61.9579 0

[Mark]

Hi flight,

Yes, but you need to enter the format string that matches the format of your data. Since your data is space delimited, use a space in your format string, instead of a comma. It would be:

SYMB TRAN MM/DD/YY ANUM BNUM CNUM