Embedded Files
For Bhavcopy- Library ID: 1cmVq19QtpJi6-08npjPBIQXc6F_anajNt8l6JNaQciy2qfyVJ80k95K0
/**
* Fetches and parses CSV data from a given URL.
* @param {string} url The URL of the CSV file.
* @return {Array} Parsed CSV data as an array of arrays.
* @customfunction
*/
function getcsvdata(url) {
return premiumFunction.getcsvdata(url);
}
/**
* Fetches a ZIP file from a given URL, extracts a specific CSV file from it,
* and parses the CSV data.
* @param {string} url The URL of the ZIP file.
* @param {number} zipFileNumber The index of the CSV file within the ZIP (e.g., 0 for the first file).
* @return {Array} Parsed CSV data as an array of arrays.
* @customfunction
*/
function getzipcsvdata(url, zipFileNumber) {
return premiumFunction.getzipcsvdata(url, zipFileNumber);
}
/**
* Fetches data from a website table and returns it as a 2D array.
* @param {string} url The URL of the website containing the table.
* @param {number} lenthofcolumn The expected length of each row (number of columns).
* @return {Array} Parsed table data as a 2D array.
* @customfunction
*/
function getwebdata(url, lenthofcolumn) {
return premiumFunction.getwebdata(url, lenthofcolumn);
}
For Option Chain- Library ID: 1cmVq19QtpJi6-08npjPBIQXc6F_anajNt8l6JNaQciy2qfyVJ80k95K0
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [
{ name: "Refresh", functionName: "getFromWeb" },
{ name: "Start", functionName: "start" },
{ name: "Stop", functionName: "stop" }
];
ss.addMenu("📊Option Chain Tools", menuEntries);
}
function getFromWeb() {
premiumFunction.getFromWeb();
}
function start() {
premiumFunction.start();
}
function stop() {
premiumFunction.stop();
}
Google Sites
Report abuse