15 Messages
Digest #4317
4b
Re: RCHGetElementNumber no longer working for 609 613 617 621 .... or by "Randy Harmelink" rharmelink
Messages
Sat Mar 17, 2018 9:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's because the Google Finance web site has been abandoned. Google
Finance is now just tab on their search page and has been severely reduced
in functionality. They've been maintaining the old site for a while, but it
was only a matter of time before it went away.
I have warned that this was going to happen.
On Sat, Mar 17, 2018 at 6:36 AM, ajtalukdar@
...
wrote:
> Just noticed that SMF add-in is not pulling Google Finance data since the
> past couple of days. Anyone else facing this issue. Thanks.
>
>
>
Finance is now just tab on their search page and has been severely reduced
in functionality. They've been maintaining the old site for a while, but it
was only a matter of time before it went away.
I have warned that this was going to happen.
On Sat, Mar 17, 2018 at 6:36 AM, ajtalukdar@
...
wrote:
> Just noticed that SMF add-in is not pulling Google Finance data since the
> past couple of days. Anyone else facing this issue. Thanks.
>
>
>
Sat Mar 17, 2018 11:07 pm (PDT) . Posted by:
ajtalukdar
Too bad. So is GuruFocus the best alternative now for quarterly IS and BS data?
Sat Mar 17, 2018 11:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Other than Portfolio123, I don't use the financial statements much, so I'm
not in a position to say which is best.
On Sat, Mar 17, 2018 at 11:07 PM, ajtalukdar@
...
wrote:
>
> Too bad. So is GuruFocus the best alternative now for quarterly IS and BS
> data?
>
>
>
not in a position to say which is best.
On Sat, Mar 17, 2018 at 11:07 PM, ajtalukdar@
...
wrote:
>
> Too bad. So is GuruFocus the best alternative now for quarterly IS and BS
> data?
>
>
>
Mon Mar 19, 2018 6:58 am (PDT) . Posted by:
"Pieter van Leeuwen" pietertvl
Hi Randy and AJ ...
I was rather concerned when I read this exchange last night.
But I'm not seeing anything different this morning than last week .... quotes still being pulled into Google Docs as before with the GoogleFinance quote fetch tool.
Was this remark targeted to other financial data formerly supplied by GF? I'm getting quote updates just fine.
Thx
pdl
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, March 17, 2018 9:50 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Google Finance not working
That's because the Google Finance web site has been abandoned. Google Finance is now just tab on their search page and has been severely reduced in functionality. They've been maintaining the old site for a while, but it was only a matter of time before it went away.
I have warned that this was going to happen.
On Sat, Mar 17, 2018 at 6:36 AM, ajtalukdar@
...
wrote:
Just noticed that SMF add-in is not pulling Google Finance data since the past couple of days. Anyone else facing this issue. Thanks.
I was rather concerned when I read this exchange last night.
But I'm not seeing anything different this morning than last week .... quotes still being pulled into Google Docs as before with the GoogleFinance quote fetch tool.
Was this remark targeted to other financial data formerly supplied by GF? I'm getting quote updates just fine.
Thx
pdl
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, March 17, 2018 9:50 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Google Finance not working
That's because the Google Finance web site has been abandoned. Google Finance is now just tab on their search page and has been severely reduced in functionality. They've been maintaining the old site for a while, but it was only a matter of time before it went away.
I have warned that this was going to happen.
On Sat, Mar 17, 2018 at 6:36 AM, ajtalukdar@
...
wrote:
Just noticed that SMF add-in is not pulling Google Finance data since the past couple of days. Anyone else facing this issue. Thanks.
Mon Mar 19, 2018 9:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Parts of Google may still be working. For now. What URL and function are
you using for the quotes?
But if I enter the old Google Finance URL in my browser here:
https://finance.google.com/finance?q=MMM
....I now get redirected to the new (limited) Google Finance:
https://www.google.com/search?q=MMM&tbm=fin
On Mon, Mar 19, 2018 at 6:58 AM, 'Pieter van Leeuwen' pieter_biz@
...
wrote:
>
>
> I was rather concerned when I read this exchange last night.
>
> But I'm not seeing anything different this morning than last week ....
> quotes still being pulled into Google Docs as before with the GoogleFinance
> quote fetch tool.
>
>
>
> Was this remark targeted to other financial data formerly supplied by
> GF? I'm getting quote updates just fine..
>
>
>
you using for the quotes?
But if I enter the old Google Finance URL in my browser here:
https://finance.google.com/finance?q=MMM
....I now get redirected to the new (limited) Google Finance:
https://www.google.com/search?q=MMM&tbm=fin
On Mon, Mar 19, 2018 at 6:58 AM, 'Pieter van Leeuwen' pieter_biz@
...
wrote:
>
>
> I was rather concerned when I read this exchange last night.
>
> But I'm not seeing anything different this morning than last week ....
> quotes still being pulled into Google Docs as before with the GoogleFinance
> quote fetch tool.
>
>
>
> Was this remark targeted to other financial data formerly supplied by
> GF? I'm getting quote updates just fine..
>
>
>
Sat Mar 17, 2018 10:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
My version is:
=smfStrExtr(smfGetTagContent("
https://www.theglobeandmail.com/investing/markets/funds/FID669.CF/
","span",-1,"name=""lastPrice"""),"value=""","""",1)
Looks like their data is coming from Barchart.com:
https://www.barchart.com/stocks/quotes/FID669.CF
So this should also work:
=smfGetBarchartPortfolioView("FID669.CF","009")
But, again, you should do one array-entered function to get all of the data
items you want with a single Internet access using that function.
On Sat, Mar 17, 2018 at 3:42 AM, cschwartz@
...
wrote:
>
> I will ask this just to check. Can I still use this function to pull
> mutual fund quotes from Globe Investor.
>
> This issue is the link I had been using, but the website address has
> changed (which I can fix)
>
> =smfConvertData(smfStrExtr(smfGetTagContent("https://www.
> theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=32005
> ","p",-1,"Fund price:"),":","("))
>
> New Link for this particular fund: https://www.
> theglobeandmail.com/investing/markets/funds/FID669.CF/
>
> What I am wondering is what do I put in to pull the quote (ie: the portion
> of the string that shows "p",-1 "Fund Price:",".",(")).
>
>
=smfStrExtr(smfGetTagContent("
https://www.theglobeandmail.com/investing/markets/funds/FID669.CF/
","span",-1,"name=""lastPrice"""),"value=""","""",1)
Looks like their data is coming from Barchart.com:
https://www.barchart.com/stocks/quotes/FID669.CF
So this should also work:
=smfGetBarchartPortfolioView("FID669.CF","009")
But, again, you should do one array-entered function to get all of the data
items you want with a single Internet access using that function.
On Sat, Mar 17, 2018 at 3:42 AM, cschwartz@
...
wrote:
>
> I will ask this just to check. Can I still use this function to pull
> mutual fund quotes from Globe Investor.
>
> This issue is the link I had been using, but the website address has
> changed (which I can fix)
>
> =smfConvertData(smfStrExtr(smfGetTagContent("https://www.
> theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=32005
> ","p",-1,"Fund price:"),":","("))
>
> New Link for this particular fund: https://www.
> theglobeandmail.
>
> What I am wondering is what do I put in to pull the quote (ie: the portion
> of the string that shows "p"
>
>
Sun Mar 18, 2018 9:58 am (PDT) . Posted by:
gz_cp
If the csv doesn't have a hard return at the end, =smfGetCSVFile() will miss the last row of data.
For example, a csv file published in Google Sheet does not contain the end return, and =smfGetCSVFile won't pick up the last line of data.
For example, a csv file published in Google Sheet does not contain the end return, and =smfGetCSVFile won't pick up the last line of data.
Sun Mar 18, 2018 10:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the heads up. I've made a note of that and added to a Todo list.
I should be able to just add an extra line feed at the end of the file.
On Sun, Mar 18, 2018 at 9:58 AM, gz_cp@
...
wrote:
> If the csv doesn't have a hard return at the end, =smfGetCSVFile() will
> miss the last row of data.
>
> For example, a csv file published in Google Sheet does not contain the end
> return, and =smfGetCSVFile won't pick up the last line of data.
>
I should be able to just add an extra line feed at the end of the file.
On Sun, Mar 18, 2018 at 9:58 AM, gz_cp@
...
wrote:
> If the csv doesn't have a hard return at the end, =smfGetCSVFile(
> miss the last row of data.
>
> For example, a csv file published in Google Sheet does not contain the end
> return, and =smfGetCSVFile won't pick up the last line of data.
>
Sun Mar 18, 2018 10:19 am (PDT) . Posted by:
ghart21
This years EPS, Next years EPS, Last 5 years growth, Next 5 years Growth,
609;YahooAE;Earnings Growth Rates -- Current Year -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;Current Year; ; ;0;0;0;0
613;YahooAE;Earnings Growth Rates -- Next Year -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT YEAR; ; ;0;0;0;0
617;YahooAE;Earnings Growth Rates -- Past 5 Years -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;PAST 5 YEARS; ; ;0;0;0;0
621;YahooAE;Earnings Growth Rates -- Next 5 Years -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT 5 YEARS; ; ;0;0;0;0
Other parts of SMF working fine including Portfolio View calls. Last time I used SMF was a week ago.
Solution is to change/edit smf-elements-2.txt for elements 601 to 624, replacing DOWN LAST 90 DAYS with DOWN LAST 30 DAYS
It's always something ....
609;YahooAE;Earnings Growth Rates -- Current Year -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;Current Year; ; ;0;0;0;0
613;YahooAE;Earnings Growth Rates -- Next Year -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT YEAR; ; ;0;0;0;0
617;YahooAE;Earnings Growth Rates -- Past 5 Years -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;PAST 5 YEARS; ; ;0;0;0;0
621;YahooAE;Earnings Growth Rates -- Next 5 Years -- Company;https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT 5 YEARS; ; ;0;0;0;0
Other parts of SMF working fine including Portfolio View calls. Last time I used SMF was a week ago.
Solution is to change/edit smf-elements-
It's always something ....
Sun Mar 18, 2018 10:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the heads up. I've added it to the ToDo list.
On Sun, Mar 18, 2018 at 10:19 AM, ghart23@
...
wrote:
> This years EPS, Next years EPS, Last 5 years growth, Next 5 years Growth,
>
> 609;YahooAE;Earnings Growth Rates -- Current Year -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;Current Year;
> ; ;0;0;0;0
>
> 613;YahooAE;Earnings Growth Rates -- Next Year -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT YEAR; ;
> ;0;0;0;0
>
> 617;YahooAE;Earnings Growth Rates -- Past 5 Years -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;PAST 5 YEARS;
> ; ;0;0;0;0
>
> 621;YahooAE;Earnings Growth Rates -- Next 5 Years -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT 5 YEARS;
> ; ;0;0;0;0
>
> Other parts of SMF working fine including Portfolio View calls. Last time
> I used SMF was a week ago.
>
> Solution is to change/edit smf-elements-2.txt for elements 601 to 624,
> replacing DOWN LAST 90 DAYS with DOWN LAST 30 DAYS
>
> It's always something ....
>
>
>
On Sun, Mar 18, 2018 at 10:19 AM, ghart23@
...
wrote:
> This years EPS, Next years EPS, Last 5 years growth, Next 5 years Growth,
>
> 609;YahooAE;Earnings Growth Rates -- Current Year -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;Current Year;
> ; ;0;0;0;0
>
> 613;YahooAE;Earnings Growth Rates -- Next Year -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT YEAR; ;
> ;0;0;0;0
>
> 617;YahooAE;Earnings Growth Rates -- Past 5 Years -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;PAST 5 YEARS;
> ; ;0;0;0;0
>
> 621;YahooAE;Earnings Growth Rates -- Next 5 Years -- Company;
> https://finance.yahoo.com/q/ae?s=~~~~~;1;DOWN LAST 90 DAYS;NEXT 5 YEARS;
> ; ;0;0;0;0
>
> Other parts of SMF working fine including Portfolio View calls. Last time
> I used SMF was a week ago.
>
> Solution is to change/edit smf-elements-
> replacing DOWN LAST 90 DAYS with DOWN LAST 30 DAYS
>
> It's always something ....
>
>
>
Sun Mar 18, 2018 1:04 pm (PDT) . Posted by:
ajtalukdar
Randy,
I just noticed that there is no documentation available for smfGetGuruFocusItem and smfGetGuruFocusCSVItem, although you have made available couple of samples using these two functions. Can you update the website with the parameter documentation for these two functions please?
Abhijit Talukdar
I just noticed that there is no documentation available for smfGetGuruFocusItem and smfGetGuruFocusCSVI
Abhijit Talukdar
Sun Mar 18, 2018 1:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's mostly because the templates are the documentation of what's
available. There are really just too many fields available to list them all
in some documentation. But I could do like I did with the Portfolio View
documentations and do a very basic overview and then refer to the
templates for the list of fields available.
On Sun, Mar 18, 2018 at 1:04 PM, ajtalukdar@
...
wrote:
> I just noticed that there is no documentation available for
> smfGetGuruFocusItem and smfGetGuruFocusCSVItem, although you have made
> available couple of samples using these two functions. Can you update the
> website with the parameter documentation for these two functions please?
>
>
>
available. There are really just too many fields available to list them all
in some documentation. But I could do like I did with the Portfolio View
documentations and do a very basic overview and then refer to the
templates for the list of fields available.
On Sun, Mar 18, 2018 at 1:04 PM, ajtalukdar@
...
wrote:
> I just noticed that there is no documentation available for
> smfGetGuruFocusItem and smfGetGuruFocusCSVI
> available couple of samples using these two functions. Can you update the
> website with the parameter documentation for these two functions please?
>
>
>
Sun Mar 18, 2018 11:34 pm (PDT) . Posted by:
ajtalukdar
I am looking for documentation of just the function parameters.. This should hardly take you any time at all. The fields available can be deduced from the working templates.
Mon Mar 19, 2018 1:19 am (PDT) . Posted by:
ajtalukdar
Randy,
Never mind. You can ignore my prevous post and keep this at low priority. I had a look at the template once again and figured out the meaning of the function parameters. I am all set. Best.
Never mind. You can ignore my prevous post and keep this at low priority. I had a look at the template once again and figured out the meaning of the function parameters. I am all set. Best.
Mon Mar 19, 2018 6:49 am (PDT) . Posted by:
ajtalukdar
Randy,
Working with your template sample "smfGetGuruFocusItem-Full-Template.xls" I was able to pull all the IS and BS data I need from GuruFocus, EXCEPT one - Minority Interest. This appears between 'NonCurrent Deferred Liabilities' and 'Other Long-Term Liabilities' in GuruFocus.
If you see your template, you will notice that you have skipped the fetch for Minority Interest. It should have appeared between Line 82 (NonCurrent Deferred Liabilities) and Line 83 (Other Long-Term Liabilities).
I thought of adding the definition for Minority Interest myself in one of the constant files (smf-elements-?.txt), but could not find the GuruFocus constants defined anywhere. Hence I got stuck at this point.
Can you help me fetch this element please?
Working with your template sample "smfGetGuruFoc
If you see your template, you will notice that you have skipped the fetch for Minority Interest. It should have appeared between Line 82 (NonCurrent Deferred Liabilities) and Line 83 (Other Long-Term Liabilities)
I thought of adding the definition for Minority Interest myself in one of the constant files (smf-elements-
Can you help me fetch this element please?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar