›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Error on fresh version of 2.4 version "symbol column does not exist"

jagmanvdpjagmanvdp
in Excel Workbook
Hello:

I am converting over from version 2.3 to 2.4
I downloaded the new version and the new scripts
unzipped them, transferred over my quotes from 2.3, along with updating psconfig etc.
and then ran the update psconfig.batch file......no errors

It seems to have created all the necessary files

then i moved over my src, src transactions and src symbols and then ran "refresh all

I got an error that says

We couldn't refresh the table "Quotes" from the connection "quotes" Here is the error we got
The "symbol" column does not exist in the rowset.

Here's an example from one of my quotes files

2008-07-31,84.910004,BDX
2008-08-29,87.379997,BDX
2008-09-30,80.260002,BDX
2008-10-31,69.400002,BDX
2008-11-28,63.529999,BDX
2008-12-31,68.389999,BDX
2009-01-30,72.669998,BDX

It looks like the symbol is there, but I have obviously done something wrong.Here is a sample from the quotes folder that the program creates for itself in psdata

"2010-02-26 77.870003 BDX"
"2010-03-31 78.730003 BDX"
"2010-04-30 76.370003 BDX"
"2010-05-28 71.300003 BDX"
"2010-06-30 67.620003 BDX"
"2010-07-30 68.800003 BDX"
"2010-08-31 68.190002 BDX"
"2010-09-30 74.099998 BDX"
"2010-10-29 75.519997 BDX"
"2010-11-30 77.930000 BDX"
"2010-12-31 84.519997 BDX"
"2011-01-31 82.949997 BDX"
"2011-02-28 80.000000 BDX"
"2011-03-31 79.620003 BDX"
"2011-04-29 85.940002 BDX"
"2011-05-31 87.550003 BDX"



Could you please tell me what to check?

Thanks so much

Darren

Comments

  • VidasMatelisVidasMatelis
    Hi Your first file (where you have quotes for each symbol) looks good.
    The second file does not look good. It has double quotes around the text in each line - that is not expected.

    PSData\Quotes.csv should look like this: 
    Date	Close	Symbol
2006-12-27	1.0000000001	* Cash
2014-10-07	37.34	CCL
2014-10-31	40.150002	CCL
    Did you open PSData\Quotes.csv with regular text editor? Do you have Header row in that file (first row)?
  • jagmanvdpjagmanvdp
    Good Morning:

    Here is what the top of the "quotes" excel file looks like in my system

    DateCloseSymbol
    2007-12-311.0000000001* Cash
    2007-12-3118.750000ALC
    2008-01-3110.810000ALC
    2008-02-2910.990000ALC
    2008-03-3110.260000ALC
    2008-04-309.130000ALC
    2008-05-3016.750000ALC

    The quote (") symbols are not really there.

    The words Date Close and Symbol are all in the same excel box....they are not in individual boxes.The expression 2007-12-311.000000001*Cash is all in A2
    The letters DateClose Symbol are all in A1



    Should the date be in A1 and the price in B1 and the symbol in C1

    If so,how do i change that?

    Thanks

    Darren
    .




  • VidasMatelisVidasMatelis
    Can you please check your psConfig.txt file - do you have these parameters set: 
    
Tab


# DecimalSeparator: Default value is . (dot), in some coutries this could be , (comma)

.
  • jagmanvdpjagmanvdp
    Hello

    Yes, confirmed that the psConfig file is set up as you have shown.......tab for column seperation and decimal default for decimal seperator.

    Darren
  • VidasMatelisVidasMatelis
    OK, can you please send me:
    1. psConfig.txt file
    2. All files from PSData folder.

    My email is posted on http://www.portfolioslicer.com/contact.html page.
  • VidasMatelisVidasMatelis
    Thanks for sending me your files.
    1. I opened .csv files in Notepad++ and all formats are OK
    2. There is no error.txt file in psData folder, so all files are OK.
    3. Schema.ini file is in psData folder, so that will allow data from this folder to be read into Excel.

    So next step that we have to confirm:
    Could you please confirm that files sent from the folder: c:\PortfolioSlicer\PSData\.
    If that is OK, then could you please send me your Excel workbook. For privacy, you can remove most of the transactions - leave just a few lines, but please confirm that you are getting same error with these few transaction lines.

    Thanks.
  • jagmanvdpjagmanvdp
    Good Day

    Ahhh....when i only include a few transactions in the transaction tab, the error does not come back. I was careful NOT to include transactions for items where I have to enter the data by hand (cdn mutual funds) I must have an error in those files somewhere. I will spend some time going over those entries to see if I can find the error.

    Thank you for helping me narrow it down

    Darren
Sign In or Register to comment.