Thank you for these links and suggestions. I have had a look through and to me it does not appear to provide me with a way to gather the information I am seeking. But that may be a product of my lack of technical coding abilities and understandings.
My thoughts were simply to access both of the websites containing the two contracts of interest via a HTTP connection out of Calc based on the criteria I have prescribed.
Is this not possible to set up automatically via a macro script written in the appropriate language as I can certainly do these actions manually using the two website addresses above? But I would need to do tis some 220 times to gather the addresses then another 220 times submitting those qualified addresses to the second contract to find their holding amount then add them all together. My need for this macro is to provide proof that my calculations in several spreadsheets I have done are actually factual and accurate. The aggregate total will provide the number I need to prove or disprove my other calculations in these spreadsheets.
is the AI code I posted anywhere near being able to do this with some adjustments and corrections?