Live Time in Spreadsheets
Financial modeling often requires knowing the market time in London, New York, or Tokyo. You can pull live API data directly into Google Sheets using a simple script.
JAVASCRIPT
/**
* Fills the cell with current time from API
* Usage: =GET_API_TIME("Europe/London")
*/
function GET_API_TIME(timezone) {
var url = "https://time.now/developer/api/timezone/" + timezone;
var response = UrlFetchApp.fetch(url);
var json = JSON.parse(response.getContentText());
return json.datetime;
}Why use Time.Now for Productivity?
- Live market data sync
- Custom functions in Sheets
- Supports all IANA timezones