Howdy, Stranger!

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

Don't get any exchange rates

cg1cg1
edited April 2019 in Excel Workbook
Hi all,
I don't get any exchange rates.
Log:
-----
16:25:52 --- Starting script GetExchRates-YahooIntraday.ps1
Currency count: 3. MinDate: 2015-12-31
Requesting url: https://finance.yahoo.com/quote/EURUSD=X
CurrExch. From: EUR -> To: USD. Next date: 2015-12-31. Quote file: C:\PortfolioSlicer\CurrExch\EUR_USD.txt
Newer quote not found
Requesting url: https://finance.yahoo.com/quote/EURCHF=X
CurrExch. From: EUR -> To: CHF. Next date: 2015-12-31. Quote file: C:\PortfolioSlicer\CurrExch\EUR_CHF.txt
Newer quote not found
Requesting url: https://finance.yahoo.com/quote/USDEUR=X
CurrExch. From: USD -> To: EUR. Next date: 2015-12-31. Quote file: C:\PortfolioSlicer\CurrExch\USD_EUR.txt
Newer quote not found
Requesting url: https://finance.yahoo.com/quote/USDCHF=X
CurrExch. From: USD -> To: CHF. Next date: 2015-12-31. Quote file: C:\PortfolioSlicer\CurrExch\USD_CHF.txt
Newer quote not found
Requesting url: https://finance.yahoo.com/quote/CHFEUR=X
CurrExch. From: CHF -> To: EUR. Next date: 2015-12-31. Quote file: C:\PortfolioSlicer\CurrExch\CHF_EUR.txt
Newer quote not found
Requesting url: https://finance.yahoo.com/quote/CHFUSD=X
CurrExch. From: CHF -> To: USD. Next date: 2015-12-31. Quote file: C:\PortfolioSlicer\CurrExch\CHF_USD.txt
Newer quote not found
16:26:00 --- Finished. CurrExch Requested/Succeed/Failed: 0/0/6. Duration: 7 sec.. Date-Time:
-----

I'm using an new installation: PortfolioSlicer v2.4.08 with Excel 2016 and latest scripts (v.2.4.10).

Any idea?

Comments

  • You provided log for intraday exchange rate, for daily exchange rates script is GetExchRates-Stooq.ps1. But that script does not work properly for last few days, I contacted Maxim (script developer) and will post here when solution is found.
  • Hi Vidas, thanks for your information. I hope Maxim will get it fixed soon.
  • Hi cg1,

    At this point solution is - edit UpdatePsData.bat file and change lines:
    REM powershell -ExecutionPolicy Bypass .\Scripts\GetExchRates-ECB.ps1
    powershell -ExecutionPolicy Bypass .\Scripts\GetExchRates-Stooq.ps1
    
    to lines:
    powershell -ExecutionPolicy Bypass .\Scripts\GetExchRates-ECB.ps1
    REM powershell -ExecutionPolicy Bypass .\Scripts\GetExchRates-Stooq.ps1
    
    WIth this change exchange rates will come from European Bank and not from Stooq.
    I am told that Stooq fix is not trivial and not clear when it is going to be available.

    Regards,
  • HI Vidas,
    that workaround works fine.
    Thank you!
Sign In or Register to comment.