SPB Git

Repository Public

FixtureTests.swift 2.2 KB 41 lines swift

1import Foundation2import Testing3import SheetCore4import FunctionsLookup56/// Reference cases generated by the scripts in `Generators/`: Microsoft Excel results (via the7/// ExcelFinancialFunctions test data), LibreOffice recalculations and independent Python computations.8@Suite struct ReferenceFixtureTests {9    @Test func lookupLibreOffice() throws { try Fixtures.check("lookup_lo", minimum: 800) }10    @Test func dynamicArrays() throws { try Fixtures.check("arrays", minimum: 290) }11    @Test func financial() throws { try Fixtures.check("financial", minimum: 4500) }12    @Test func securities() throws { try Fixtures.check("securities", minimum: 13000) }1314    /// Values computed by Excel itself.15    @Test func excelReference() throws {16        let (count, failures) = try Fixtures.run("excel_reference")17        #expect(count >= 68000, "fixture has only \(count) cases")18        var byFunction = [String: [String]]()19        for f in failures {20            let name = String(f.dropFirst().prefix { $0 != "(" })21            byFunction[name, default: []].append(f)22        }23        let summary = byFunction.sorted { $0.key < $1.key }.map { "\($0.key): \($0.value.count)\n" + $0.value.prefix(4).joined(separator: "\n") }24        #expect(failures.isEmpty, "\(failures.count) of \(count) Excel reference cases failed:\n\(summary.joined(separator: "\n"))")25    }2627    /// Excel's YEARFRAC results against the public day-count API.28    @Test func excelYearFractions() throws {29        let doc = try Fixtures.load("excel_reference")30        let rows = try #require(doc["yearfrac"] as? [[NSNumber]])31        #expect(rows.count > 1000)32        var failures = [String]()33        for row in rows {34            let basis = try #require(DayCount.Basis(rawValue: row[2].intValue))35            let got = DayCount.yearFraction(fromSerial: row[0].doubleValue, toSerial: row[1].doubleValue, basis: basis)36            if !near(got, row[3].doubleValue, 1e-11) { failures.append("\(row[0]) → \(row[1]) basis \(row[2]): got \(got), Excel \(row[3])") }37        }38        #expect(failures.isEmpty, "\(failures.count) of \(rows.count) YEARFRAC cases failed:\n\(failures.prefix(20).joined(separator: "\n"))")39    }40}41
Files main
Menu

Theme