Sabtu, 19 Juli 2014

[smf_addin] Digest Number 3125

15 Messages

Digest #3125
1a
IBD Group Leaders by mrtomschu
1b
Re: IBD Group Leaders by "Kermit W. Prather" kermitpra
1c
Re: IBD Group Leaders by "Randy Harmelink" rharmelink
2.2
2.3
Re: New file uploaded to smf_addin by "Randy Harmelink" rharmelink
2.4
2.5
Re: New file uploaded to smf_addin by "Randy Harmelink" rharmelink
2.6
Re: New file uploaded to smf_addin by "James Healey" jchealey66
2.7
Re: New file uploaded to smf_addin by "Randy Harmelink" rharmelink
3b
Re: Historical EOD Option Chains by "Randy Harmelink" rharmelink
4a
Investors.com - stock checkup - change? by "Fred Wright" fredwwright
4b
Re: Investors.com - stock checkup - change? by "Randy Harmelink" rharmelink

Messages

Sat Jul 19, 2014 7:40 am (PDT) . Posted by:

mrtomschu

IBD has changed the format for their stock checkup. I want to extract the 5 group leaders individually into separate cells. The formulae that I had been using are:
=RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol="&$A$1,1,"groupLdrsTable",,,,1,"</table")

=RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol="&$A$1,1,"groupLdrsTable",,,,2,"</table")

etc.
Can you tell me what I need to change?


tomschu

Sat Jul 19, 2014 7:53 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

The table that you referred to is no longer on that page.

You need to search the source code of the page to locate the data you want and then changes the formula.

Hard to assist since you did not provide what the data was you wanted.


Good luck,
Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, July 19, 2014 10:41 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] IBD Group Leaders


IBD has changed the format for their stock checkup. I want to extract the 5 group leaders individually into separate cells. The formulae that I had been using are:
=RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol="&$A$1,1,"groupLdrsTable",,,,1,"</table")
=RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol="&$A$1,1,"groupLdrsTable",,,,2,"</table")
etc.
Can you tell me what I need to change?

tomschu

Sat Jul 19, 2014 8:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This template:

RCHGetTableCell-Template-IBD-Stock-Checkup.xls

...still retrieves the group leaders for each rating category. However, I
did have to fix the A/D rating because of their changes to the web page. I
just uploaded the revision.

On Sat, Jul 19, 2014 at 7:40 AM, mrtomschu@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> IBD has changed the format for their stock checkup. I want to extract
> the 5 group leaders individually into separate cells. The formulae that I
> had been using are:
>
> =RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol=
> "&$A$1,1,"groupLdrsTable",,,,1,"</table")
>
> =RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol=
> "&$A$1,1,"groupLdrsTable",,,,2,"</table")
>
> etc.
>
> Can you tell me what I need to change?
>

