Selasa, 02 April 2019

[smf_addin] Digest Number 4509

13 Messages

Digest #4509

Messages

Mon Apr 1, 2019 6:56 am (PDT) . Posted by:

CostelloT

Randy,
Which SMF function can I use to extract the stock symbols for a given date from the Yahoo earnings calendar? https://finance.yahoo.com/calendar/earnings?day=2019-04-01 https://finance.yahoo.com/calendar/earnings?day=2019-04-01



Thanks,


Tony

Mon Apr 1, 2019 8:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("https://finance.yahoo.com/calendar/earnings?day=2019-04-01",">EPS
Estimate")

On Mon, Apr 1, 2019 at 6:56 AM costellot@... wrote:

> Which SMF function can I use to extract the stock symbols for a given
> date from the Yahoo earnings calendar?
> https://finance.yahoo.com/calendar/earnings?day=2019-04-01
>
>
>

Mon Apr 1, 2019 2:55 pm (PDT) . Posted by:

"Tony Costello" CostelloT

Randy,    That works great!  I now want to take that list of stocks and get the "Total Grade" column from Navellier's Portfolio Grader website.
https://navelliergrowth.investorplace.com/portfolio-grader/report-card
Is there a good way to do this?

Thanks,
Tony

|
|
| |
Report Card – Portfolio Grader

|

|

|

On Monday, April 1, 2019, 11:31:54 AM EDT, Randy Harmelink rharmelink@gmail..com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

Try:
=RCHGetHTMLTable("https://finance.yahoo.com/calendar/earnings?day=2019-04-01",">EPS Estimate")

On Mon, Apr 1, 2019 at 6:56 AM costellot@... wrote:

    Which SMF function can I use to extract the stock symbols for a given date from the Yahoo earnings calendar? https://finance.yahoo.com/calendar/earnings?day=2019-04-01

Mon Apr 1, 2019 3:31 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can get things individually. See:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/35033

....and the rest of the thread.

On Mon, Apr 1, 2019 at 2:55 PM Tony Costello costellot@... wrote:

>
> That works great! I now want to take that list of stocks and get the
> "Total Grade" column from Navellier's Portfolio Grader website.
>
> https://navelliergrowth.investorplace.com/portfolio-grader/report-card
>
> Is there a good way to do this?
>
>
>

Mon Apr 1, 2019 7:46 pm (PDT) . Posted by:

"Tony Costello" CostelloT

Randy,
    I found the Navellier related messages and tried:
=RCHGetTableCell("https://navelliergrowth.investorplace.com/portfolio-grader/stock-report/?q="&B14,0,"Total Grade:")
where B14 contained the symbol AAPL.
The function returned "Error".
Do you think the website has changed recently so it is no longer accessible with the smf function?
Thanks,
Tony

On Monday, April 1, 2019, 6:31:54 PM EDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

You can get things individually. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/35033

....and the rest of the thread.
On Mon, Apr 1, 2019 at 2:55 PM Tony Costello costellot@... wrote:

    That works great!  I now want to take that list of stocks and get the "Total Grade" column from Navellier's Portfolio Grader website.

https://navelliergrowth.investorplace.com/portfolio-grader/report-card
Is there a good way to do this?

Tue Apr 2, 2019 1:23 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Before accessing the data, you do need to create a security cookie for the
site by logging in via the "From Data (Legacy)" option within EXCEL. When I
tested the formula earlier, before I sent the reply, I also got "Error"
when I first tried the formula. Once I logged in, I got "Total Grade:C".

On Mon, Apr 1, 2019 at 7:50 PM Tony Costello costellot@... wrote:

>
> I found the Navellier related messages and tried:
>
> =RCHGetTableCell("
> https://navelliergrowth.investorplace.com/portfolio-grader/stock-report/?q="&B14,0,"Total
> Grade:")
>
> where B14 contained the symbol AAPL.
>
> The function returned "Error".
>
> Do you think the website has changed recently so it is no longer
> accessible with the smf function?
>
>
>

Mon Apr 1, 2019 11:46 am (PDT) . Posted by:

indinvestor111

Hi Randy,

I'm a paying subscriber to Mstar and was using the CSV data. It obviously doesn't work now from what I gather is a credentials issue. Is there a way I can make the add-in work in this new environment?


Thanks

Mon Apr 1, 2019 11:51 am (PDT) . Posted by:

indinvestor111

Hi,

I'm a paying customer of Mstar and was using the smfGetCSVfile function to populate my sheets. Id there a way to get this to work in the new environment?


Thanks

Mon Apr 1, 2019 1:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry. I've not seen a way to get at the CSV file without a lot of work to
fake credentials. It may be possible to do it while interacting with the IE
object, but that's far beyond the scope of the add-in. Either process would
require page-specific processing.

It looks like the JSON file feeding the web page is still available, but
it's a bear to process. For example, to get the first two years of Revenue
would be something like:

=smfGetTagContent(SUBSTITUTE(SUBSTITUTE(RCHGetWebData("
https://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?&t=MMM®ion=usa&culture=en-US&version=SAL&cur=&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&view=raw
","data_i1",2000),"\/","/"),"\""",""""),"div",1,"data_i1",,,,1)

=smfGetTagContent(SUBSTITUTE(SUBSTITUTE(RCHGetWebData("
https://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?&t=MMM®ion=usa&culture=en-US&version=SAL&cur=&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&view=raw
","data_i1",2000),"\/","/"),"&#92;""",""""),"div";,2,"data_i1",,,,1)

....but you'd to know that "data_i1" is the tag for Revenue. So all of the
tags would need to be mapped to their appropriate identities.

And there's no telling how long that will be available?

On Mon, Apr 1, 2019 at 11:46 AM elandry@... wrote:

>
> I'm a paying subscriber to Mstar and was using the CSV data. It obviously
> doesn't work now from what I gather is a credentials issue. Is there a way
> I can make the add-in work in this new environment?
>
>
>

Mon Apr 1, 2019 3:03 pm (PDT) . Posted by:

indinvestor111

Thanks,

So you're saying it's more than a simple matter of adding some sort of a key to tell them that I am indeed a paying customer?




Mon Apr 1, 2019 3:33 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Correct. Paying customer would get 10 years instead of 5, but either way
the cookies and such need to be in place for the CSV file to be generated.
That's handled on a request through the web page, but not directly via a
bookmarkable URL.

On Mon, Apr 1, 2019 at 3:03 PM elandry@bmlcapital.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> So you're saying it's more than a simple matter of adding some sort of a
> key to tell them that I am indeed a paying customer?
>
>
>

Mon Apr 1, 2019 4:14 pm (PDT) . Posted by:

indinvestor111

So then would you say the next best option is to get the data from Gurufocus?

Thanks

Mon Apr 1, 2019 5:45 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's what I use. But I'm a subscriber and don't use anything other than
U.S. stocks.

On Mon, Apr 1, 2019 at 4:14 PM elandry@... wrote:

>
> So then would you say the next best option is to get the data from
> Gurufocus?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 05.56

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)