Calls the GitHub API to get the star count for an org/user and repository.

StockOnline (1).EXCEL.yaml

name: StockOnline (1)
description: Calls the GitHub API to get the star count for an org/user and repository.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Gets the stock price online. Try =getStockOnline("FB")
     * @customfunction
     * @param symbol 
     */
    async function getStockOnline(symbol) {
      var API_KEY = "8KOBOUBTEF7RHR21";
      const requestURL = `https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=${symbol}&apikey=${API_KEY}`;

      const response = await fetch(requestURL);
      const data = await response.json();

      if (data.hasOwnProperty("Note")) {
        throw new Error("API limit reached");
      }

      if (data.hasOwnProperty("Error Message")) {
        throw new Error(data["Error Message"]);
      }

      let monthlyData = data["Monthly Time Series"];

      let dates = Object.keys(monthlyData);
      let a = data["Monthly Time Series"][dates[0]]["1. open"];

      //let a = dates.forEach(function(item) {
      //console.log(dates[0]);
      console.log(a);
      console.log(requestURL);
      return a;
      //console.log(["Monthly Time Series"][item]["1. open"]);
      //});
    }
  language: typescript
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js
  core-js@2.4.1/client/core.min.js