Research-Agent.ps1

function Save-JsonToExcel {
    <#
    .SYNOPSIS
    Saves a JSON string to an Excel file.
    .PARAMETER Json
    The JSON string to save.
    .PARAMETER Path
    The path to save the Excel file to.
    #>
    param(
        [string]$Json,
        [string]$Path
    )

    $Json | ConvertFrom-Json | Export-Excel -Path $Path -AutoSize

    Write-Output "Saved JSON to Excel file: $Path"
}

$Tools = Register-Tool Save-JsonToExcel, Export-Excel
$Tools += $(
    New-StockTickerTool
    New-TavilyAITool
)

$Instructions = @"
Date: $(Get-Date)

Path: $PSScriptRoot\Research-Summary-$((get-date).ToString("yyyyMMddhhmmss")).xlsx

This agent will do the research and generate a JSON summary. The JSON summary will be saved in an Excel file.

Only output the final file it is saved to.
"@

$agent = New-Agent -Name 'Research Agent' -Tools $Tools -Instructions $Instructions -ShowToolCalls

$agent | Get-AgentResponse @"
What did IBM, GM, Microsoft, Google, Meta, and Exxon close at and a news item for each
Include stock info for each
Each line should be a different stock
Each line should have a 25 word news summary
"@

Install-Module PSAI
Install-Module ImportExcel

.\Research-Agent.ps1