Data in PS Data files not right

ervfuchs

I can get the Portfolio Slicer to work I think, but when I look at the Quotes.csv file it displays neither tab or comma delimited. The data looks like this "2016-10-204.09FTR" and it is all in one cell. When I set the psConfig.txt file to "comma" instead if "tab" then it will display the data in the Quotes.csv file as tab delimited, but then Portfolio Slicer does not run. It says the files columns are not correct. So then when I go into Power Pivot and try to assign columns for Quotes it says there is not connection to the file. What might I have wrong with this file? I have the schema.ini in the PS Data folder.

VidasMatelis

Could you please send me your all files in PSData folder and psConfig.txt file? I have not see problem you reported yet. My email is posted on the this page: http://www.portfolioslicer.com/contact.html

VidasMatelis

Hi,

Thanks for sending me your files. All your files are correct - they have proper TAB symbol between columns. You probably are opening these files in Excel and Excel does not show TAB separated values in separate columns. to confirm you can try to open these files in notepad (select file, right mouse click, then "Open With" and you will see that values have special TAB symbol between.
You said PowerPivot says "there is not connection to the file" - that is different problem. By default PS expect that these csv file will be in the folder c:\PortfolioSlicer\PSData. If you have full PowerPivot support, you can change external data location: http://portfolioslicer.com/docs/excel2013-change-data-location.html
So please confirm that files you created are in the same folder where PowerPivot is pointing too.

ervfuchs

Hi Vidas,
Yes I see the tabs now when I open in notepad. So the tabs were there all the time I just did not see them in the Excel csv file. I also then changed the default for opening .csv files to notepad. W ith that change the file in PowerPivot is also tab whereas before it was comma separated. So now even my 150 positions and 330 transactions PowerSlicer is working beautifully.
Thanks much!

ervfuchs

Hi Vidas,
I for the life of me can't get rid of the circular dependency error, "'Trans'[CostBasisimpactRpt3],'Trans'[CostBasisimpactRpt3],'Trans'[CBBuyToDateRpt3],'Trans'[CBCycleNo],'Trans'[CostBasisimpactRpt3]". I checked for all no sells before buys, also no negative shares total, and took out divTA transactions. I am still using vers 2.3. Could you check out my workbook?

VidasMatelis

ervfuchs - Yes, please send me your workbook and all files from PSData folder, so I could refresh it.
My email is posted on this page: http://www.portfolioslicer.com/contact.html

VidasMatelis

I received your workbook. I believe the solution is very simple - in srcTrans worksheet, you added extra column "Column1" - please delete that column and you should be able to refresh workbook.

ervfuchs

Vidas, That did the trick. I am able to refresh. Thanks so much.
Ervfuchs