Release Notes


28 March 2020
1.48

  • Yahoo Finance: New formulas for mutual funds: Top holdings and Sector Weightings


13 March 2020
1.48

  • Yahoo Finance: fix historic date formula.


11 March 2020
1.47

  • Maintenance Release.


10 March 2020
1.46

  • IG Index: Added '1 second' option to historical price download.


6 March 2020
1.45

  • IG Index: Added trade history download.


4 March 2020
1.44

  • Added new Yahoo Finance Array Formula: HistoricLookbackDailyWeeklyMonthly


14 February 2020
1.43

  • Added functions and screen for downloading IG Index watchlists.


11 February 2020
1.42

  • Fix for Yahoo Finance historic function array: date adjustment.


5 February 2020
1.41

  • Fix for the new IG Index historic sentiment function.


4 February 2020
1.40

  • New IG Index historic sentiment function.


31 Janurary 2020
1.39

  • Maintenance release to fix issue with batched live prices.


30 Janurary 2020
1.38

  • New Yahoo Finance formulas for stock options: Strike, ExpireDate and UnderlyingTicker (the Add-in already provides Bid and Ask prices).


28 Janurary 2020
1.37

  • Major upgrade to improve performance and stability.
  • Added more Yahoo Finance functions including EBITDA, PEG Ratio and Book Value.


22 Janurary 2020
1.36

  • Added more Yahoo Finance functions including analyst target price data and more dividend options.


14 Janurary 2020
1.35

  • Added more Yahoo Finance functions for annual financial data: income statement, balance sheet and cash flow.


9 December 2019
1.34

  • Added more Yahoo Finance functions for Exchange-Traded Funds (ETFs).


7 November 2019
1.32

  • New Yahoo Finance functions for Exchange-Traded Funds (ETFs).
  • Improved performance of Yahoo Finance historical data.


7 November 2019
1.31

  • New IG Index historical client sentiment download functionality.


8 October 2019
1.30

  • Added Excel formula for historic data download (daily/weekly/monthly).


4 October 2019
1.29

  • Added new historic data download option (daily/weekly/monthly).


2 October 2019
1.28

  • Added Yahoo Finance formulas for industry, sector, country and city.


1 October 2019
1.27

  • Added more Yahoo Finance income summary functions.


30 September 2019
1.26

  • Added historic adjusted close function.


30 September 2019
1.25

  • Added more Yahoo Finance fundamental data functions (for balance sheet and income statement).


26 September 2019
1.24

  • Added next announcement date Excel functions.


22 August 2019
1.23

  • Encrypt IG Index password (for IG Singapore).


16 July 2019
1.22

  • Fix Yahoo Finance historic holiday data.


14 July 2019
1.21

  • Now compatible with Excel 2007.


23 June 2019
1.20

  • New Yahoo Finance Functions for revenue, earnings, shares outstanding, beta etc.


21 June 2019
1.19

  • New Yahoo Finance Functions: EPF.Yahoo.TrailingAnnualDividendYield and EPF.Yahoo.TrailingAnnualDividendRate


21 June 2019
1.18

  • New IG Index Function: EPF.IG.VBA.Positions


4 June 2019
1.17

  • New Yahoo Finance Historic Lookback functions.
  • Auto sheet refresh (1min and 5mins).
  • Yahoo Finance symbol shortcut button.


15 May 2019
1.16

  • New Yahoo Finance Historic Data Excel and VBA functions.


15 May 2019
1.15

  • Yahoo Finance Historical Data: High, Low, Open, Close, Volume.


10 May 2019
1.14

  • New IG Index trading functions: CloseAllPositions, ClosePosition, ClosePositions and ClosePartialPosition.


6 May 2019
1.13

  • New IG Index trading functions: ClosePosition and DeleteAllWorkingOrders.
  • New IG Index dealing rules functions such as MinimumDealSize, MinimumStopOrLimitDistance etc.


10 April 2019
1.12

  • New Yahoo Finance VBA functions.


23 March 2019
1.11

  • Add IG Index account formulas (streaming and non-streaming).


18 March 2019
1.10

  • Add IG Index client sentiment VBA functions.


12 March 2019
1.9

  • Add IG Index client sentiment formulas.
  • Add new IG Index fields: margin factor, name, country, etc.
  • Improve IG Index VBA trading functions, check confirmation.


1 March 2019
1.8

  • Fix activation code check issue.


26 February 2019
1.7

  • Enable separate IG Index CFD and Spreadbet streaming subscriptions.
  • Improve error reporting on logon failure.


21 February 2019
1.6

  • Option to switch IG Index accounts.
  • New VBA WorkingOrder function.


18 February 2019
1.5

  • Fixes for switching between IG Index demo and live accounts.


13 February 2019
1.4

  • Added more Yahoo Finance functions.


5 February 2019
1.3

  • New Feature: Download IG Index Account Positions.


3 February 2019
1.2

  • New Feature: IG Index historic data download.
  • New VBA functions for retrieving IG Index live prices and historic data.
  • Bug fix: un-subscribing from streaming epics now working.


21 January 2019
1.1

  • IG Index: Added NewMarketOrder Excel function.


10 January 2019
1.0

  • First version released.