Sat Jul 19, 2014 8:29 am (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Templates and Examples/RCHGetTableCell/RCHGetTableCell-Template-IBD-Stock-Checkup.xls
Uploaded by : rharmelink <rharmelink@gmail.com>
Description : Gives examples of using the RCHGetTableCell() function to retrieve data items from IBD's Stock Checkup web page. You will need to log in, creating an IE security cookie, before using the template formulas.

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-IBD-Stock-Checkup.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

rharmelink <rharmelink@gmail.com>

Sat Jul 19, 2014 9:38 am (PDT) . Posted by:

"darryl bonfessuto"

Hello Randy,

I can't download files so I made a new yahoo email for sign in for
access, DMBTrader@yahoo.com may I have access with this email sign in
buy I use the gmail as my Primary email for exchange with the group:
DMB7111@gmail.com. I have never been able to access the files in the
group section under files, it usually states NO FILES.

Thanks for the help
Darryl

On 7/19/14 11:29 AM, smf_addin@yahoogroups.com wrote:
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Templates and
> Examples/RCHGetTableCell/RCHGetTableCell-Template-IBD-Stock-Checkup.xls
> Uploaded by : rharmelink <rharmelink@gmail.com>
> Description : Gives examples of using the RCHGetTableCell() function
> to retrieve data items from IBD's Stock Checkup web page. You will
> need to log in, creating an IE security cookie, before using the
> template formulas.
>
> You can access this file at the URL:
> https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-IBD-Stock-Checkup.xls
>
> To learn more about file sharing for your group, please visit:
> https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
>
> Regards,
>
> rharmelink <rharmelink@gmail.com>
>
>

Sat Jul 19, 2014 10:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's something you can do by editing your identity -- you can add email
addresses:

https://groups.yahoo.com/neo/groups/smf_addin/management/membership

I have no trouble accessing files on any Yahoo groups with my gmail
address, so it may not be the email address. Not sure what would cause the
problem.

I just uploaded it to the SMF web site, so you could grab it from there:

http://ogres-crypt.com/SMF/Templates/RCHGetTableCell-Template-IBD-Stock-Checkup.xls

On Sat, Jul 19, 2014 at 9:38 AM, darryl bonfessuto dmb7111@... wrote:

>
> Hello Randy,
>
> I can't download files so I made a new yahoo email for sign in for
> access, DMBTrader@yahoo.com may I have access with this email sign in buy
> I use the gmail as my Primary email for exchange with the group:
> DMB7111@gmail.com. I have never been able to access the files in the
> group section under files, it usually states NO FILES.
>
> Thanks for the help
> Darryl
>

Sat Jul 19, 2014 10:56 am (PDT) . Posted by:

"darryl bonfessuto"

randy
when i sign in with DMBtrader@yahoo.com
it said i need to be a moderator for that action.
Darryl

On 7/19/14 1:45 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] wrote:
> That's something you can do by editing your identity -- you can add
> email addresses:
>
> https://groups.yahoo.com/neo/groups/smf_addin/management/membership
>
> I have no trouble accessing files on any Yahoo groups with my gmail
> address, so it may not be the email address. Not sure what would cause
> the problem.
>
> I just uploaded it to the SMF web site, so you could grab it from there:
>
> http://ogres-crypt.com/SMF/Templates/RCHGetTableCell-Template-IBD-Stock-Checkup.xls
>
> On Sat, Jul 19, 2014 at 9:38 AM, darryl bonfessuto dmb7111@... wrote:
>
>
> Hello Randy,
>
> I can't download files so I made a new yahoo email for sign in
> for access, DMBTrader@yahoo.com <mailto:DMBTrader@yahoo.com> may I
> have access with this email sign in buy I use the gmail as my
> Primary email for exchange with the group: DMB7111@gmail.com
> <mailto:DMB7111@gmail.com>. I have never been able to access the
> files in the group section under files, it usually states NO FILES.
>
> Thanks for the help
> Darryl
>
>
>

Sat Jul 19, 2014 11:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. When you're on the Yahoo Group page, click on the "Membership"
drop-down box. You want the "Edit Membership" option from the drop-down.
The section on "Identity" allows you to add or change email addresses that
you want to use for the group.

On Sat, Jul 19, 2014 at 10:55 AM, darryl bonfessuto dmb7111@... wrote:

>
> randy
> when i sign in with DMBtrader@yahoo.com
> it said i need to be a moderator for that action.
> Darryl
>

Sat Jul 19, 2014 12:34 pm (PDT) . Posted by:

"James Healey" jchealey66

Hi Randy,

Loving your work and the smf addin, it is great.

Just downloaded your IDB Stock-Checkup.xls but getting error and value in the cells. I have logged in to investors.com via IE and also used the smf fix links macro but no joy.

Do you need to be a premium subscriber to IBDs' investors.com use this template or is there something else I need to do?

Many thanks,

James

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: 19 July 2014 16:29
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New file uploaded to smf_addin

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Templates and Examples/RCHGetTableCell/RCHGetTableCell-Template-IBD-Stock-Checkup.xls
Uploaded by : rharmelink <rharmelink@gmail.com <mailto:rharmelink@gmail.com> >
Description : Gives examples of using the RCHGetTableCell() function to retrieve data items from IBD's Stock Checkup web page. You will need to log in, creating an IE security cookie, before using the template formulas.

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-IBD-Stock-Checkup.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content <https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398> &y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

rharmelink <rharmelink@gmail.com <mailto:rharmelink@gmail.com> >

Sat Jul 19, 2014 12:41 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

IBD has so many different membership options, I'm not even sure what
"premium" means. If you can view a stock checkup page in IE, the add-in
should be able to use the same IE cookie to access that web page. But I
would think the proprietary data on that web page would require some level
of "premium" membership.

