myskydog

/**
 * HedgeDog Options API - Simplified Custom Functions
 * @author HedgeDog Excel Lab
 * @version 1.0.0
 */

/**
 * Simple test function
 * @customfunction
 * @param input Test input

myskydog

/**
 * HedgeDog Options API - Custom Functions for Excel
 * @author HedgeDog Excel Lab
 * @version 1.0.0
 */

/**
 * Simple test function to verify custom function registration
 * @customfunction
 * @param input Test input value

myskydog

/**
 * HedgeDog Options API - Custom Functions for Excel
 * @author HedgeDog Excel Lab
 * @version 1.0.0
 */

/**
 * Fetches options chain data from HedgeDog API
 * @customfunction
 * @param {string} symbol Stock symbol (e.g., "AAPL")

myskydog

/**
 * HedgeDog Options API - Excel Script Lab
 * Fetch options chain data from HedgeDog API
 *
 * API: http://localhost:8000/api/options/chain/{symbol}
 * Parameters: strikes_around, strike_min, strike_max, expiry_start, expiry_end
 */

function main(workbook: ExcelScript.Workbook) {
  // Configuration - modify these values

myskydog

name: HedgeDog Options API
description: Fetch options chain data from HedgeDog API with comprehensive filtering
author: HedgeDog Excel Lab
version: 2.0.0

functions:
  - name: FETCH_OPTIONS_CHAIN
    description: Fetches options chain data with full parameter support
    parameters:
      - name: symbol

myskydog

name: BatchTest
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));
    function transpose(matrix) {
      return matrix[0].map((col, i) => matrix.map(row => row[i]));
    }

myskydog

name: GenOrders
description: Generate orders from monitor panel
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));
    OfficeExtension.config.extendedErrorLogging = true;
    async function run() {
      await Excel.run(async (context) => {

myskydog

name: Scenario Analyse
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    async function test() {
      await Excel.run(async (context) => {

myskydog

name: Trading Tools
description: Pair trading tools
host: EXCEL
api_set: {}
script:
  content: >
    $("#CP-preview").click(() => tryCatch(callPutParityOrderPreview));

    $("#FS-preview").click(() => tryCatch(spotFutOrderPreview));

myskydog

name: SkydogFn
description: Skydog Data functions
host: EXCEL
api_set: {}
script:
  content: >
    declare var moment: any;


    function apiDispatch(apiName: string) {