5 Messages
Digest #4441
Messages
Thu Dec 13, 2018 9:58 am (PST) . Posted by:
marcos.torcal
Dear Randy,
Thanks for your awesome tool!
I usually use the data of EPS from Nasdaq to make Peter Lynch charts. However, that is not possible for european companies. I think that Financial Times can be a good option for that. The data can be got from here (General Mills for example):
https://markets.ft.com/research/webservices/companies/v1/financialperformance?symbols=gis:nyq&period=q&numHistorical=20&numForecast=1&source=ae64d32748f2eef9 https://markets.ft.com/research/webservices/companies/v1/financialperformance?symbols=gis:nyq&period=q&numHistorical=55&numForecast=1&source=ae64d32748f2eef9
I use this fuction to get the data:
=smfGetYahooJSONField("",Web,"data.items.0.performanceAnnouncements.earnings.announcements.historical."&period&".reported")
Where Web is the link above and period is an integer from 0 (most recent quarter) to numHistorical (20 in this case)
Everything works perfectly but when I use a numHistorical=40 (that is 10 years) then it doesn't work. I think that the problem comes from the function smfGetWebPage. Maybe there is a lot of data and the function returns error. Do you have any idea of how to fix it?
Thanks!
PS. Note that the source in the above URL is updated from time to time. To have the correct one I use this function:
=smfGetTagContent("https://markets.ft.com/research/webservices/companies/v1/docs","code",1,"")
Thanks for your awesome tool!
I usually use the data of EPS from Nasdaq to make Peter Lynch charts. However, that is not possible for european companies. I think that Financial Times can be a good option for that. The data can be got from here (General Mills for example):
https://markets.ft.com/research/webservices/companies/v1/financialperformance?symbols=gis:nyq&period=q&numHistorical=20&numForecast=1&source=ae64d32748f2eef9 https://markets.ft.com/research/webservices/companies/v1/financialperformance?symbols=gis:nyq&period=q&numHistorical=55&numForecast=1&source=ae64d32748f2eef9
I use this fuction to get the data:
=smfGetYahooJSONField("",Web,"data.items.0.performanceAnnouncements.earnings.announcements.historical."&period&".reported")
Where Web is the link above and period is an integer from 0 (most recent quarter) to numHistorical (20 in this case)
Everything works perfectly but when I use a numHistorical=40 (that is 10 years) then it doesn't work. I think that the problem comes from the function smfGetWebPage. Maybe there is a lot of data and the function returns error. Do you have any idea of how to fix it?
Thanks!
PS. Note that the source in the above URL is updated from time to time. To have the correct one I use this function:
=smfGetTagContent("https://markets.ft.com/research/webservices/companies/v1/docs","
Thu Dec 13, 2018 1:35 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The problem is actually that smfGetYahooJSONField() uses RCHGetWebData() to
grab the data. That limits the returned string to 32767 bytes, so your
earnings data is getting pushed off the end of that string when you go to
55 historical periods.
It was easy to fix -- I just changed the call from RCHGetWebData() to
smfGetWebPage().
The reason RCHGetWebData() returns only 32767 bytes is because that is the
limit of a string length within an EXCEL cell. I typically use
smfGetWebPage() within the VBA project, since it doesn't that length issue.
I have my version of the add-in fixed with that minor change, but I'd
prefer not to issue a new release at this time. Are you capable of changing
the VBA code in your copy of the XLA file?
On Thu, Dec 13, 2018 at 11:45 AM marcos.torcal@... wrote:
> I usually use the data of EPS from Nasdaq to make Peter Lynch charts.
> However, that is not possible for european companies. I think that
> Financial Times can be a good option for that. The data can be got from
> here (General Mills for example):
>
>
> https://markets.ft.com/research/webservices/companies/v1/financialperformance?symbols=gis:nyq&period=q&numHistorical=20&numForecast=1&source=ae64d32748f2eef9
> <https://markets.ft.com/research/webservices/companies/v1/financialperformance?symbols=gis:nyq&period=q&numHistorical=55&numForecast=1&source=ae64d32748f2eef9>
>
> I use this fuction to get the data:
>
>
> =smfGetYahooJSONField("",Web,"data.items.0.performanceAnnouncements.earnings.announcements.historical."&period&".reported")
>
> Where Web is the link above and period is an integer from 0 (most recent
> quarter) to numHistorical (20 in this case)
>
> Everything works perfectly but when I use a numHistorical=40 (that is 10
> years) then it doesn't work. I think that the problem comes from the
> function smfGetWebPage. Maybe there is a lot of data and the function
> returns error. Do you have any idea of how to fix it?
>
> PS. Note that the source in the above URL is updated from time to time.
> To have the correct one I use this function:
>
> =smfGetTagContent("
> https://markets.ft.com/research/webservices/companies/v1/docs
> ","code",1,"")
>
>
>
>
>
>
>
>
>
>
grab the data. That limits the returned string to 32767 bytes, so your
earnings data is getting pushed off the end of that string when you go to
55 historical periods.
It was easy to fix -- I just changed the call from RCHGetWebData() to
smfGetWebPage().
The reason RCHGetWebData() returns only 32767 bytes is because that is the
limit of a string length within an EXCEL cell. I typically use
smfGetWebPage() within the VBA project, since it doesn't that length issue.
I have my version of the add-in fixed with that minor change, but I'd
prefer not to issue a new release at this time. Are you capable of changing
the VBA code in your copy of the XLA file?
On Thu, Dec 13, 2018 at 11:45 AM marcos.torcal@... wrote:
> I usually use the data of EPS from Nasdaq to make Peter Lynch charts.
> However, that is not possible for european companies. I think that
> Financial Times can be a good option for that. The data can be got from
> here (General Mills for example):
>
>
> https://markets.ft.com/research/webservices/companies/v1/financialperformance?symbols=gis:nyq&period=q&numHistorical=20&numForecast=1&source=ae64d32748f2eef9
> <https://markets.ft.com/research/webservices/companies/v1/financialperformance?symbols=gis:nyq&period=q&numHistorical=55&numForecast=1&source=ae64d32748f2eef9>
>
> I use this fuction to get the data:
>
>
> =smfGetYahooJSONField("",Web,"data.items.0.performanceAnnouncements.earnings.announcements.historical."&period&".reported")
>
> Where Web is the link above and period is an integer from 0 (most recent
> quarter) to numHistorical (20 in this case)
>
> Everything works perfectly but when I use a numHistorical=40 (that is 10
> years) then it doesn't work. I think that the problem comes from the
> function smfGetWebPage. Maybe there is a lot of data and the function
> returns error. Do you have any idea of how to fix it?
>
> PS. Note that the source in the above URL is updated from time to time.
> To have the correct one I use this function:
>
> =smfGetTagContent("
> https://markets.ft.com/research/webservices/companies/v1/docs
> ","
>
>
>
>
>
>
>
>
>
>
Fri Dec 14, 2018 3:19 am (PST) . Posted by:
marcos.torcal
Thanks Randy!!
Yes, I think I can change it by myself.
Have a lovely Christmas!
Yes, I think I can change it by myself.
Have a lovely Christmas!
Fri Dec 14, 2018 12:41 am (PST) . Posted by:
sri.yanto
Hello randy,
im sory once again, bother you
if you dont mind, i have some web i want to extract, but it seem it cannot using, RCHgettable or Rch Get web it return error
here the web
https://www.shareinvestor.com/fundamental/factsheet.html?counter=MREI.JK https://www.shareinvestor.com/fundamental/factsheet.html?counter=MREI.JK
i want to exctract value of Piotroski F Score, its return 4,
any idea randy, because this web didnt contain any table
thanks in advance
im sory once again, bother you
if you dont mind, i have some web i want to extract, but it seem it cannot using, RCHgettable or Rch Get web it return error
here the web
https://www.shareinvestor.com/fundamental/factsheet.html?counter=MREI.JK https://www.shareinvestor.com/fundamental/factsheet.html?counter=MREI.JK
i want to exctract value of Piotroski F Score, its return 4,
any idea randy, because this web didnt contain any table
thanks in advance
Fri Dec 14, 2018 1:42 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The source code of the web page contains the table. This works fine for me:
=RCHGetTableCell("
https://www.shareinvestor.com/fundamental/factsheet.html?counter=MREI.JK
",1,">Piotroski")
On Fri, Dec 14, 2018 at 1:42 AM sri.yanto@... wrote:
> if you dont mind, i have some web i want to extract, but it seem it cannot
> using, RCHgettable or Rch Get web it return error
>
> here the web
>
> https://www.shareinvestor.com/fundamental/factsheet.html?counter=MREI.JK
>
> i want to exctract value of Piotroski F Score, its return 4,
>
> any idea randy, because this web didnt contain any table
>
>
>
=RCHGetTableCell("
https://www.shareinvestor.com/fundamental/factsheet.html?counter=MREI.JK
",1,">Piotroski")
On Fri, Dec 14, 2018 at 1:42 AM sri.yanto@... wrote:
> if you dont mind, i have some web i want to extract, but it seem it cannot
> using, RCHgettable or Rch Get web it return error
>
> here the web
>
> https://www.shareinvestor.com/fundamental/factsheet.html?counter=MREI.JK
>
> i want to exctract value of Piotroski F Score, its return 4,
>
> any idea randy, because this web didnt contain any table
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar