Skip to content

Latest commit

 

History

History

fx

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 
 
 

google-apps-scripts fx

A script to fetch exchange rates for the Armenian Dram and the EUR/USD from the European Central Bank as reference. The script calls the RSS feed from these central banks.

Graph

Requirements

clasp https://github.com/google/clasp

Google Account with "Google Apps Script API" enabled: @see https://script.google.com/u/2/home/usersettings

Installation

clasp login to create ~/.clasprc.json with credentials.

cd ./app/phy/fx/ && clasp create --type standalone --title "cpmForexRates"

Google Script projects cannot be nested, clasp will look the path upwards for a clasp.json file.

In Google Docs a spreadsheet needs to be created or selected and its ID from the URI configured in config.js. The script will create if they don't exist the sheets 'cba.am' and 'ecb' and write a header line. If sheets with these names already exist nothing will be done initially.

When (the javascript) is written with one's favorite editor it is pushed online with clasp push.

With Google Apps-Script triggers can be set to periodically fetch the data.

Updating

clasp push --force

Check trigger https://script.google.com/ which version is referenced!

Known Problems

google/clasp#224 (comment)

For versions created from clasp deployments, I cannot delete the version, reglardless of having removed all deployments.