PSYahooFinance

1.0.1

PSYahooFinance.psm1

function Get-YFStockQuote {
    # Author: Daniel Ferreira (@daniel0x00)
    # License: 0BSD

    <#
 
    .SYNOPSIS
        Downloads delayed Yahoo Finance Stock Market Quote data. Very basic and non-polished cmdlet.
 
    .EXAMPLE
        # Bitcoin-USD, 1d candles, -1year lookback.
        Get-YFStockQuote -Symbol BTC-USD -Range 1y
 
    .EXAMPLE
        # S&P-500 ETF, 5m candles, -1month lookback.
        Get-YFStockQuote -Symbol SPY -Interval 5m -Range 1mo
     
    .EXAMPLE
        # Apple stock, 2m candles, -40days from today lookback.
        Get-YFStockQuote -Symbol AAPL -Interval 2m -FromDate -40
 
    .OUTPUTS
        timestamp : 1606833000
        symbol : SPY
        interval : 5m
        open : 365.6
        high : 365.62
        low : 364.93
        close : 365.11
        volume : 3052904
 
        timestamp : 1606833300
        symbol : SPY
        interval : 5m
        open : 365.06
        high : 365.77
        low : 364.93
        close : 365.68
        volume : 944011
 
    #>   
    [CmdletBinding(DefaultParameterSetName='ByRange')]
    [OutputType([PSCustomObject])]
    param(    
        [Parameter(Position=0, Mandatory=$false, ValueFromPipeline=$true)]
        [string] $Symbol='SPY',

        # Candle size. '30m' is banned as it returns 60m candles. Possible TODO to anybody else to fix.
        [Parameter(Mandatory=$false, ValueFromPipeline=$false)]
        [ValidateSet("1m","2m","5m","15m","60m","90m","1h","1d","5d","1wk","1mo","3mo")]
        [string] $Interval='1d',

        # How far back it goes:
        [Parameter(Mandatory=$false, ValueFromPipeline=$false, ParameterSetName='ByRange')]
        [ValidateSet("1d","5d","1mo","3mo","6mo","1y","2y","5y","10y","ytd","max")]
        [string] $Range='5d',

        # How far back it goes, by date. Default is -30d:
        [Parameter(Mandatory=$false, ValueFromPipeline=$false, ParameterSetName='ByDate')]
        [int] $FromDate=([int](New-TimeSpan -Start (Get-Date '01/01/1970') -End (Get-Date).AddDays(-30).ToLocalTime()).TotalSeconds),

        # Till how far back it goes, by date. Default is -1d:
        [Parameter(Mandatory=$false, ValueFromPipeline=$false, ParameterSetName='ByDate')]
        [int] $ToDate=([int](New-TimeSpan -Start (Get-Date '01/01/1970') -End (Get-Date).AddDays(-1).ToLocalTime()).TotalSeconds),

        # Switch to skip candle size output.
        # By default is $false, thereby will be shown.
        # 'Interval' field is useful when all intervals are ingested as single file in a data warehouse platform.
        [Parameter(Mandatory=$false, ValueFromPipeline=$false)]
        [switch] $SkipIntervalOutput,

        # Yahoo Finance base URL:
        [Parameter(Mandatory=$false, ValueFromPipeline=$false)]
        [string] $UrlBase='https://query1.finance.yahoo.com/v8/finance/chart/'
    )

    switch ($PsCmdlet.ParameterSetName) {
        "ByRange" { $Url = [string]::concat($UrlBase, ("{0}?region=US&lang=en-US&includePrePost=false&interval={1}&range={2}&corsDomain=finance.yahoo.com&.tsrc=finance" -f $Symbol,$Interval,$Range) ) }
        "ByDate" { 
            # Received relative days:
            if ($FromDate -lt 0) { $FromDate = ([int](New-TimeSpan -Start (Get-Date '01/01/1970') -End (Get-Date).AddDays($FromDate).ToLocalTime()).TotalSeconds) }
            if ($ToDate -lt 0) { $ToDate = ([int](New-TimeSpan -Start (Get-Date '01/01/1970') -End (Get-Date).AddDays($ToDate).ToLocalTime()).TotalSeconds) }

            $Url = [string]::concat($UrlBase, ("{0}?region=US&lang=en-US&includePrePost=false&interval={1}&period1={2}&period2={3}&corsDomain=finance.yahoo.com&.tsrc=finance" -f $Symbol,$Interval,$FromDate,$ToDate) )
        }
    }
    Write-Verbose "[Get-YFStockQuote] Downloading $Symbol quotes from URL: $Url..."

    # Request builder:
    $WebRequestParameters = @{
        Uri = $Url
        Method = 'Get'
        Headers = @{
            "Accept"="*/*"
            "User-Agent"="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
        }
    }

    $WebRequest = Invoke-RestMethod @WebRequestParameters -ErrorAction Stop

    # Output:
    if ($null -ne $WebRequest) { 
        $Output = 1..($WebRequest.chart.result[0].timestamp.count) | Select-Object `
            @{n='timestamp';e={ $WebRequest.chart.result[0].timestamp[($_-1)] }}, `
            @{n='symbol';e={ $Symbol }}, `
            @{n='interval';e={ $Interval }}, `
            @{n='open';e={ [System.Math]::Round($WebRequest.chart.result[0].indicators.quote[0].open[($_-1)],2) }}, `
            @{n='high';e={ [System.Math]::Round($WebRequest.chart.result[0].indicators.quote[0].high[($_-1)],2) }}, `
            @{n='low';e={ [System.Math]::Round($WebRequest.chart.result[0].indicators.quote[0].low[($_-1)],2) }}, `
            @{n='close';e={ [System.Math]::Round($WebRequest.chart.result[0].indicators.quote[0].close[($_-1)],2) }}, `
            #@{n='adjclose';e={ [System.Math]::Round($WebRequest.chart.result[0].indicators.adjclose[0].adjclose[($_-1)],2) }}, `
            @{n='volume';e={ [System.Math]::Round($WebRequest.chart.result[0].indicators.quote[0].volume[($_-1)],2) }}
        
        # Output:
        if ($SkipIntervalOutput) { $Output | Select-Object -ExcludeProperty interval }
        else { $Output }
    }
}