Can run Scripts now but ,

Comments

• VidasMatelis

  June 2016 edited June 2016

  Updated.
  There are 2 issues I see based on your error message:
  1. You need to update PowerShell on your PC. Use following link: https://www.microsoft.com/en-us/download/details.aspx?id=34595. Download the correct package for your operating system and architecture.
  
  Windows 7 Service Pack 1
  64-bit versions: Windows6.1-KB2506143-x64.msu
  32-bit versions: Windows6.1-KB2506143-x86.msu
  
  2. You most likely did not unblock zip files, so you are getting extra security warning. To remove security warning:
  - Unblock each .ps1 file and .bat file (right mouse click, then check "Unblock").
  - Delete existing files (keep copy of psConfig.txt), then re-download zip files, unblock and then unzip.
  
  
• lemonyx

  June 2016

  Thank you for the help. I'll try it again
• KLZ

  September 2016

  I have this same problem in running script and getting the additional security warning. I have since unblock all the .ps1 files.
  
  However, I am not totally clear about the second part of 2. in your solution. Do you mean I have to delete all the .txt data files generated? And do I download again all the data management scripts and files associated?
  
  I have another problem which I will just post here. If this is inappropriate, I will start a new post.
  
  I have successfully added transactions, mostly dividend transactions. Everything appears ok until I added a third currency, MYR - Malaysian Ringgit (initially, I only had USD and SGD). Then I get this error when I update on the Holding Sheet. Please see attached image.
  
  Your help would be greatly appreciated. Thanks.

  2016-09-15.png 34.3K
• VidasMatelis

  September 2016

  KLZ,
  
  Second question part 2 was an option - you either unblock each .ps1 file, either you re-download zip, unblock zip and then extract .ps1 file. As you unblocked each .ps1 file - you are good to go.
  
  I am not sure about your error, could you please send me your workbook and all files from PSData folder - I'll investigate. My email is posted on this page: http://www.portfolioslicer.com/contact.html
  
  
  
• KLZ

  September 2016

  Vidas, many thanks! I want to fully use PortfolioSlicer and eventually use the Power BI version. I will send you all the files via email as requested for your investigation.
• VidasMatelis

  September 2016

  Hi KLZ,
  
  In srcTrans worksheet cell A1 you accidentally renamed column "Account" to "9.5". Because of this you cannot refresh data. Just rename column back and refresh your data.
  
  Regards,
  
• KLZ

  September 2016

  Vidas,
  Many thanks for the trouble-shooting and the quick response as well. It solves my problem! Very careless of me to have changed the header name. I noticed that while the calculation now proceeds successfully when I do a 'refresh all' of the data, I still have a red cell (in the currency column - which has value of MYR which I have bolded below) in srcSymbol tab as in the following:
  
  3255.KL Heineken Malaysia Berhad MYR 0.00% MYR Broad
  
  While it does not seems to cause any problems, I am not sure if this will result in any reporting error elsewhere.
  
  Best Regards,
  
  K L Teh
  
• VidasMatelis

  September 2016

  That Red currency cell in srcSymbol worksheet is not a problem at all - it is my bug with formatting. I have a rule that checks if curency exists in Report Currency table and if it does not, then color that cell in red. But in report currency table I check just first 3 rows and I supposed to check more rows. To fix this:
  1. Select any cell inside srcSymbol table, then Home->Conditioanl Formatting->Manage Rules
  2. Select rule that says "Applies to" and values "=$C$2:$C:?" and then click "Edit Rule..." above.
  3. Very carefully edit rule (delete or back my add code to rule, so pay attention):
  Change rule from

  =AND(COUNTIF(src!$N$5:$N$6, C2)=0, LOWER(C2)<> "cash")

  To:

  =AND(COUNTIF(src!$N$5:$N$9, C2)=0, LOWER(C2)<> "cash")
• KLZ

  September 2016

  Vidas, once again, thanks! That fixes the red cell.