|
|
Post by cyrilmadrid on Jul 13, 2014 8:38:16 GMT
Hello. Has any one managed to automatically link to AC's page for loan book management ?
|
|
|
|
Post by Ton ⓉⓞⓃ on Jul 13, 2014 12:10:26 GMT
Hello. Has any one managed to automatically link to AC's page for loan book management ? For the uninitiated, like me, can you explain what that means?
|
|
|
|
Post by cyrilmadrid on Jul 13, 2014 15:06:10 GMT
Ton ⓉⓞⓃ, I am trying to establish an automated link between AC's webpage and Excel, so that I can perform in Excel the calculations I cannot get directly on AC's page : total of accrued interest, weighted average interest rate, histograms of principal amount per interest rate... Currently I do it by manually exporting the loan book, then transforming it in a pivot table, but I wonder if anyone managed to automate the process.
|
|
|
|
Post by chris on Jul 14, 2014 18:08:39 GMT
DDL. Direct dynamic link. A Microsoft mechanism where every time you load up the spreadsheet, it would automatically retrieve information from databases, files and/or web sites in order to update itself and the ultimately the information presented on the spreadsheet. And not currently support other than being a web page so if Microsoft or someone else has capability to screen scrape then be our guests. Total accrued interest and other new metrics are being included in the site rebuild.
|
|
