東証銘柄の株価を取得してGoogleスプレッドを更新する

import { FinanceApi, quote } from './finance-api';
export class Yahoo extends FinanceApi {

    constructor(symbols: Map<string, string[]>) {
        super(symbols);
    }

    public quotes(market: string): Promise<quote>[] {
        return (this.symbols.get(market) ?? [])
            .map((symbol: string) => this.latestQuote({ market, symbol }));
    }

    private async latestQuote({ market, symbol }: { market: string; symbol: string; }): Promise<quote> {
        var yahooFinance = require('yahoo-finance');
        var suffix: string = market === "TSE" ? ".T" : "";
        return yahooFinance.quote(
            {
                symbol: symbol + suffix,
                modules: ['price']
            }).then((quotes: any) => {
                var price = quotes.price;
                var quote: quote = {
                    symbol: symbol,
                    name: price.shortName,
                    longName: price.longName,
                    open: price.regularMarketOpen,
                    high: price.regularMarketDayHigh,
                    low: price.regularMarketDayLow,
                    close: price.regularMarketPrice,
                    closeYest: price.regularMarketPreviousClose,
                    volume: price.regularMarketVolume,
                    ccy: price.currency,
                };
                return quote;
            });
    }
}

public update(quote: quote): void {
    var range: string = quote.symbol + "!G3";
    var param: sheets_v4.Params$Resource$Spreadsheets$Values$Update = {
        spreadsheetId: this.spreadsheetid,
        range: range,
        valueInputOption: "RAW",
        requestBody: {
            majorDimension: "ROWS",
            range: range,
            values: [[quote.close]]
        }
    };
    this.spreadSheets
        .values
        .update(param)
        .then(result => result.status);
    }