{"id":8420,"date":"2026-01-20T10:54:14","date_gmt":"2026-01-20T08:54:14","guid":{"rendered":"https:\/\/ronco.co.il\/?p=8420"},"modified":"2026-04-14T17:26:37","modified_gmt":"2026-04-14T14:26:37","slug":"googlefinance-google-sheets","status":"publish","type":"post","link":"https:\/\/ronco.co.il\/?p=8420","title":{"rendered":"GOOGLE FINANCE &#038; Google Sheets"},"content":{"rendered":"<h1>GOOGLE FINANCE &amp; Google Sheets<\/h1>\n<p>\u05d9\u05d9\u05e9\u05d5\u05dd GOOGLE FINANCE \u05d1 Google Sheets \u05db\u05de\u05d5\u05d1\u05df \u05d1\u05e2\u05d9\u05e7\u05e8 \u05d1\u05ea\u05d7\u05d5\u05dd \u00a0\u05e9\u05d5\u05e7 \u05d4\u05d4\u05d5\u05df.<br \/>\n\u05d4\u05e4\u05e7\u05d5\u05d3\u05d5\u05ea \u05d4\u05de\u05d5\u05d1\u05d9\u05dc\u05d5\u05ea \u05e9\u05dc\u05d9 \u05d4\u05dd:<\/p>\n<p style=\"direction: ltr; text-align: left;\"><span style=\"font-size: 1.8rem;\">=GOOGLEFINANCE(B28 , &quot;name&quot;)<br \/>\n<\/span><span style=\"font-size: 1.8rem;\">\u00a0 \u05e9\u05dd \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05db\u05e9\u05d4\u05e1\u05d9\u05de\u05d5\u05dc \u05d4\u05d5\u05d0 \u05d1 B8<br \/>\n<\/span><\/p>\n<p style=\"direction: ltr;\">Example for Change %: =GOOGLEFINANCE(&quot;NASDAQ:GOOG&quot;, &quot;changepct&quot;)<br \/>\n\u05d0\u05d5<br \/>\n=GOOGLEFINANCE(&quot;NASDAQ:&quot;&amp;B9, &quot;changepct&quot;)<\/p>\n<p style=\"direction: ltr;\"><span style=\"font-size: 1.8rem;\">=SUM($C21\/$C$38)<br \/>\n<\/span><span style=\"font-size: 1.8rem;\">\u00a0\u05d0\u05d7\u05d5\u05d6 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1\u05e9\u05d5\u05d5\u05d9 \u05d4\u05db\u05dc\u05dc\u05d9 \u05e9\u05dc \u05d4\u05ea\u05d9\u05e7, \u05d7\u05dc\u05d5\u05e7\u05d4 \u05e9\u05dc \u05e9\u05d5\u05d5\u05d9 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1\u05e1\u05da \u05d4\u05db\u05dc \u05db\u05dc \u05d4\u05ea\u05d9\u05e7<\/span><\/p>\n<p style=\"direction: ltr;\">&#8211;<br \/>\n=GOOGLEFINANCE(B21, &quot;price&quot;)<br \/>\n\u05e9\u05e2\u05e8 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d4\u05d9\u05d5\u05dd<\/p>\n<p style=\"direction: ltr;\">&#8211;<br \/>\n=INDEX(GOOGLEFINANCE(B21,&quot;close&quot;,TODAY()-2,TODAY()-1),2,2)<br \/>\n\u05e9\u05e2\u05e8 \u05d4\u05e1\u05d2\u05d9\u05e8\u05d4 \u05d0\u05ea\u05de\u05d5\u05dc<\/p>\n<p style=\"direction: ltr;\">&#8211;<br \/>\n=(N21-INDEX(GOOGLEFINANCE(B21, &quot;price&quot;, EDATE(TODAY(), -12)), 2, 2))\/N21<br \/>\n\u05d0\u05d7\u05d5\u05d6 \u05d4\u05de\u05e0\u05d9\u05d4 \u05d1 12 \u05d7\u05d3\u05e9\u05d9\u05dd<\/p>\n<p style=\"direction: ltr;\">&#8211;<br \/>\n=SPARKLINE(INDEX(GOOGLEFINANCE($B21,&quot;price&quot;,EDATE(today(), -12),today()),,2),{&quot;charttype&quot;,&quot;line&quot;;&quot;color&quot;,&quot;green&quot;})<br \/>\n\u05d2\u05e8\u05e3 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1 12 \u05d7\u05d5\u05d3\u05e9\u05d9\u05dd<\/p>\n<p style=\"direction: ltr;\">&#8211;<br \/>\n=(N22-INDEX(GOOGLEFINANCE(B22, &quot;price&quot;, EDATE(TODAY(), -1)), 2, 2))\/N22<br \/>\n\u05e2\u05e8\u05da \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1 \u05e9\u05d1\u05d5\u05e2<\/p>\n<p style=\"direction: ltr;\">&#8211;<br \/>\n=(GOOGLEFINANCE(B21, &quot;price&quot;) \/ INDEX(GOOGLEFINANCE(B21, &quot;price&quot;, DATE(YEAR(TODAY())-1, 12, 31)), 2, 2)) \u2013 1<br \/>\n\u05d4\u05ea\u05e9\u05d5\u05d0\u05d4 \u05de\u05ea\u05d7\u05d9\u05dc\u05ea \u05e9\u05e0\u05d4<\/p>\n<h2 style=\"direction: ltr;\"><strong>ATR 150<\/strong><\/h2>\n<p style=\"direction: ltr;\">\u05d4\u05e9\u05d9\u05de\u05d5\u05e9 \u05d1-ATR \u05db\u05db\u05dc\u05d9 \u05dc\u05de\u05d3\u05d9\u05d3\u05ea \u05e2\u05d5\u05e6\u05de\u05d4 \u05d5\u05db\u05e0\u05d9\u05e1\u05d4 \u05dc\u05e2\u05e1\u05e7\u05d0\u05d5\u05ea \u05d4\u05d5\u05d0 \u05e6\u05e2\u05d3 \u05d7\u05db\u05dd \u05de\u05d0\u05d5\u05d3 \u05e9\u05de\u05d5\u05e1\u05d9\u05e3 \u05de\u05e9\u05de\u05e2\u05ea \u05dc\u05de\u05e1\u05d7\u05e8.<\/p>\n<p style=\"direction: ltr;\">=SORT(GOOGLEFINANCE(&quot;AMZN&quot;, &quot;all&quot;, TODAY()-300, TODAY(), &quot;DAILY&quot;), 1, FALSE)<br \/>\n\u05d0\u05d5<br \/>\n=GOOGLEFINANCE(&quot;CIBR&quot;, &quot;high&quot;, TODAY()-30, TODAY(), &quot;DAILY&quot;)<\/p>\n<p>\u05e0\u05d5\u05e1\u05d7\u05d4 \u05e9\u05de\u05ea\u05e8\u05d9\u05e2\u05d4 \u05dc\u05da \u05db\u05e9\u05d4\u05de\u05d7\u05d9\u05e8 \u05d4\u05e0\u05d5\u05db\u05d7\u05d9 \u05d7\u05d5\u05e6\u05d4 \u05e8\u05de\u05d4 \u05de\u05e1\u05d5\u05d9\u05de\u05ea \u05d1\u05d9\u05d7\u05e1 \u05dc-ATR<br \/>\n\u05de\u05e2\u05e8\u05db\u05ea \u05d4\u05ea\u05e8\u05e2\u05d4 \u05d0\u05d5 &quot;\u05d0\u05d9\u05ea\u05d5\u05ea&quot; \u05dc\u05db\u05e0\u05d9\u05e1\u05d4 \u05e9\u05de\u05d1\u05d5\u05e1\u05e1\u05ea \u05e2\u05dc \u05d4\u05de\u05d7\u05d9\u05e8 \u05d5\u05d4\u05ea\u05e0\u05d5\u05d3\u05ea\u05d9\u05d5\u05ea (ATR), \u05d0\u05e0\u05d7\u05e0\u05d5 \u05e0\u05e9\u05dc\u05d1 \u05d0\u05ea \u05d4\u05de\u05d7\u05d9\u05e8 \u05d1\u05d6\u05de\u05df \u05d0\u05de\u05ea \u05e2\u05dd \u05d7\u05d9\u05e9\u05d5\u05d1 \u05d4-ATR.<\/p>\n<p><strong>\u05d4\u05e6\u05e2\u05d4 \u05dc\u05de\u05d1\u05e0\u05d4 \u05e4\u05e9\u05d5\u05d8 \u05d1\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05e9\u05dc\u05da \u05e9\u05d9\u05d2\u05d9\u05d3 \u05dc\u05da \u05d0\u05dd \u05d4\u05de\u05d7\u05d9\u05e8 &quot;\u05d7\u05dd&quot; \u05dc\u05db\u05e0\u05d9\u05e1\u05d4:<\/strong><\/p>\n<p>1. \u05d7\u05d9\u05e9\u05d5\u05d1 \u05d4-ATR (\u05de\u05de\u05d5\u05e6\u05e2 14 \u05d9\u05d5\u05dd)<br \/>\n\u05e0\u05e9\u05d9\u05dd \u05d1\u05ea\u05d0 \u05d0\u05d7\u05d3 (\u05dc\u05de\u05e9\u05dc D1) \u05d0\u05ea \u05d7\u05d9\u05e9\u05d5\u05d1 \u05d4-ATR \u05d4\u05de\u05de\u05d5\u05e6\u05e2 \u05e9\u05dc \u05d4\u05e9\u05d1\u05d5\u05e2\u05d9\u05d9\u05dd \u05d4\u05d0\u05d7\u05e8\u05d5\u05e0\u05d9\u05dd \u05e2\u05d1\u05d5\u05e8 CIBR:<\/p>\n<p>=AVERAGE(ARRAYFORMULA(INDEX(GOOGLEFINANCE(&quot;CIBR&quot;, &quot;high&quot;, TODAY()-20, TODAY()),,2) &#8211; INDEX(GOOGLEFINANCE(&quot;CIBR&quot;, &quot;low&quot;, TODAY()-20, TODAY()),,2)))<\/p>\n<p>2. \u05de\u05d7\u05d9\u05e8 \u05e0\u05d5\u05db\u05d7\u05d9<br \/>\n\u05d1\u05ea\u05d0 E1 \u05e0\u05de\u05e9\u05d5\u05da \u05d0\u05ea \u05d4\u05de\u05d7\u05d9\u05e8 \u05d4\u05e0\u05d5\u05db\u05d7\u05d9:<br \/>\n=GOOGLEFINANCE(&quot;CIBR&quot;, &quot;price&quot;)<\/p>\n<p>3. \u05e0\u05d5\u05e1\u05d7\u05ea \u05d4&quot;\u05d0\u05d9\u05ea\u05d5\u05ea&quot; (\u05de\u05ea\u05d9 \u05dc\u05d4\u05d9\u05db\u05e0\u05e1?)<br \/>\n\u05db\u05d0\u05df \u05d0\u05ea\u05d4 \u05e6\u05e8\u05d9\u05da \u05dc\u05d4\u05d7\u05dc\u05d9\u05d8 \u05e2\u05dc \u05d4\u05d0\u05e1\u05d8\u05e8\u05d8\u05d2\u05d9\u05d4 \u05e9\u05dc\u05da. \u05d3\u05d5\u05d2\u05de\u05d4 \u05e0\u05e4\u05d5\u05e6\u05d4 \u05d4\u05d9\u05d0 \u05db\u05e0\u05d9\u05e1\u05d4 \u05db\u05d0\u05e9\u05e8 \u05d4\u05de\u05d7\u05d9\u05e8 \u05d4\u05e0\u05d5\u05db\u05d7\u05d9 \u05d2\u05d1\u05d5\u05d4 \u05de\u05de\u05d7\u05d9\u05e8 \u05d4\u05e1\u05d2\u05d9\u05e8\u05d4 \u05e9\u05dc \u05d0\u05ea\u05de\u05d5\u05dc \u05d1\u05d9\u05d5\u05ea\u05e8 \u05de-ATR \u05d0\u05d7\u05d3 (\u05de\u05d4 \u05e9\u05de\u05e2\u05d9\u05d3 \u05e2\u05dc \u05e4\u05e8\u05d9\u05e6\u05d4 \u05d7\u05d6\u05e7\u05d4).<\/p>\n<p>\u05d1\u05ea\u05d0 F1 \u05d4\u05d3\u05d1\u05e7 \u05d0\u05ea \u05d4\u05e0\u05d5\u05e1\u05d7\u05d4 \u05d4\u05d6\u05d5:<\/p>\n<p>=IF(E1 &gt; (INDEX(GOOGLEFINANCE(&quot;CIBR&quot;, &quot;close&quot;, TODAY()-5, TODAY()), 2, 2) + D1), &quot;\ud83d\udd25 \u05d0\u05d9\u05ea\u05d5\u05ea \u05db\u05e0\u05d9\u05e1\u05d4: \u05e4\u05e8\u05d9\u05e6\u05d4 \u05de\u05e2\u05dc ATR&quot;, &quot;\u05de\u05de\u05ea\u05d9\u05df&#8230;&quot;)<\/p>\n<p>\u05d0\u05d9\u05da \u05d6\u05d4 \u05e2\u05d5\u05d1\u05d3?<br \/>\n\u05d4\u05d7\u05dc\u05e7 \u05d4\u05e8\u05d0\u05e9\u05d5\u05df \u05d1\u05d5\u05d3\u05e7 \u05d0\u05dd \u05d4\u05de\u05d7\u05d9\u05e8 \u05e2\u05db\u05e9\u05d9\u05d5 (E1) \u05d2\u05d1\u05d5\u05d4 \u05de\u05de\u05d7\u05d9\u05e8 \u05d4\u05e1\u05d2\u05d9\u05e8\u05d4 \u05e9\u05dc \u05d0\u05ea\u05de\u05d5\u05dc.<\/p>\n<p>\u05d4\u05ea\u05d5\u05e1\u05e4\u05ea \u05e9\u05dc + D1 \u05de\u05d5\u05d5\u05d3\u05d0\u05ea \u05e9\u05d4\u05de\u05d7\u05d9\u05e8 \u05dc\u05d0 \u05e1\u05ea\u05dd \u05e2\u05dc\u05d4 \u05e7\u05e6\u05ea, \u05d0\u05dc\u05d0 \u05e2\u05d1\u05e8 \u05d0\u05ea \u05d4-ATR (\u05ea\u05e0\u05d5\u05d3\u05ea\u05d9\u05d5\u05ea \u05de\u05de\u05d5\u05e6\u05e2\u05ea). \u05d6\u05d4 \u05e2\u05d5\u05d6\u05e8 \u05dc\u05e1\u05e0\u05df &quot;\u05e8\u05e2\u05e9\u05d9\u05dd&quot; \u05d5\u05dc\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d9\u05e9 \u05e2\u05d5\u05e6\u05de\u05d4 \u05de\u05d0\u05d7\u05d5\u05e8\u05d9 \u05d4\u05de\u05d4\u05dc\u05da.<\/p>\n<p>\u05d8\u05d9\u05e4 :<br \/>\n\u05d0\u05dd \u05d0\u05ea\u05d4 \u05e8\u05d5\u05e6\u05d4 \u05dc\u05d4\u05d9\u05d5\u05ea \u05e9\u05de\u05e8\u05e0\u05d9 \u05d9\u05d5\u05ea\u05e8, \u05ea\u05d5\u05db\u05dc \u05dc\u05e9\u05e0\u05d5\u05ea \u05d0\u05ea \u05d4\u05e0\u05d5\u05e1\u05d7\u05d4 \u05dc-+ (D1 * 1.5). \u05d6\u05d4 \u05d0\u05d5\u05de\u05e8 \u05e9\u05d4\u05de\u05d7\u05d9\u05e8 \u05e6\u05e8\u05d9\u05da \u05dc\u05d6\u05e0\u05e7 \u05d1-1.5 \u05e4\u05e2\u05de\u05d9\u05dd \u05de\u05d4\u05ea\u05e0\u05d5\u05d3\u05ea\u05d9\u05d5\u05ea \u05d4\u05e8\u05d2\u05d9\u05dc\u05d4 \u05e9\u05dc\u05d5 \u05db\u05d3\u05d9 \u05e9\u05ea\u05e7\u05d1\u05dc \u05d4\u05ea\u05e8\u05e2\u05d4.<\/p>\n<p><a href=\"https:\/\/support.google.com\/docs\/answer\/3093281?hl=en\" target=\"_blank\" rel=\"noopener\">\u05d4\u05de\u05d9\u05dc\u05d5\u05df \u05e9\u05dc \u05d2\u05d5\u05d2\u05dc GOOGLEFINANCE \u00a0\u05d1\u05e7\u05d9\u05e9\u05d5\u05e8<\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>\u05d1\u05d5\u05e8\u05e1\u05d4 \u05d9\u05e9\u05e8\u05d0\u05dc\u05d9\u05ea \u05de\u05e0\u05d9\u05d5\u05ea \u05de\u05d9\u05e9\u05e8\u05d0\u05dc \u05d1-Google Sheets<\/strong><\/h2>\n<p>\u05d6\u05d5 \u05e1\u05d5\u05d2\u05d9\u05d4 \u05d8\u05db\u05e0\u05d9\u05ea \u05de\u05d5\u05db\u05e8\u05ea \u05db\u05e9\u05e2\u05d5\u05d1\u05d3\u05d9\u05dd \u05e2\u05dd \u05de\u05e0\u05d9\u05d5\u05ea \u05de\u05d9\u05e9\u05e8\u05d0\u05dc \u05d1-Google Sheets.<\/p>\n<p>\u05d4\u05e1\u05d9\u05d1\u05d4 \u05e9\u05d6\u05d4 \u05de\u05e8\u05d2\u05d9\u05e9 &quot;\u05e7\u05e9\u05d4&quot; \u05d4\u05d9\u05d0 \u05e9\u05d2\u05d5\u05d2\u05dc \u05de\u05e9\u05ea\u05de\u05e9\u05ea \u05d1\u05e1\u05d9\u05d5\u05de\u05d5\u05ea \u05e1\u05e4\u05e6\u05d9\u05e4\u05d9\u05d5\u05ea \u05dc\u05db\u05dc \u05d1\u05d5\u05e8\u05e1\u05d4 \u05d1\u05e2\u05d5\u05dc\u05dd. \u05e2\u05d1\u05d5\u05e8 \u05d4\u05d1\u05d5\u05e8\u05e1\u05d4 \u05dc\u05e0\u05d9\u05d9\u05e8\u05d5\u05ea \u05e2\u05e8\u05da \u05d1\u05ea\u05dc \u05d0\u05d1\u05d9\u05d1, \u05d4\u05e7\u05d9\u05d3\u05d5\u05de\u05ea \u05d4\u05d9\u05d0 \u05d1\u05d3\u05e8\u05da \u05db\u05dc\u05dc TLV: \u05d5\u05dc\u05d0 TA.<br \/>\n\u05d4\u05e0\u05d4 \u05d0\u05d9\u05da \u05ea\u05d5\u05db\u05dc \u05dc\u05d4\u05db\u05e0\u05d9\u05e1 \u05d0\u05ea \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05d1\u05e7\u05dc\u05d5\u05ea:<br \/>\n1. \u05d4\u05e0\u05d5\u05e1\u05d7\u05d4 \u05d4\u05e0\u05db\u05d5\u05e0\u05d4 \u05dc\u05de\u05e0\u05d9\u05d5\u05ea \u05d5\u05e0\u05d9\u05d9\u05e8\u05d5\u05ea \u05e2\u05e8\u05da \u05d1\u05d9\u05e9\u05e8\u05d0\u05dc \u05d1\u05de\u05e7\u05d5\u05dd \u05d4\u05e1\u05d9\u05de\u05d5\u05dc \u05dc\u05d1\u05d3\u05d5, \u05e6\u05e8\u05d9\u05da \u05dc\u05db\u05ea\u05d5\u05d1 \u05d0\u05ea \u05d6\u05d4 \u05db\u05da \u05d1\u05ea\u05d5\u05da \u05d4\u05e0\u05d5\u05e1\u05d7\u05d4:<br \/>\n=GOOGLEFINANCE(&quot;TLV:SYMBOL&quot;)<\/p>\n<p>2. \u05e8\u05e9\u05d9\u05de\u05ea \u05e1\u05d9\u05de\u05d5\u05dc\u05d9\u05dd \u05dc\u05d3\u05d5\u05d2\u05de\u05d4 (\u05e9\u05ea\u05e2\u05d6\u05d5\u05e8 \u05dc\u05d5 \u05dc\u05d4\u05ea\u05d7\u05d9\u05dc): \u05ea&quot;\u05d0 125: \u05d4\u05e1\u05d9\u05de\u05d5\u05dc \u05d4\u05d5\u05d0 TLV:TA125.\u00a0\u05ea&quot;\u05d0 35: \u05d4\u05e1\u05d9\u05de\u05d5\u05dc \u05d4\u05d5\u05d0 TLV:TA35.<br \/>\n<strong>\u05d1\u05e0\u05e7\u05d9\u05dd<\/strong>:\u00a0\u05dc\u05d0\u05d5\u05de\u05d9: TLV:LUMI ,\u00a0\u05d4\u05e4\u05d5\u05e2\u05dc\u05d9\u05dd: TLV:POLI,\u00a0\u05d3\u05d9\u05e1\u05e7\u05d5\u05e0\u05d8: TLV:DSCT<br \/>\n<strong>\u05de\u05e0\u05d9\u05d5\u05ea \u05d1\u05d5\u05dc\u05d8\u05d5\u05ea \u05d0\u05d7\u05e8\u05d5\u05ea:\u00a0<\/strong>\u05d0\u05dc\u05d1\u05d9\u05d8 \u05de\u05e2\u05e8\u05db\u05d5\u05ea (\u05d4\u05de\u05e7\u05d1\u05d9\u05dc\u05d4 \u05dc-ESLT \u05e9\u05dc\u05da): TLV:ESLT,\u00a0\u05e0\u05d9\u05d9\u05e1: TLV:NICE ,\u00a0\u05d0\u05d9\u05d9.\u05e1\u05d9.\u05d0\u05dc (ICL): TLV:ICL<br \/>\n3. \u05d0\u05d9\u05da \u05dc\u05de\u05e6\u05d5\u05d0 \u05e1\u05d9\u05de\u05d5\u05dc \u05dc\u05d0 \u05de\u05d5\u05db\u05e8?<br \/>\n\u05d0\u05dd \u05d9\u05e9 \u05dc\u05d5 \u05de\u05e0\u05d9\u05d4 \u05e9\u05d4\u05d5\u05d0 \u05dc\u05d0 \u05de\u05d5\u05e6\u05d0, \u05e4\u05e9\u05d5\u05d8 \u05d7\u05e4\u05e9\u05d5 \u05d1\u05d2\u05d5\u05d2\u05dc: &quot;\u05e9\u05dd \u05d4\u05de\u05e0\u05d9\u05d4 + Google Finance&quot;. \u05d1\u05ea\u05d5\u05e6\u05d0\u05d4 \u05d4\u05e8\u05d0\u05e9\u05d5\u05e0\u05d4 \u05d9\u05d5\u05e4\u05d9\u05e2 \u05d4\u05e1\u05d9\u05de\u05d5\u05dc \u05d4\u05de\u05d3\u05d5\u05d9\u05e7 \u05e9\u05d2\u05d5\u05d2\u05dc \u05de\u05db\u05d9\u05e8\u05d4 \u05d1\u05d5 (\u05dc\u05de\u05e9\u05dc: TLV:AZRG \u05dc\u05e2\u05d6\u05e8\u05d9\u05d0\u05dc\u05d9).<\/p>\n<p>\u05d8\u05d9\u05e4 \u05e7\u05d8\u05df: \u05d0\u05dd \u05e8\u05d5\u05d1 \u05d4\u05ea\u05d9\u05e7 \u05d1\u05d9\u05e9\u05e8\u05d0\u05dc, \u05d4\u05d0\u05e7\u05e1\u05dc \u05e9\u05dc\u05da \u05d9\u05db\u05d5\u05dc \u05dc\u05d4\u05d9\u05d5\u05ea \u05e7\u05e8\u05d9\u05d8\u05d9 \u05db\u05d3\u05d9 \u05dc\u05e8\u05d0\u05d5\u05ea \u05d0\u05ea \u05d4\u05ea\u05de\u05d5\u05e0\u05d4 \u05d4\u05db\u05d5\u05dc\u05dc\u05ea (\u05e9\u05e7\u05dc\u05d9\u05dd \u05de\u05d5\u05dc \u05d3\u05d5\u05dc\u05e8\u05d9\u05dd). \u05d0\u05e4\u05e9\u05e8 \u05dc\u05d4\u05d5\u05e1\u05d9\u05e3 \u05ea\u05d0 \u05d0\u05d7\u05d3 \u05d1\u05d0\u05e7\u05e1\u05dc \u05e9\u05de\u05d5\u05e9\u05da \u05d0\u05ea \u05e9\u05e2\u05e8 \u05d4\u05d3\u05d5\u05dc\u05e8 \u05d4\u05e2\u05d3\u05db\u05e0\u05d9: =GOOGLEFINANCE(&quot;CURRENCY:USDILS&quot;)<br \/>\n\u05d5\u05d0\u05d6 \u05dc\u05d4\u05db\u05e4\u05d9\u05dc \u05d0\u05ea \u05e9\u05d5\u05d5\u05d9 \u05d4\u05de\u05e0\u05d9\u05d5\u05ea \u05d4\u05d0\u05de\u05e8\u05d9\u05e7\u05d0\u05d9\u05d5\u05ea \u05e9\u05dc\u05d5 \u05d1\u05e9\u05e2\u05e8 \u05d4\u05d6\u05d4 \u05db\u05d3\u05d9 \u05dc\u05e7\u05d1\u05dc \u05e9\u05d5\u05d5\u05d9 \u05e9\u05e7\u05dc\u05d9 \u05db\u05d5\u05dc\u05dc \u05e9\u05dc \u05d4\u05ea\u05d9\u05e7.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p align=\"center\"><a style=\"font-size: x-large; background-color: #ffffff;\" href=\"http:\/\/ronco.co.il\" target=\"_blank\" rel=\"noopener noreferrer\">\u05dc\u05de\u05e1\u05dc\u05d5\u05dc\u05d9 \u05d8\u05d9\u05d5\u05dc \u05d5\u05e6\u05d9\u05dc\u05d5\u05dd<br \/>\n<\/a><span style=\"font-size: x-large; background-color: #ffffff;\"><a href=\"https:\/\/mytrail.co.il\/\" target=\"_blank\" rel=\"noopener\">\u05dc\u05de\u05e1\u05dc\u05d5\u05dc\u05d9 \u05d0\u05d5\u05e4\u05e0\u05d9\u05d9\u05dd \u05d5\u05e6\u05d9\u05dc\u05d5\u05dd<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>GOOGLE FINANCE &amp; Google Sheets \u05d9\u05d9\u05e9\u05d5\u05dd GOOGLE FINANCE \u05d1 Google Sheets \u05db\u05de\u05d5\u05d1\u05df \u05d1\u05e2\u05d9\u05e7\u05e8 \u05d1\u05ea\u05d7\u05d5\u05dd \u00a0\u05e9\u05d5\u05e7 \u05d4\u05d4\u05d5\u05df. \u05d4\u05e4\u05e7\u05d5\u05d3\u05d5\u05ea \u05d4\u05de\u05d5\u05d1\u05d9\u05dc\u05d5\u05ea \u05e9\u05dc\u05d9 \u05d4\u05dd: =GOOGLEFINANCE(B28 , &quot;name&quot;) \u00a0 \u05e9\u05dd \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05db\u05e9\u05d4\u05e1\u05d9\u05de\u05d5\u05dc \u05d4\u05d5\u05d0 \u05d1 B8 Example for Change %: =GOOGLEFINANCE(&quot;NASDAQ:GOOG&quot;, &quot;changepct&quot;) \u05d0\u05d5 =GOOGLEFINANCE(&quot;NASDAQ:&quot;&amp;B9, &quot;changepct&quot;) =SUM($C21\/$C$38) \u00a0\u05d0\u05d7\u05d5\u05d6 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1\u05e9\u05d5\u05d5\u05d9 \u05d4\u05db\u05dc\u05dc\u05d9 \u05e9\u05dc \u05d4\u05ea\u05d9\u05e7, \u05d7\u05dc\u05d5\u05e7\u05d4 \u05e9\u05dc \u05e9\u05d5\u05d5\u05d9 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1\u05e1\u05da \u05d4\u05db\u05dc \u05db\u05dc \u05d4\u05ea\u05d9\u05e7 &#8211;&#8230; <\/p>\n<div class=\"link-more\"><a href=\"https:\/\/ronco.co.il\/?p=8420\">\u05e7\u05e8\u05d0 \u05e2\u05d5\u05d3<\/a><\/div>\n","protected":false},"author":1,"featured_media":8422,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2477],"tags":[3398,3397],"class_list":["post-8420","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai","tag-google-sheets","tag-googlefinance"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>GOOGLE FINANCE &amp; Google Sheets - \u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4<\/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:\/\/ronco.co.il\/?p=8420\" \/>\n<meta property=\"og:locale\" content=\"he_IL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GOOGLE FINANCE &amp; Google Sheets - \u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4\" \/>\n<meta property=\"og:description\" content=\"GOOGLE FINANCE &amp; Google Sheets \u05d9\u05d9\u05e9\u05d5\u05dd GOOGLE FINANCE \u05d1 Google Sheets \u05db\u05de\u05d5\u05d1\u05df \u05d1\u05e2\u05d9\u05e7\u05e8 \u05d1\u05ea\u05d7\u05d5\u05dd \u00a0\u05e9\u05d5\u05e7 \u05d4\u05d4\u05d5\u05df. \u05d4\u05e4\u05e7\u05d5\u05d3\u05d5\u05ea \u05d4\u05de\u05d5\u05d1\u05d9\u05dc\u05d5\u05ea \u05e9\u05dc\u05d9 \u05d4\u05dd: =GOOGLEFINANCE(B28 , &quot;name&quot;) \u00a0 \u05e9\u05dd \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05db\u05e9\u05d4\u05e1\u05d9\u05de\u05d5\u05dc \u05d4\u05d5\u05d0 \u05d1 B8 Example for Change %: =GOOGLEFINANCE(&quot;NASDAQ:GOOG&quot;, &quot;changepct&quot;) \u05d0\u05d5 =GOOGLEFINANCE(&quot;NASDAQ:&quot;&amp;B9, &quot;changepct&quot;) =SUM($C21\/$C$38) \u00a0\u05d0\u05d7\u05d5\u05d6 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1\u05e9\u05d5\u05d5\u05d9 \u05d4\u05db\u05dc\u05dc\u05d9 \u05e9\u05dc \u05d4\u05ea\u05d9\u05e7, \u05d7\u05dc\u05d5\u05e7\u05d4 \u05e9\u05dc \u05e9\u05d5\u05d5\u05d9 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1\u05e1\u05da \u05d4\u05db\u05dc \u05db\u05dc \u05d4\u05ea\u05d9\u05e7 &#8211;... \u05e7\u05e8\u05d0 \u05e2\u05d5\u05d3\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ronco.co.il\/?p=8420\" \/>\n<meta property=\"og:site_name\" content=\"\u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-20T08:54:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-14T14:26:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ronco.co.il\/wp-content\/uploads\/Google-Sheets_tn.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"853\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"aronco\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@aronco\" \/>\n<meta name=\"twitter:site\" content=\"@aronco\" \/>\n<meta name=\"twitter:label1\" content=\"\u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3\" \/>\n\t<meta name=\"twitter:data1\" content=\"aronco\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u05d6\u05de\u05df \u05e7\u05e8\u05d9\u05d0\u05d4 \u05de\u05d5\u05e2\u05e8\u05da\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u05d3\u05e7\u05d5\u05ea\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420\"},\"author\":{\"name\":\"aronco\",\"@id\":\"https:\\\/\\\/ronco.co.il\\\/#\\\/schema\\\/person\\\/f27b9feddb797baef86ee9129cd13c96\"},\"headline\":\"GOOGLE FINANCE &#038; Google Sheets\",\"datePublished\":\"2026-01-20T08:54:14+00:00\",\"dateModified\":\"2026-04-14T14:26:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420\"},\"wordCount\":195,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/#\\\/schema\\\/person\\\/f27b9feddb797baef86ee9129cd13c96\"},\"image\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ronco.co.il\\\/wp-content\\\/uploads\\\/Google-Sheets_tn.jpg\",\"keywords\":[\"Google Sheets\",\"GOOGLEFINANCE\"],\"articleSection\":[\"AI\"],\"inLanguage\":\"he-IL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ronco.co.il\\\/?p=8420#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420\",\"url\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420\",\"name\":\"GOOGLE FINANCE & Google Sheets - \u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ronco.co.il\\\/wp-content\\\/uploads\\\/Google-Sheets_tn.jpg\",\"datePublished\":\"2026-01-20T08:54:14+00:00\",\"dateModified\":\"2026-04-14T14:26:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420#breadcrumb\"},\"inLanguage\":\"he-IL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ronco.co.il\\\/?p=8420\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420#primaryimage\",\"url\":\"https:\\\/\\\/ronco.co.il\\\/wp-content\\\/uploads\\\/Google-Sheets_tn.jpg\",\"contentUrl\":\"https:\\\/\\\/ronco.co.il\\\/wp-content\\\/uploads\\\/Google-Sheets_tn.jpg\",\"width\":1280,\"height\":853,\"caption\":\"\u05d9\u05d9\u05e9\u05d5\u05dd GOOGLEFINANCE \u05d1 Google Sheets\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ronco.co.il\\\/?p=8420#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u05d3\u05e3 \u05d4\u05d1\u05d9\u05ea\",\"item\":\"https:\\\/\\\/ronco.co.il\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GOOGLE FINANCE &#038; Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ronco.co.il\\\/#website\",\"url\":\"https:\\\/\\\/ronco.co.il\\\/\",\"name\":\"\u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4\",\"description\":\"Ronco Blog Travel Photo and Technology\",\"publisher\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/#\\\/schema\\\/person\\\/f27b9feddb797baef86ee9129cd13c96\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ronco.co.il\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"he-IL\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/ronco.co.il\\\/#\\\/schema\\\/person\\\/f27b9feddb797baef86ee9129cd13c96\",\"name\":\"aronco\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/ronco.co.il\\\/wp-content\\\/uploads\\\/avatar.png\",\"url\":\"https:\\\/\\\/ronco.co.il\\\/wp-content\\\/uploads\\\/avatar.png\",\"contentUrl\":\"https:\\\/\\\/ronco.co.il\\\/wp-content\\\/uploads\\\/avatar.png\",\"width\":80,\"height\":102,\"caption\":\"aronco\"},\"logo\":{\"@id\":\"https:\\\/\\\/ronco.co.il\\\/wp-content\\\/uploads\\\/avatar.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GOOGLE FINANCE & Google Sheets - \u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4","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:\/\/ronco.co.il\/?p=8420","og_locale":"he_IL","og_type":"article","og_title":"GOOGLE FINANCE & Google Sheets - \u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4","og_description":"GOOGLE FINANCE &amp; Google Sheets \u05d9\u05d9\u05e9\u05d5\u05dd GOOGLE FINANCE \u05d1 Google Sheets \u05db\u05de\u05d5\u05d1\u05df \u05d1\u05e2\u05d9\u05e7\u05e8 \u05d1\u05ea\u05d7\u05d5\u05dd \u00a0\u05e9\u05d5\u05e7 \u05d4\u05d4\u05d5\u05df. \u05d4\u05e4\u05e7\u05d5\u05d3\u05d5\u05ea \u05d4\u05de\u05d5\u05d1\u05d9\u05dc\u05d5\u05ea \u05e9\u05dc\u05d9 \u05d4\u05dd: =GOOGLEFINANCE(B28 , &quot;name&quot;) \u00a0 \u05e9\u05dd \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05db\u05e9\u05d4\u05e1\u05d9\u05de\u05d5\u05dc \u05d4\u05d5\u05d0 \u05d1 B8 Example for Change %: =GOOGLEFINANCE(&quot;NASDAQ:GOOG&quot;, &quot;changepct&quot;) \u05d0\u05d5 =GOOGLEFINANCE(&quot;NASDAQ:&quot;&amp;B9, &quot;changepct&quot;) =SUM($C21\/$C$38) \u00a0\u05d0\u05d7\u05d5\u05d6 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1\u05e9\u05d5\u05d5\u05d9 \u05d4\u05db\u05dc\u05dc\u05d9 \u05e9\u05dc \u05d4\u05ea\u05d9\u05e7, \u05d7\u05dc\u05d5\u05e7\u05d4 \u05e9\u05dc \u05e9\u05d5\u05d5\u05d9 \u05d4\u05de\u05e0\u05d9\u05d9\u05d4 \u05d1\u05e1\u05da \u05d4\u05db\u05dc \u05db\u05dc \u05d4\u05ea\u05d9\u05e7 &#8211;... \u05e7\u05e8\u05d0 \u05e2\u05d5\u05d3","og_url":"https:\/\/ronco.co.il\/?p=8420","og_site_name":"\u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4","article_published_time":"2026-01-20T08:54:14+00:00","article_modified_time":"2026-04-14T14:26:37+00:00","og_image":[{"width":1280,"height":853,"url":"https:\/\/ronco.co.il\/wp-content\/uploads\/Google-Sheets_tn.jpg","type":"image\/jpeg"}],"author":"aronco","twitter_card":"summary_large_image","twitter_creator":"@aronco","twitter_site":"@aronco","twitter_misc":{"\u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3":"aronco","\u05d6\u05de\u05df \u05e7\u05e8\u05d9\u05d0\u05d4 \u05de\u05d5\u05e2\u05e8\u05da":"3 \u05d3\u05e7\u05d5\u05ea"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ronco.co.il\/?p=8420#article","isPartOf":{"@id":"https:\/\/ronco.co.il\/?p=8420"},"author":{"name":"aronco","@id":"https:\/\/ronco.co.il\/#\/schema\/person\/f27b9feddb797baef86ee9129cd13c96"},"headline":"GOOGLE FINANCE &#038; Google Sheets","datePublished":"2026-01-20T08:54:14+00:00","dateModified":"2026-04-14T14:26:37+00:00","mainEntityOfPage":{"@id":"https:\/\/ronco.co.il\/?p=8420"},"wordCount":195,"commentCount":0,"publisher":{"@id":"https:\/\/ronco.co.il\/#\/schema\/person\/f27b9feddb797baef86ee9129cd13c96"},"image":{"@id":"https:\/\/ronco.co.il\/?p=8420#primaryimage"},"thumbnailUrl":"https:\/\/ronco.co.il\/wp-content\/uploads\/Google-Sheets_tn.jpg","keywords":["Google Sheets","GOOGLEFINANCE"],"articleSection":["AI"],"inLanguage":"he-IL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ronco.co.il\/?p=8420#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ronco.co.il\/?p=8420","url":"https:\/\/ronco.co.il\/?p=8420","name":"GOOGLE FINANCE & Google Sheets - \u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4","isPartOf":{"@id":"https:\/\/ronco.co.il\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ronco.co.il\/?p=8420#primaryimage"},"image":{"@id":"https:\/\/ronco.co.il\/?p=8420#primaryimage"},"thumbnailUrl":"https:\/\/ronco.co.il\/wp-content\/uploads\/Google-Sheets_tn.jpg","datePublished":"2026-01-20T08:54:14+00:00","dateModified":"2026-04-14T14:26:37+00:00","breadcrumb":{"@id":"https:\/\/ronco.co.il\/?p=8420#breadcrumb"},"inLanguage":"he-IL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ronco.co.il\/?p=8420"]}]},{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/ronco.co.il\/?p=8420#primaryimage","url":"https:\/\/ronco.co.il\/wp-content\/uploads\/Google-Sheets_tn.jpg","contentUrl":"https:\/\/ronco.co.il\/wp-content\/uploads\/Google-Sheets_tn.jpg","width":1280,"height":853,"caption":"\u05d9\u05d9\u05e9\u05d5\u05dd GOOGLEFINANCE \u05d1 Google Sheets"},{"@type":"BreadcrumbList","@id":"https:\/\/ronco.co.il\/?p=8420#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u05d3\u05e3 \u05d4\u05d1\u05d9\u05ea","item":"https:\/\/ronco.co.il\/"},{"@type":"ListItem","position":2,"name":"GOOGLE FINANCE &#038; Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/ronco.co.il\/#website","url":"https:\/\/ronco.co.il\/","name":"\u05e8\u05d5\u05e0\u05e7\u05d5 \u05d1\u05dc\u05d5\u05d2 \u05d8\u05d9\u05d5\u05dc\u05d9\u05dd \u05e6\u05d9\u05dc\u05d5\u05dd \u05d5\u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d4","description":"Ronco Blog Travel Photo and Technology","publisher":{"@id":"https:\/\/ronco.co.il\/#\/schema\/person\/f27b9feddb797baef86ee9129cd13c96"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ronco.co.il\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"he-IL"},{"@type":["Person","Organization"],"@id":"https:\/\/ronco.co.il\/#\/schema\/person\/f27b9feddb797baef86ee9129cd13c96","name":"aronco","image":{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/ronco.co.il\/wp-content\/uploads\/avatar.png","url":"https:\/\/ronco.co.il\/wp-content\/uploads\/avatar.png","contentUrl":"https:\/\/ronco.co.il\/wp-content\/uploads\/avatar.png","width":80,"height":102,"caption":"aronco"},"logo":{"@id":"https:\/\/ronco.co.il\/wp-content\/uploads\/avatar.png"}}]}},"_links":{"self":[{"href":"https:\/\/ronco.co.il\/index.php?rest_route=\/wp\/v2\/posts\/8420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ronco.co.il\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ronco.co.il\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ronco.co.il\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ronco.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8420"}],"version-history":[{"count":11,"href":"https:\/\/ronco.co.il\/index.php?rest_route=\/wp\/v2\/posts\/8420\/revisions"}],"predecessor-version":[{"id":8423,"href":"https:\/\/ronco.co.il\/index.php?rest_route=\/wp\/v2\/posts\/8420\/revisions\/8423"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ronco.co.il\/index.php?rest_route=\/wp\/v2\/media\/8422"}],"wp:attachment":[{"href":"https:\/\/ronco.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ronco.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ronco.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}