I desire to create a spreadsheet (Financial Balance Sheet) that once opened would automatically link to my bank account and credit card accounts, and automatically download any transactions that have occurred since the last update. It allow a very quick accounting of my financial statement. It’s probably obvious that I am not a proficient spreadsheet user, but I would like to know it this concept is possible.
Can I create a spreadsheet that will allow me to link websites and pull data directly from the site? I'm thinking about financial statements from different types of accounts.
What you are asking for is somewhat of a tall order. This is for many reasons the least not being that each access may be different in both what and how the information is available. Even proceeding from there, I’m not sure you can do this without some programming (macros) most likely using Python as a language.
Now even after that there may be another method for you. Most financial institutions give the capability of downloading current (or maybe previous) transactions in cvs (comma separated data file) format. This can be imported into your spreadsheet with very little effort. You can then start with that as a basis. What you set up and what is to be accomplished is going to be the design portion you would need to complete. You should check out the LO Templates to see if anything fits your needs - click here.
If this answers your question please click on the (upper left area of answer).