{"id":741,"date":"2025-03-31T19:41:15","date_gmt":"2025-03-31T19:41:15","guid":{"rendered":"https:\/\/evgenytailov24.thkit.ee\/wp\/?page_id=741"},"modified":"2025-03-31T20:01:43","modified_gmt":"2025-03-31T20:01:43","slug":"googleappsscript-vahetuskursi-kontroll-google-finance-abil","status":"publish","type":"page","link":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/","title":{"rendered":"GoogleAppsScript: Vahetuskursi kontroll Google Finance abil"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\">Originaalne kood<\/pre>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\n\/\/ When this script is run, a trigger for executing &quot;checkCurrency&quot; function is installed.\nfunction setTrigger() {\n  const functionName = &quot;checkCurrency&quot;;\n  const trigger = ScriptApp.getScriptTriggers().find(t =&gt; t.getHandlerFunction() == functionName);\n  if (trigger) {\n    ScriptApp.deleteTrigger(trigger);\n  }\n  ScriptApp.newTrigger(functionName).timeBased().everyMinutes(10).create();\n}\n\nfunction checkCurrency() {\n  const threshold = ###; \/\/ Please set the the threshold value you want to check.\n  const ticker = &quot;CURRENCY:USDJPY&quot;; \/\/ Please set ticker you want to check.\n  const email = &quot;###&quot;; \/\/ Please set the email address you want to notice.\n\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheets()&#x5B;0];\n  const range = sheet.getRange(sheet.getLastRow() + 1, 1, 1, 2);\n  range.setFormulas(&#x5B;&#x5B;&quot;=NOW()&quot;, `=GOOGLEFINANCE(&quot;${ticker}&quot;)`]]);\n  range.offset(0, 0, 1, 1).setNumberFormat(&quot;yyyy\/MM\/dd H:mm:ss&quot;);\n  SpreadsheetApp.flush();\n  const values = range.getValues();\n  range.setValues(values);\n  if (values&#x5B;0]&#x5B;1] &gt; threshold) { \/\/ Or if you want to check when the current value is less than the threshold, please modify this to values&#x5B;0]&#x5B;1] &lt; threshold\n    MailApp.sendEmail({\n      to: email,\n      subject: `Report: Value is over the threshold (${threshold})`,\n      htmlBody: `&lt;p&gt;Current value is ${values&#x5B;0]&#x5B;1].toFixed(2)}.&lt;\/p&gt;&lt;p&gt;&lt;a href=&quot;${ss.getUrl()}&quot;&gt;Open Spreadsheet&lt;\/a&gt;`,\n    });\n  }\n}\n<\/pre><\/div>\n\n\n<ol class=\"wp-block-list\">\n<li><strong>setTrigger funktsioon<\/strong> <strong>eritelu<\/strong><\/li>\n<\/ol>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\nfunction setTrigger() {  \/\/ m\u00e4\u00e4rame funktsiooni nime, mille jaoks loome trigeri:\n  const functionName = &quot;checkCurrency&quot;;\n  const trigger = ScriptApp.getScriptTriggers().find(t =&gt; t.getHandlerFunction() == functionName); \/\/ kontrollime, kas triger juba eksisteerib:\n  if (trigger) {\n    ScriptApp.deleteTrigger(trigger); \/\/ kui triger on juba olemas, kustutame selle:\n  }\n  ScriptApp.newTrigger(functionName).timeBased().everyMinutes(10).create(); \/\/ loome uue trigeri, mis k\u00e4ivitab checkCurrency iga 10 minuti j\u00e4rel:\n}\n<\/pre><\/div>\n\n\n<p>2. <strong>checkCurrency funktsioon<\/strong> <strong>eritelu<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\nfunction checkCurrency() {\n  const threshold = ###; \/\/ v\u00e4\u00e4rtus, \u00fcletamise juhul saadetab e-kiri mailile\n  const ticker = &quot;CURRENCY:USDJPY&quot;; \/\/ vahetuskurss, mida soovite kontrollida\n  const email = &quot;###&quot;; \/\/ mail, kuhu saadetakse teavitus \u00fcletamise kohta\n\n  const ss = SpreadsheetApp.getActiveSpreadsheet(); \/\/ saab aktiivse arvutustabeli\n  const sheet = ss.getSheets()&#x5B;0]; \/\/ hangib esimese lehe praegusest arvutustabelist\n  const range = sheet.getRange(sheet.getLastRow() + 1, 1, 1, 2); \/\/ valib veergude A ja B esimese vaba rea \u200b\u200buute andmete kirjutamiseks\n  range.setFormulas(&#x5B;&#x5B;&quot;=NOW()&quot;, `=GOOGLEFINANCE(&quot;${ticker}&quot;)`]]); \/\/ sisestab lahtritesse praeguse kuup\u00e4eva\/kellaaja ja valuutakursi google finance&#039;ist\n  range.offset(0, 0, 1, 1).setNumberFormat(&quot;yyyy\/MM\/dd H:mm:ss&quot;); \/\/ m\u00e4\u00e4rab kuup\u00e4eva ja kellaaja formaadi esimesele lahtrile (veerg A)\n  SpreadsheetApp.flush(); \/\/ sunnib k\u00f5ik muudatused tabelis kohe rakenduma\n  const values = range.getValues(); \/\/ hangib just v\u00e4rskendatud vahemikust v\u00e4\u00e4rtused\n  range.setValues(values); \/\/ kirjutab saadud andmed uuesti \u00fcle, et salvestada ainult numbrilised v\u00e4\u00e4rtused (v\u00e4ltides valemeid)\n  if (values&#x5B;0]&#x5B;1] &gt; threshold) { \/\/ kontrollib, kas saadud v\u00e4\u00e4rtus \u00fcletab v\u00f5i v\u00e4hem kui m\u00e4\u00e4ratud piiri (threshold)\n    MailApp.sendEmail({ \/\/ kui v\u00e4\u00e4rtus \u00fcletab v\u00f5i v\u00e4hem kui piiri, saadab e-kirja teavituse\n      to: email, \/\/ e-kirja saaja aadress\n      subject: `Report: Value is over the threshold (${threshold})`, \/\/ e-kirja teema\n      htmlBody: `&lt;p&gt;Current value is ${values&#x5B;0]&#x5B;1].toFixed(2)}.&lt;\/p&gt;&lt;p&gt;&lt;a href=&quot;${ss.getUrl()}&quot;&gt;Open Spreadsheet&lt;\/a&gt;`, \/\/ e-kirja sisu koos praeguse v\u00e4\u00e4rtusega ja lingiga google tabelile\n<\/pre><\/div>\n\n\n<p><strong>On loodnud google tabel, kuhu iga 10 minutit on sisestatud valitud vahetuskurss<\/strong> <strong>ja kellaaeg.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"525\" height=\"503\" src=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38.png\" alt=\"\" class=\"wp-image-753\" style=\"width:394px;height:auto\" srcset=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38.png 525w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38-300x287.png 300w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38-150x144.png 150w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Teen v\u00e4ike muudatused originaalne koodile, et saada email.<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nfunction checkCurrency()\n  const threshold = 140; \/\/ saadan e-mail, kui valitud vahetuskurss on rohkem kui 140\n  const ticker = &quot;CURRENCY:USDJPY&quot;;\n  const email = &quot;evgeny.tailov@gmail.com&quot;; \n<\/pre><\/div>\n\n\n<p><strong>On v\u00f5imalik k\u00e4ivita funktsioon manuaalselt ka, kui ei tahad oodata 10 minutit or sinu valitud aega vahemik.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"115\" src=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-39.png\" alt=\"\" class=\"wp-image-755\" srcset=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-39.png 576w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-39-300x60.png 300w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-39-150x30.png 150w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>K\u00e4tte saanud e-mail teavitus<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"709\" height=\"614\" src=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-40.png\" alt=\"\" class=\"wp-image-756\" style=\"width:571px;height:auto\" srcset=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-40.png 709w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-40-300x260.png 300w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-40-150x130.png 150w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-40-600x520.png 600w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Tahan muuta kood nii, et teavitus saabub, kui v\u00e4\u00e4rtus on v\u00e4hem kui piir<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nfunction checkCurrency() {\n  const threshold = 200;  \/\/ saadan e-mail, kui valitud vahetuskurss on v\u00e4hem kui 200\n\nif (values&#x5B;0]&#x5B;1] &amp;lt; threshold)\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"692\" height=\"469\" src=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-41.png\" alt=\"\" class=\"wp-image-759\" style=\"width:559px;height:auto\" srcset=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-41.png 692w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-41-300x203.png 300w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-41-150x102.png 150w, https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-41-600x407.png 600w\" sizes=\"auto, (max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Originaalne kood 2. checkCurrency funktsioon eritelu On loodnud google tabel, kuhu iga 10 minutit on sisestatud valitud vahetuskurss ja kellaaeg. Teen v\u00e4ike muudatused originaalne koodile, et saada email. On v\u00f5imalik k\u00e4ivita funktsioon manuaalselt ka, kui ei tahad oodata 10 minutit or sinu valitud aega vahemik. K\u00e4tte saanud e-mail teavitus Tahan muuta kood nii, et teavitus&hellip;&nbsp;<a href=\"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">GoogleAppsScript: Vahetuskursi kontroll Google Finance abil<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"class_list":["post-741","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>GoogleAppsScript: Vahetuskursi kontroll Google Finance abil - Evgeny Tailov portfolio (EE)<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GoogleAppsScript: Vahetuskursi kontroll Google Finance abil - Evgeny Tailov portfolio (EE)\" \/>\n<meta property=\"og:description\" content=\"Originaalne kood 2. checkCurrency funktsioon eritelu On loodnud google tabel, kuhu iga 10 minutit on sisestatud valitud vahetuskurss ja kellaaeg. Teen v\u00e4ike muudatused originaalne koodile, et saada email. On v\u00f5imalik k\u00e4ivita funktsioon manuaalselt ka, kui ei tahad oodata 10 minutit or sinu valitud aega vahemik. K\u00e4tte saanud e-mail teavitus Tahan muuta kood nii, et teavitus&hellip;&nbsp;Read More &raquo;GoogleAppsScript: Vahetuskursi kontroll Google Finance abil\" \/>\n<meta property=\"og:url\" content=\"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/\" \/>\n<meta property=\"og:site_name\" content=\"Evgeny Tailov portfolio (EE)\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-31T20:01:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38.png\" \/>\n\t<meta property=\"og:image:width\" content=\"525\" \/>\n\t<meta property=\"og:image:height\" content=\"503\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\\\/\",\"url\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\\\/\",\"name\":\"GoogleAppsScript: Vahetuskursi kontroll Google Finance abil - Evgeny Tailov portfolio (EE)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/image-38.png\",\"datePublished\":\"2025-03-31T19:41:15+00:00\",\"dateModified\":\"2025-03-31T20:01:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\\\/#primaryimage\",\"url\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/image-38.png\",\"contentUrl\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/image-38.png\",\"width\":525,\"height\":503},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GoogleAppsScript: Vahetuskursi kontroll Google Finance abil\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/\",\"name\":\"Evgeny Tailov portfolio (EE)\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/evgenytailov24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GoogleAppsScript: Vahetuskursi kontroll Google Finance abil - Evgeny Tailov portfolio (EE)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/","og_locale":"et_EE","og_type":"article","og_title":"GoogleAppsScript: Vahetuskursi kontroll Google Finance abil - Evgeny Tailov portfolio (EE)","og_description":"Originaalne kood 2. checkCurrency funktsioon eritelu On loodnud google tabel, kuhu iga 10 minutit on sisestatud valitud vahetuskurss ja kellaaeg. Teen v\u00e4ike muudatused originaalne koodile, et saada email. On v\u00f5imalik k\u00e4ivita funktsioon manuaalselt ka, kui ei tahad oodata 10 minutit or sinu valitud aega vahemik. K\u00e4tte saanud e-mail teavitus Tahan muuta kood nii, et teavitus&hellip;&nbsp;Read More &raquo;GoogleAppsScript: Vahetuskursi kontroll Google Finance abil","og_url":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/","og_site_name":"Evgeny Tailov portfolio (EE)","article_modified_time":"2025-03-31T20:01:43+00:00","og_image":[{"width":525,"height":503,"url":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/","url":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/","name":"GoogleAppsScript: Vahetuskursi kontroll Google Finance abil - Evgeny Tailov portfolio (EE)","isPartOf":{"@id":"https:\/\/evgenytailov24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/#primaryimage"},"image":{"@id":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/#primaryimage"},"thumbnailUrl":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38.png","datePublished":"2025-03-31T19:41:15+00:00","dateModified":"2025-03-31T20:01:43+00:00","breadcrumb":{"@id":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/#primaryimage","url":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38.png","contentUrl":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-38.png","width":525,"height":503},{"@type":"BreadcrumbList","@id":"https:\/\/evgenytailov24.thkit.ee\/wp\/googleappsscript-vahetuskursi-kontroll-google-finance-abil\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/evgenytailov24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"GoogleAppsScript: Vahetuskursi kontroll Google Finance abil"}]},{"@type":"WebSite","@id":"https:\/\/evgenytailov24.thkit.ee\/wp\/#website","url":"https:\/\/evgenytailov24.thkit.ee\/wp\/","name":"Evgeny Tailov portfolio (EE)","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/evgenytailov24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=741"}],"version-history":[{"count":11,"href":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/741\/revisions"}],"predecessor-version":[{"id":761,"href":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/741\/revisions\/761"}],"wp:attachment":[{"href":"https:\/\/evgenytailov24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}