tag:blogger.com,1999:blog-401742767867047481.post4173452604112337233..comments2024-03-28T18:36:46.828+08:00Comments on $$$ KPO and CZM $$$: Bye Yahoo Finance! Hi Alpha Vantage!CZMhttp://www.blogger.com/profile/02040796250676928758noreply@blogger.comBlogger29125tag:blogger.com,1999:blog-401742767867047481.post-72577225897752781132020-07-31T12:25:28.525+08:002020-07-31T12:25:28.525+08:00Hi kenshinjeff,
I know man. So annoying, both Sto...Hi kenshinjeff,<br /><br />I know man. So annoying, both StocksCafe and Alpha Vantage broke in the same month. I am currently scrapping yahoo and WSJ but this method is not reliable at all.<br /><br />I have a rough idea but need time to work on it...KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-39465194022264226192020-07-30T10:13:11.464+08:002020-07-30T10:13:11.464+08:00Hi there, I wrote a simple script to push price no...Hi there, I wrote a simple script to push price notifications to my slack at 10AM/4PM, but I noticed that AV has stopped giving SGX data since 13 July. May I ask how do you guys get reliable data other than scraping finance.yahoo ? kenshinjeffhttps://www.blogger.com/profile/03632088697841069762noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-16422763273461985222019-03-18T15:55:03.673+08:002019-03-18T15:55:03.673+08:00Hi vx,
Ops, I forgot to check my comment section....Hi vx,<br /><br />Ops, I forgot to check my comment section. I took a quick look and realized that this is due to the special character "^".<br /><br />I am too lazy to modify the code but a quick fix for your situation would be to do URL encoding on the special character. <br /><br />In your case, "^STI" = "%5ESTI" (I have tested it and it should work.<br /><br />KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-32697951620164835092019-03-08T17:53:03.720+08:002019-03-08T17:53:03.720+08:00Hi KPO thanks for this, really useful.
Will like ...Hi KPO thanks for this, really useful.<br /><br />Will like to check if you had come across cases where the ticker works with Alpha Vantage URL output, but not with the Google script? The script works with other tickers, so I'm not sure what's the issue. Wonder if you have a clue? Thanks in advance.<br /><br />Example<br />Ticker: ^STI for STI Index<br />Does not work with the Google Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-42958738859592991732019-02-25T23:57:21.151+08:002019-02-25T23:57:21.151+08:00Hi Nicholas,
Ops, we were overseas, hence the del...Hi Nicholas,<br /><br />Ops, we were overseas, hence the delay in response. Yes, it is still working for me. I can only guess that you probably made too many calls, do refer to the documentation below for more information.<br /><br />https://www.alphavantage.co/support/#api-key<br /><br />We are proud to provide free API service for our global community of users and recommend that you make API KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-4726148919903539392019-02-22T00:18:14.380+08:002019-02-22T00:18:14.380+08:00Hey! Thanks for this - I must say it was very use...Hey! Thanks for this - I must say it was very useful... when it worked! For the last two weeks or so I get an instant fail when I run the code on a trigger and now it fails also when I run from within the Script file directly.<br /><br />Is it still working for you? What happened? I was calling once an hour for 25 funds - is that too many calls?Nicholashttps://www.blogger.com/profile/18283701983738612677noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-42510244992909864562019-02-12T12:56:38.980+08:002019-02-12T12:56:38.980+08:00Hi Paul,
I am guessing you are referring to stock...Hi Paul,<br /><br />I am guessing you are referring to stock quotes from other exchanges because I do not remember SGX data being real time. In addition, I feel that there is little value in getting real time quotes.<br /><br />As much as I would like to help you, I don't think I will be able to find time to look into your request. Hope you will eventually find what you are looking for!KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-69444389575139930402019-02-11T22:56:22.379+08:002019-02-11T22:56:22.379+08:00Hi... how can i modify your formula so i can get r...Hi... how can i modify your formula so i can get real time quotes? maybe not every second but every 15 min would do...<br /><br />Thanks!Paul Asarohttps://www.blogger.com/profile/07731509833561621725noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-15800456274780230232018-06-15T14:35:24.066+08:002018-06-15T14:35:24.066+08:00Hi WiRuS,
I do not have any bonds so did not enco...Hi WiRuS,<br /><br />I do not have any bonds so did not encounter this issue. I tested earlier and it seems that bond price cannot be fetched. Not too sure what is the reason though...KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-75478857150113836742018-06-14T17:45:26.554+08:002018-06-14T17:45:26.554+08:00It seems like bonds cannot be displayed anymore? R...It seems like bonds cannot be displayed anymore? Recently I see my bonds all $0.00 price.. Do you have this issue too?WiRuShttps://www.blogger.com/profile/08984090349115678369noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-753886307201069842018-02-10T14:58:42.388+08:002018-02-10T14:58:42.388+08:00Thanks for your reply. Not sure how to use the inf...Thanks for your reply. Not sure how to use the info in stocks.cafe into google spreadsheet. How about 'change'?weirdohttps://www.blogger.com/profile/17911134931675921086noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-43214316836163675352018-02-02T09:49:06.058+08:002018-02-02T09:49:06.058+08:00Hi weirdo,
Based on the API Documentation in Alph...Hi weirdo,<br /><br />Based on the API Documentation in Alpha Vantage, they do not provide 52 week low and high. I will recommend that you go to stocks.cafe and try that out instead :)KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-21245932778666232152018-02-01T20:40:35.310+08:002018-02-01T20:40:35.310+08:00Hi,
Was wondering if you happen to know how to re...Hi,<br /><br />Was wondering if you happen to know how to retrieve the change, 52wk low and 52wk high?weirdohttps://www.blogger.com/profile/17911134931675921086noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-65921583285425602202017-11-24T09:59:30.523+08:002017-11-24T09:59:30.523+08:00Hi Unknown,
Just paste in the function and fill i...Hi Unknown,<br /><br />Just paste in the function and fill in the relevant parameters. The cell will highlight it as an error but ignore it. I hope it is working for you now.KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-65535799872894724972017-11-22T10:38:51.511+08:002017-11-22T10:38:51.511+08:00Hi, i pasted the code in script editor but i could...Hi, i pasted the code in script editor but i couldn't get any function in the spreadsheetsAnonymoushttps://www.blogger.com/profile/06236430170865950535noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-65090074751187701092017-11-15T01:35:37.072+08:002017-11-15T01:35:37.072+08:00Hahaha. Sure! Glad that you managed to get it work...Hahaha. Sure! Glad that you managed to get it working :)KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-85196785526602626072017-11-14T16:57:27.312+08:002017-11-14T16:57:27.312+08:00My bad...i managed to make your script to work :) ...My bad...i managed to make your script to work :) <br />The issue was that i was not pointing in a specific cell i was passing the stock ticket in the function itself...<br />Now it's ok :9<br />Thanks for the script and your precious help!Linozzhttps://www.blogger.com/profile/02084511194233405767noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-15093973279340601562017-11-14T01:18:32.443+08:002017-11-14T01:18:32.443+08:00i guess it's something not related to the symb...i guess it's something not related to the symbol. <br />Indeed i'm able to retrieve the Json data with their URL address https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=SWDA.MI&apikey=(mykey) and the .csv file as well.<br />The issue is just in the google spreadsheet which using the script returns 0 Linozzhttps://www.blogger.com/profile/02084511194233405767noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-25937081721075213902017-11-13T23:44:28.739+08:002017-11-13T23:44:28.739+08:00Hi P.Greco,
It should work for non-US stocks as w...Hi P.Greco,<br /><br />It should work for non-US stocks as well. For Singapore stocks, we need to append ".SI" to the stock code. I did a quick check, for France stocks, you will have to append ".PA" instead.KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-91065386858893221032017-11-13T22:50:26.138+08:002017-11-13T22:50:26.138+08:00I'm still getting 0 on my google sheet file :(...I'm still getting 0 on my google sheet file :(<br />Could this be related on some different data formatting on non-US accounts (such as mine in Italian)?<br />Linozzhttps://www.blogger.com/profile/02084511194233405767noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-66775870736756476982017-11-13T00:28:12.729+08:002017-11-13T00:28:12.729+08:00Hahaha. That's great!Hahaha. That's great!KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-39087228027709583082017-11-13T00:27:43.013+08:002017-11-13T00:27:43.013+08:00Hi K H Tan,
No problem. Glad that it helped :)Hi K H Tan,<br /><br />No problem. Glad that it helped :)KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-44704947133395717482017-11-12T09:59:11.260+08:002017-11-12T09:59:11.260+08:00Hi KPO,
Works like a charm! Now its not loading ...Hi KPO, <br /><br />Works like a charm! Now its not loading any more "0"s anymore! Thanks so much!Piglet Yao Llaohttps://www.blogger.com/profile/04159295519424593850noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-65882572080108754472017-11-12T02:52:36.386+08:002017-11-12T02:52:36.386+08:00Found out about this thru the FB link and Kyith...Found out about this thru the FB link and Kyith's blog. <br />Thanks a lot for the workaround !Khhttps://www.blogger.com/profile/09761775951886323893noreply@blogger.comtag:blogger.com,1999:blog-401742767867047481.post-74961590733273218032017-11-11T22:23:00.087+08:002017-11-11T22:23:00.087+08:00Hi Passive Income Farmer,
Updated it with sleep! ...Hi Passive Income Farmer,<br /><br />Updated it with sleep! Works for me when I tested it. Make sure you call the function with ROW() as the time to sleep so every row sends the request at different time.KPOhttps://www.blogger.com/profile/11839556977401200489noreply@blogger.com