{"id":2490,"date":"2026-05-08T17:21:54","date_gmt":"2026-05-08T08:21:54","guid":{"rendered":"https:\/\/blue-water.pgw.jp\/wordpress\/?p=2490"},"modified":"2026-05-08T19:57:50","modified_gmt":"2026-05-08T10:57:50","slug":"gnucash%e3%81%a7%e6%97%a5%e6%9c%ac%e6%a0%aa%e3%81%ae%e6%a0%aa%e4%be%a1%e3%82%92%e8%87%aa%e5%8b%95%e5%8f%96%e5%be%97%e3%81%99%e3%82%8b%ef%bc%88postgresql%ef%bc%86perl%e9%80%a3%e6%90%ba%ef%bc%89","status":"publish","type":"post","link":"https:\/\/blue-water.pgw.jp\/wordpress\/2026\/05\/08\/gnucash%e3%81%a7%e6%97%a5%e6%9c%ac%e6%a0%aa%e3%81%ae%e6%a0%aa%e4%be%a1%e3%82%92%e8%87%aa%e5%8b%95%e5%8f%96%e5%be%97%e3%81%99%e3%82%8b%ef%bc%88postgresql%ef%bc%86perl%e9%80%a3%e6%90%ba%ef%bc%89\/","title":{"rendered":"GnuCash\u3067\u65e5\u672c\u682a\u306e\u682a\u4fa1\u3092\u81ea\u52d5\u53d6\u5f97\u3059\u308b\uff08PostgreSQL\uff06Perl\u9023\u643a\uff09"},"content":{"rendered":"<h1 style=\"font-size: 2em; font-weight: 900; line-height: 1.3; border-left: 6px solid #e74c3c; padding-left: 0.6em; margin-bottom: 1em;\">GnuCash\u3067\u65e5\u672c\u682a\u306e\u682a\u4fa1\u3092\u81ea\u52d5\u53d6\u5f97\u3059\u308b\uff08PostgreSQL\uff06Perl\u9023\u643a\uff09<\/h1>\n<h2>GnuCash\u306e\u682a\u4fa1\u53d6\u5f97\u554f\u984c\u3068\u306f<\/h2>\n<p>\u65e5\u672c\u306e\u682a\u4fa1\u306e\u53d6\u5f97\u306f\u9577\u3089\u304f<br \/>\n<a href=\"http:\/\/liosk.blog103.fc2.com\/blog-entry-185.html\">http:\/\/liosk.blog103.fc2.com\/blog-entry-185.html<\/a><br \/>\n<a href=\"https:\/\/github.com\/LiosK\/Finance--Quote--YahooJapan\">https:\/\/github.com\/LiosK\/Finance&#8211;Quote&#8211;YahooJapan<\/a><br \/>\n\u306b\u304a\u4e16\u8a71\u306b\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u3002GUI,CLI\u3068\u3082\u53d6\u5f97\u3067\u304d\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u00a0<code>gnucash-cli --quotes get<\/code>\u00a0\u3067\u306f\u3042\u308b\u30d0\u30fc\u30b8\u30e7\u30f3\u304b\u3089\u53d6\u5f97\u3067\u304d\u306a\u304f\u306a\u308a\u307e\u3057\u305f\u3002\u3053\u308c\u306f GnuCash \u304c\u5185\u90e8\u3067\u300cyahoo_japan\u300d\u3068\u3044\u3046\u30c7\u30fc\u30bf\u6e90\u3092\u8a8d\u8b58\u3057\u3066\u3044\u306a\u3044\u305f\u3081\u3067\u3059\u3002<\/p>\n<h2>\u306a\u305c\u3053\u3093\u306a\u3053\u3068\u304c\u8d77\u304d\u308b\uff1f<\/h2>\n<p>GnuCash \u306e GUI\u7248\u3067\u306f\u521d\u671f\u5316\u9806\u5e8f\u304c\u7570\u306a\u308b\u305f\u3081\u52d5\u4f5c\u3057\u307e\u3059\u304c\u3001CLI\u7248\u3067\u306f\u672a\u77e5\u306e\u30c7\u30fc\u30bf\u6e90\u3092\u30b9\u30ad\u30c3\u30d7\u3057\u3066\u3057\u307e\u3044\u307e\u3059\u3002\u3064\u307e\u308a\u3001CLI \u3067yahoo_japan\u3092\u4f7f\u7528\u3059\u308b\u306b\u306f\u3001\u5225\u306e\u30eb\u30fc\u30c8\u3067\u30c7\u30fc\u30bf\u3092\u96c6\u3081\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n<h2>\u89e3\u6c7a\u7b56\uff1aFinance::Quote \u3067\u76f4\u63a5 DB \u306b\u66f8\u304d\u8fbc\u3080<\/h2>\n<p>GnuCash-CLI \u3092\u4f7f\u308f\u305a\u3001Perl \u306e <code>Finance::Quote<\/code> \u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u4f7f\u3063\u3066\u3001PostgreSQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u76f4\u63a5\u682a\u4fa1\u3092\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002\u3053\u306e\u65b9\u6cd5\u306a\u3089 yahoo_japan \u3092CLI\u304b\u3089\u3082\u4f7f\u3048\u3066\u554f\u984c\u3092\u56de\u907f\u3067\u304d\u3001Windows\u30fbUbuntu \u306e\u4e21\u74b0\u5883\u3067\u52d5\u4f5c\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" style=\"max-width: 100%; border-radius: 4px; margin: 20px 0;\" src=\"https:\/\/blue-water.pgw.jp\/wordpress\/wp-content\/uploads\/2026\/05\/671610c5b6849e47ad4a67be296f2e4f.png\" alt=\"GnuCash\u682a\u4fa1\u53d6\u5f97\u30b9\u30af\u30ea\u30d7\u30c8\u5b9f\u884c\u753b\u9762\" \/><\/p>\n<h2>\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u624b\u9806<\/h2>\n<p><strong>\u3010Windows \u306e\u5834\u5408\u3011<\/strong><\/p>\n<ul>\n<li>Strawberry Perl \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/li>\n<li>\u30b9\u30af\u30ea\u30d7\u30c8\u5185\u306e DB\u63a5\u7d9a\u5148\uff08PostgreSQL IP\uff09\u3092\u78ba\u8a8d<\/li>\n<li>\u74b0\u5883\u5909\u6570 <code>ALPHAVANTAGE_API_KEY<\/code>\u3001<code>FQ_CURRENCY<\/code> \u3092\u8a2d\u5b9a<\/li>\n<li>Perl \u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c<\/li>\n<\/ul>\n<p><strong>\u3010Ubuntu \u306e\u5834\u5408\u3011<\/strong><\/p>\n<ul>\n<li><code>libdbi-perl<\/code>\u3001<code>libdbd-pg-perl<\/code> \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/li>\n<li><code>Finance::Quote<\/code> \u3092 CPAN \u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/li>\n<li>\u30b9\u30af\u30ea\u30d7\u30c8\u3092 <code>\/usr\/local\/bin\/<\/code> \u306b\u914d\u7f6e <div class='w3eden'><!-- WPDM Link Template: Default Template -->\n\n<div class=\"link-template-default card mb-2\">\n    <div class=\"card-body\">\n        <div class=\"media\">\n            <div class=\"mr-3 img-48\"><img decoding=\"async\" class=\"wpdm_icon\" alt=\"\u30a2\u30a4\u30b3\u30f3\" src=\"https:\/\/blue-water.pgw.jp\/wordpress\/wp-content\/plugins\/download-manager\/assets\/file-type-icons\/zip.svg\" \/><\/div>\n            <div class=\"media-body\">\n                <h3 class=\"package-title\"><a href='https:\/\/blue-water.pgw.jp\/wordpress\/download\/yahoo_japan%e3%82%92%e7%94%a8%e3%81%84%e3%81%a6gnucash-db%e3%81%ab%e7%99%bb%e9%8c%b2\/'>yahoo_japan\u3092\u7528\u3044\u3066GNUCASH DB\u306b\u767b\u9332<\/a><\/h3>\n                <div class=\"text-muted text-small\"><i class=\"fas fa-copy\"><\/i> 1 \u30d5\u30a1\u30a4\u30eb <i class=\"fas fa-hdd ml-3\"><\/i> 1.44 KB<\/div>\n            <\/div>\n            <div class=\"ml-3\">\n                <a class='wpdm-download-link download-on-click btn btn-primary ' rel='nofollow' href='#' data-downloadurl=\"https:\/\/blue-water.pgw.jp\/wordpress\/download\/yahoo_japan%e3%82%92%e7%94%a8%e3%81%84%e3%81%a6gnucash-db%e3%81%ab%e7%99%bb%e9%8c%b2\/?wpdmdl=2499&refresh=6a28a04c52c7e1781047372\">\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/a>\n            <\/div>\n        <\/div>\n    <\/div>\n<\/div>\n\n<\/div><\/li>\n<li>crontab \u3067\u7279\u5b9a\u6642\u523b \u306b\u81ea\u52d5\u5b9f\u884c\u3059\u308b\u3088\u3046\u8a2d\u5b9a<\/li>\n<\/ul>\n<h2>\u6ce8\u610f\u70b9<\/h2>\n<ul>\n<li><strong>\u65e5\u672c\u682a\u30b7\u30f3\u30dc\u30eb<\/strong>\uff1a\u300c7203.T\u300d\u3067\u306f\u306a\u304f\u300c7203\u300d\uff084\u6841\uff09\u3067\u6307\u5b9a<\/li>\n<li><strong>Alpha Vantage \u306e\u5236\u9650<\/strong>\uff1a\u7121\u6599\u67a0\u306f 1\u65e5 25\u30ea\u30af\u30a8\u30b9\u30c8\u307e\u3067<\/li>\n<li><strong>GnuCash \u306e DB \u30ed\u30c3\u30af<\/strong>\uff1aGUI\u7248\u3092\u8d77\u52d5\u3057\u306a\u304c\u3089\u3067\u306f\u52d5\u4f5c\u3057\u307e\u305b\u3093\u3002\u30b9\u30af\u30ea\u30d7\u30c8\u5b9f\u884c\u6642\u306f GUI \u3092\u9589\u3058\u3066\u304f\u3060\u3055\u3044<\/li>\n<\/ul>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>GnuCash \u3068 PostgreSQL\u3001Perl \u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u65e5\u672c\u682a\u3092\u542b\u3080\u3042\u3089\u3086\u308b\u8cc7\u7523\u306e\u682a\u4fa1\u3092\u81ea\u52d5\u53d6\u5f97\u30fb\u66f4\u65b0\u3067\u304d\u307e\u3059\u3002\u4e00\u5ea6\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3059\u308c\u3070\u3001cron\u7b49\u3067\u6bce\u65e5\u81ea\u52d5\u3067\u6700\u65b0\u306e\u4fa1\u683c\u60c5\u5831\u304c DB \u306b\u53cd\u6620\u3055\u308c\u308b\u305f\u3081\u3001\u7ba1\u7406\u304c\u3088\u308a\u6b63\u78ba\u306b\u306a\u308a\u307e\u3059\u3002Windows\u30fbLinux \u4e21\u5bfe\u5fdc\u306a\u306e\u3067\u3001\u3069\u306e\u3088\u3046\u306a\u74b0\u5883\u3067\u3082\u5c0e\u5165\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<div class=\"ad\"><a href=\"https:\/\/px.a8.net\/svt\/ejp?a8mat=4B3G6I+45FTMA+5W12+5ZU29\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www22.a8.net\/svt\/bgt?aid=260501418251&amp;wid=001&amp;eno=01&amp;mid=s00000027479001007000&amp;mc=1\" alt=\"\" width=\"300\" height=\"250\" border=\"0\" \/><\/a><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www11.a8.net\/0.gif?a8mat=4B3G6I+45FTMA+5W12+5ZU29\" alt=\"\" width=\"1\" height=\"1\" border=\"0\" \/><\/div>\n","protected":false},"excerpt":{"rendered":"<p>GnuCash\u3067CLI\u7d4c\u7531\u306e\u65e5\u672c\u682a\u53d6\u5f97\u304c\u5931\u6557\u3059\u308b\u554f\u984c\u3092Perl+Finance::Quote+PostgreSQL\u3067\u89e3\u6c7a\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[27,36],"tags":[141,137,138,139,140,142],"class_list":["post-2490","post","type-post","status-publish","format-standard","hentry","category-pc","category-36","tag-financequote","tag-gnucash","tag-perl","tag-postgresql","tag-140","tag-142"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/posts\/2490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/comments?post=2490"}],"version-history":[{"count":2,"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/posts\/2490\/revisions"}],"predecessor-version":[{"id":2502,"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/posts\/2490\/revisions\/2502"}],"wp:attachment":[{"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/media?parent=2490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/categories?post=2490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blue-water.pgw.jp\/wordpress\/wp-json\/wp\/v2\/tags?post=2490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}