Python + requests example

These examples use the Investment Growth Calculator SureSheet and the Python requests module.

Simple example

import json
import requests

workbook_id = "abc7cbef-2491-4787-94f8-6542fab12a4e"
simulate_url = f"https://www.equalto.com/suresheet/api/v1/simulate/{workbook_id}"
query = {
    "inputs": json.dumps({"Sheet1": {"C6": 25000}}),
    "outputs": json.dumps({"Sheet1": ["C13"]}),
}
result = requests.get(simulate_url, query).json()

print(result)

Should print:

{'Sheet1': {'C13': 50783.31719489607}}

Advanced example with ranges

import json
import requests

workbook_id = "abc7cbef-2491-4787-94f8-6542fab12a4e"
simulate_url = f"https://www.equalto.com/suresheet/api/v1/simulate/{workbook_id}"
query = {
    "inputs": json.dumps({"Sheet1": {"C6": 25000}}),
    "outputs": json.dumps({"Sheet1": ["C13", "B14:C16"]}),
}
result = requests.get(simulate_url, query).json()

print(json.dumps(result, indent=4))

Should print:

{
    "Sheet1": {
        "C13": 50783.31719489607,
        "B14:C16": [
            [
                "   Initial investment amount:",
                25000.0
            ],
            [
                "   Additional contributions:",
                10500.0
            ],
            [
                "   Interest earned:",
                15283.31719489607
            ]
        ]
    }
}