如何从网站提取银行对账单?

发布于 2024-10-31 05:12:08 字数 174 浏览 8 评论 0原文

我需要从多个不同来源提取银行账户对账单。我希望能够以某种标准化方式获取这些数据,无论是 CSV、OFX、XML 还是其他格式。我只需要能够获取这些数据。我将使用我自己的帐户来获取交易,因此那里应该不会有太多“法律”问题。 Mint.com 等网站如何获取银行对账单?他们只是询问您的帐户信息、URL,然后就可以开始运行了。我该怎么做?

I need to pull bank account statements from a number of different sources. I'd love to be able to get this data in some sort of standardized fashion, be it CSV or OFX or XML or whatever. I just need to be able to get this data. I'll be using my own account to grab transactions from, so there shouldn't be too many 'legal' problems there. How do sites like Mint.com get bank statements? They simply ask for your account information, the URL, and then they're off and running. How can I do this?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(5

金橙橙 2024-11-07 05:12:09

用您最喜欢的语言编写一个屏幕抓取工具来完成此操作。将其自动化。

通常,银行可以通过其在线服务为您提供最多三个月的交易。

当屏幕抓取失败时,不要忘记让它按下紧急按钮。

这里的要点是使其自动化,这样(手动运行它)的痛苦就会消失,这样您所看到的就是“不断”更新的帐户交易。

Write a screen scraper in your favorite language to do it. Automate it away.

Normally banks give you access up to three months of transactions via their online services.

Don't forget to make it push the panic button when the screen scraping fails.

The main point here is to automate it so that the pain (of running it manually) goes away so that all you see are "constantly" updated transactions of your accounts.

浮光之海 2024-11-07 05:12:09

如果您对简单的个性化解决方案感兴趣,一种简单的方法是让 Mint 汇总您的所有购买内容并使用现有的抓取工具来下载它们。像这样的东西:https://github.com/mrooney/mintapi

If you're interested in a simple, personal solution, one easy way would have Mint aggregate all your purchases and use an existing scraper to download them. Something like this: https://github.com/mrooney/mintapi.

三月梨花 2024-11-07 05:12:09

您可以考虑的其他主要内容是 格子 (更多商业产品,但看起来真的很好)和 https://www.buxfer.com 它有一个免费的 api。最近的薄荷让刮刀更难刮掉它。

The other main things you may consider is Plaid (more commercial product but looks really good) And https://www.buxfer.com which has a free api. Mint as of late has made it harder for scrapers to scrape it.

落墨 2024-11-07 05:12:09

获取您的交易并将其保存为 XLS 的 CSV,以便使用 iCreateOFX Basic v4 转换为 OFX 和 /QIF或者尝试 v5 beta

Grab your transactions and save them to CSV of XLS to convert to OFX and / QIF using iCreateOFX Basic v4 or try the v5 beta.

人事已非 2024-11-07 05:12:09

我不久前读过一篇关于此的综合技术文章,但是我找不到它。根据我的记忆,这是 mint 从您的银行获取数据的做法:

  1. 从该公司查询 API: http://www.finappstore .com/
  2. 如果银行不在上述 API 中,它们会回退到屏幕抓取

I read a comprehensive technical article on this awhile ago, however, I can't find it. From my memory this is what mint does to get data from your bank:

  1. Query API from this company: http://www.finappstore.com/
  2. If bank isn't in above API they fallback to screen scraping
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文