Or, did you log in BEFORE using the template? If not, you may need to run
the smfForceRecalculation macro to get a fresh copy of the web page after
you logged in.

Another possibility is that the IE object that EXCEL uses is not the same
as your browser version. If that is the case, you'll need to log in using
the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w), so that you use
that IE object.

A quick check of that would be to open the EXCEL Web Query dialog and see
if you can bring up a Stock Checkup page.

On Sat, Jul 19, 2014 at 11:30 AM, 'James Healey' jameshealey@... wrote:

>
>
> Just downloaded your IDB Stock-Checkup.xls but getting error and value in
> the cells. I have logged in to investors.com via IE and also used the smf
> fix links macro but no joy.
>
>
>
> Do you need to be a premium subscriber to IBDs' investors.com use this
> template or is there something else I need to do?
>

Sat Jul 19, 2014 11:04 am (PDT) . Posted by:

milspasyst

Hi, Is there any way to extract historical EOD Option Chains by date(day to day) for each expiry date from any of the data sources(Yahoo, MSN,etc.)?

Sat Jul 19, 2014 11:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't know of any free sources of historical option quotes that work
reliably. If you do find a source, make sure it has closing bid and ask
prices. Last traded price would be unreliable since it could be hours or
even days old.

On Sat, Jul 19, 2014 at 10:08 AM, milspasyst@... wrote:

> Hi, Is there any way to extract historical EOD Option Chains by
> date(day to day) for each expiry date from any of the data sources(Yahoo,
> MSN,etc.)?
>

Sat Jul 19, 2014 1:08 pm (PDT) . Posted by:

milspasyst

Thank you. I've searched the internet and have only found 2-3 places that have this data but it's not free. The best site appeared to be http://www.tbspinc.com/ http://www.tbspinc.com/ for around $50 per month. They might just be a bargain since they have other historical data with unlimited downloading. Thank you for responding so quickly.

Sat Jul 19, 2014 4:02 pm (PDT) . Posted by:

"Fred Wright" fredwwright

I have been using for a long time:

=RCHGetTableCell("http://Research.investors.com/StockResearch/Quote.aspx?symbol="&A3,1,"groupLdrsTable",,,,1,"</table")

(changing the 1 near the end to 2 or 3 or 4 or 5) to pull the IBD top 5 for the Industry group that the symbol in A3 is in.  

Also, while I am still getting most of the other fields I want from IBD a couple others also stopped working on Thursday: 

=RCHGetTableCell("http://Research.investors.com/StockResearch/StockCheckup.aspx?symbol="&A3,1,">Acc/Dis Rating")
=RCHGetTableCell("http://Research.investors.com/StockResearch/StockCheckup.aspx?symbol="&A3,1,">EPS Est % Chg (Current Yr)")

I think IBD has changed the structure of their page - any advice/suggestions?

Fred

Sat Jul 19, 2014 4:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Check the new version of the template I uploaded earlier today.

If I remember correctly, ">Acc/Dis" was changed to
">Accumulation/Distribution" and ">EPS Est % Chg (Current Yr)" was changed
to ">EPS Est % Chg for Current Year".

All of the group leader items I had on the template were still working, so
I didn't need changes there.

On Sat, Jul 19, 2014 at 4:02 PM, Fred Wright fredwwright@... wrote:

>
> I have been using for a long time:
>
> =RCHGetTableCell("
> http://Research.investors.com/StockResearch/Quote.aspx?symbol=
> "&A3,1,"groupLdrsTable",,,,1,"</table")
>
> (changing the 1 near the end to 2 or 3 or 4 or 5) to pull the IBD top 5
> for the Industry group that the symbol in A3 is in.
>
> Also, while I am still getting most of the other fields I want from IBD a
> couple others also stopped working on Thursday:
>
> =RCHGetTableCell("
> http://Research.investors.com/StockResearch/StockCheckup.aspx?symbol="&A3,1,">Acc/Dis
> Rating")
> =RCHGetTableCell("
> http://Research.investors.com/StockResearch/StockCheckup.aspx?symbol="&A3,1,">EPS
> Est % Chg (Current Yr)")
>
> I think IBD has changed the structure of their page - any
> advice/suggestions?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar