Currency converter example

This example illustrates how to use Google Sheets to implement a simple currency converter.

Disclaimer: Quotes are not sourced from all markets and may be delayed. Information is provided ‘as is’ and solely for informational purposes, not for trading purposes or advice.

    Source code for this form:

    <label>I want to convert:
    [spreadsheet_dropdown buying sheet:1 cells:A1-A12 include_blank "https://docs.google.com/spreadsheets/d/1LIXUU7Jc91H4M-hMayAhpbaHjG_NxIltgEkjeR3ZD2w/edit?usp=sharing"]</label>
    
    <label>Amount:
    [number* qty "1"]</label>
    
    [calculate_button "Calculate"]
    
    <label>Rate:
    [spreadsheet_reference price field:buying sheet:1 cells:A1-B12 "https://docs.google.com/spreadsheets/d/1LIXUU7Jc91H4M-hMayAhpbaHjG_NxIltgEkjeR3ZD2w/edit?usp=sharing"]</label>
    
    <label>Total:
    [calculation result precision:2 "price * qty"]</label>