{"id":18677,"date":"2025-07-24T17:16:39","date_gmt":"2025-07-24T21:16:39","guid":{"rendered":"https:\/\/nycphantom.com\/journal\/?p=18677"},"modified":"2025-08-06T14:39:56","modified_gmt":"2025-08-06T18:39:56","slug":"googlefinance-and-embedding-google-sheets-in-html","status":"publish","type":"post","link":"http:\/\/nycphantom.com\/journal\/?p=18677","title":{"rendered":"GoogleFinance and Embedding Google Sheets in HTML"},"content":{"rendered":"\n<p>With <strong>GoogleFinance <\/strong><a href=\"https:\/\/support.google.com\/docs\/answer\/3093281?hl=en\">function<\/a> in <strong>GoogleSheets<\/strong>, I get to publish all kinds of data pertaining to stock market prices and currency exchange rates. I just found out this cool feature today. It can be <a href=\"https:\/\/support.google.com\/sites\/thread\/228945185\/embed-specific-range-from-spreadsheet?hl=en\">embedded<\/a> using iframe. A <a href=\"https:\/\/newsitesguide.pjrprojects.co.uk\/embedding-content\/google-sheets-1\/google-sheets-htmlembed\">very strait forward<\/a> method.<\/p>\n\n\n\n<p><strong>Example<\/strong>: Currency Rates I created in my Google Spreadsheet, <strong>with USD as Base, for the last 30 days<\/strong>, this values are live upon every loading of this page:<\/p>\n\n\n\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/1R1hXf5ujELUvj8ltpiGDjG6qjZlPAP5ObgiEyR8xp7I\/htmlembed?single=true&gid=0&range=A4:E13&widget=FALSE&chrome=FALSE&headers=FALSE\" title=\"Currency Rate Charts\" width=\"630\" height=\"400\"><\/iframe>\n\n\n\n<p>and Stock Market:<\/p>\n\n\n\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/18jk26XUQceR5POWESTjmxdAEEoMzJk9ozGFLn5sZ7BA\/htmlembed?single=true&gid=0&range=A2:G30&widget=FALSE&chrome=FALSE&headers=FALSE\" title=\"Stock Market Charts\" width=\"650\" height=\"400\"><\/iframe>\n","protected":false},"excerpt":{"rendered":"<p>With GoogleFinance function in GoogleSheets, I get to publish all kinds of data pertaining to stock market prices and currency exchange rates. I just found out this cool feature today. It can be embedded using iframe. A very strait forward &hellip; <a href=\"http:\/\/nycphantom.com\/journal\/?p=18677\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-18677","post","type-post","status-publish","format-standard","hentry","category-computer-science"],"_links":{"self":[{"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/posts\/18677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18677"}],"version-history":[{"count":7,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/posts\/18677\/revisions"}],"predecessor-version":[{"id":18822,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/posts\/18677\/revisions\/18822"}],"wp:attachment":[{"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18677"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}