Getting Started
- Introduction
- Download
- Installation & Activation
- Troubleshooting
- Data Refresh/Updates
- Software Updates
- Manage Your Subscription
- Example Spreadsheets
General Formulas
Technical Analysis Toolkit
- Introduction
- Simple Moving Average (SMA)
- Exponential Moving Average (EMA)
- Volume Weighted Average Price (VWAP)
- Average True Range (ATR)
- Bollinger Bands
- Aroon
Federal Reserve Economic Data
(FRED)
Yahoo Finance
IG Index / IG Markets
- Account Setup
- Formula Reference
- VBA Functions Reference
- Historical Price Data Download To Excel
- Historical Price Data Download To File
- Historical Client Sentiment Data Download
- Watchlists
- Live Positions, Transactions & Activity History
EODHistoricalData.com
Nasdaq Data Link
Miscellaneous Formulas
Excel Price Feed currently includes one additional formula which is neither data provider nor instrument specific.
As we add more useful formuals to the software we will document them here.
EPF.Dates.UTCToLocal
This formula is used to convert from a UTC (Coordinated Universal Time) date/time to a local date/time.
Most of the date/times used throughout the Add-in are in UTC format and this formula is useful for converting any UTC date/time to the date/time in the timezone of your PC/Excel.
For example, the formula below will convert a UTC time of 14:44 (in cell E2) to the local time on my PC, in this case 17:44 (currently a 3 hour offset):
=EPF.Dates.UTCToLocal(E2)
This formula, like any regular Excel formula, can take another formula as input.
For example we can use the regular market time fomrula (in UTC) as an input to this formula to convert it to local time:
=EPF.Dates.UTCToLocal(EPF.Yahoo.RegularMarketTime("AAPL"))