Duplicate quotes for Friday the 13th

Comments

• VidasMatelis

  March 14

  I am confirming that this is a problem for me too.
  I will investigate and will post here when I know solution.
• VidasMatelis

  March 14

  Please download the updated scripts from the Download page.
  Update script:
  Scripts\GetQuotes-Yahoo.ps1 - updated code fixes the issue if Yahoo provides duplicate quotes.
  
  Additional scripts:
  Scripts\deduplicate-currExch.ps1
  Scripts\deduplicate-quotes.ps1
  deduplicate.bat
  
  If you already have duplicate issues, please download updated scripts, copy these 4 files to the corresponding folders (note that .bat files go to the folder above Scripts), and then run deduplicate.bat.
  
  
  
• dstirling

  March 14

  Hi Vidas
  
  Your fix worked perfectly! As always, your work is greatly appreciated.
• earcandy90

  March 21

  I had this duplicate issue on March 20, 2026 quote updates. I downloaded the updated scripts above, but now I'm getting this error when I run the Excel batch update?
  
  
  
• VidasMatelis

  March 21 edited March 21

  @earcandy90
  Sorry about this - I updated GetExcelSrdData script with version provided by another user here. Old script version was using OleDB to read data from Excel, new version is using PowerShell ImportExcel module.
  
  To solve this, you will have to do import of the model manually.
  
  Can you please follow steps bellow and
  
  Step 1: Start a Command Prompt as Administrator
  Open the Windows Start menu, search for cmd, right-click Command Prompt, and choose Run as administrator.
  
  Start Command Prompt as administrator
  
  Administrative privileges may be required depending on how your system is configured and which execution-policy scope you use.
  
  Then, in the Command Prompt window, type PowerShell and press Enter. This will start PowerShell.
  
  Step 2: Run the Required PowerShell Commands
  From the command prompt or PowerShell window, check the current policy run 2 statements:
  
  Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass -Force;
  Import-Module ImportExcel -ErrorAction Stop;
  
  Step 3: Exit from PowerShell and Cmd
  Type the following command:
  
  exit
  
  This will exit PowerShell. Then type the same command again to exit Command Prompt.
  
  
  
  
  
  Please let me know if that fixes your issue.
• earcandy90

  March 22

  Thanks Vidas. I tried the above, and I'm getting a separate error after entering the second PowerShell command:
  
  
  
  
• VidasMatelis

  March 22

  @earcandy90
  Can you please try this command instead:

  Install-Module -Name ImportExcel -Scope AllUsers
  
• earcandy90

  March 22

  Thanks @VidasMatelis!
  
  In case helpful, I had to acknowledge a couple items after that command:
  
  
  
  Now getting a new error:
  
  
  
  
• VidasMatelis

  March 22

  Thank you, that is helpful.
  Can you please post here screenshot of your source.xlsx file, Transactions tab, just a Date column. Please first sort transactions table by date, and then please post a screenshot of just dates around date 2014-01-31
  
• earcandy90

  March 22

  Really appreciate your help @VidasMatelis!
  
  
  
  
• VidasMatelis

  March 22

  Thank you.
  
  Your data looks good. Can you please re-download scripts and extract them to temporary folder. Then confirm that script GetExcelSrcData.ps1 has todays updated date and copy that script over to your script location and re-run your script.
  I added much more logic to handle dates.
  Please let me know if that fixed your issue.
• earcandy90

  March 22

  So sorry Vidas - I'm still getting the same error, even after downloading/extracting new scripts and replacing the one you mentioned:
  
  
  
• VidasMatelis

  March 22

  I want to figure out what is happening.
  This code if beeing fixed not by me, but by ChatGPT. ChatGPT keeps asking me to provide row transactions data, as it suspects 2 possible scenarios:
  
  - $row.Date is actually a string with hidden characters, or
  - the column has mixed Excel storage types across rows.
  
  For now, I uploded updated script. Can you please download it again, confirm that now the date for the script is later than 8:41am (your screenshot) and try again?
  
  
• earcandy90

  March 22

  I updated the script, but the same error.
  
  I don't really know what I'm doing, but I tried changing all the transactions I have with date 2014-01-31 to 2014-01-30, and re-ran the updates.
  The error changed slightly - not sure if this is helpful:
  
  
• VidasMatelis

  March 22

  Could you send me PortfolioSlicer-Source.xlsx workbook. My email is posted on "Contact Us" page.
  But, before you send it, could you copy that workbook to another file, then from there in Transactions tab delete all values from TransType, TransSubType, SymbolName, Qty, Price, Fee, ExchRate, CostBasisOverrride columns - these columns should be empty (to protect your data privacy). I just need all your transactions records with just Date column.