Sabtu, 14 Maret 2015

[smf_addin] Digest Number 3355

5 Messages

Digest #3355

Messages

Fri Mar 13, 2015 4:31 am (PDT) . Posted by:

pandion1976

The RCHGetElementNumber function does not appear to be working correctly when pulling information for the financial data elements. From the templates folder, I downloaded the SMF-Template-Google-Balance-Sheet-Tables.xls http://ogres-crypt.com/SMF/Templates/SMF-Template-Google-Balance-Sheet-Tables.xls template to my computer. When I type in the ticker symbol "PAYX" or "IDCC", all of the correct information is displayed. However, when I type in the "AAPL" symbol, all I get is error messages; even though the annual and quarterly report information is made available through Google's financial website. I am finding the same type of problems when pulling information using the AdvFN data elements. Other examples of where the information is not correctly being pulled include: IBM, LOW, MAT, and the list goes on.


Am I doing something wrong or is this a problem with the function? Any help would be much obliged.


Thanks.




Fri Mar 13, 2015 4:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

For AdvFN, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28118

For both AdvFN and Google, you may need to change your IE (cross-domain?)
settings. See the AdvFN entry on the "FAQs and Tips" web page.

In any case, I just tried the Google template. Both AAPL and IBM worked for
me. Without something malfunctioning here, there's not a whole lot for me
to look at to diagnose the problem. But I'm not sure why some would work
and others not...

On Fri, Mar 13, 2015 at 4:29 AM, pandion1976@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> The RCHGetElementNumber function does not appear to be working correctly
> when pulling information for the financial data elements. From the
> templates folder, I downloaded the
> SMF-Template-Google-Balance-Sheet-Tables.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Google-Balance-Sheet-Tables.xls> template
> to my computer. When I type in the ticker symbol "PAYX" or "IDCC", all of
> the correct information is displayed. However, when I type in the "AAPL"
> symbol, all I get is error messages; even though the annual and quarterly
> report information is made available through Google's financial website. I
> am finding the same type of problems when pulling information using
> the AdvFN data elements. Other examples of where the information is not
> correctly being pulled include: IBM, LOW, MAT, and the list goes on.
>
> Am I doing something wrong or is this a problem with the function? Any
> help would be much obliged.
>
>

Fri Mar 13, 2015 10:39 am (PDT) . Posted by:

"Pete A" option2z

Hi Folks,
Anyone know how to use SMF to test a stock for weekly option support?
I have a fair list of otherwise desirable stocks, but want to add weeklies
as a test criteria.

Thanks!

Pete A
<http://www.ttp-s.com/> TtP-S Investing

Fri Mar 13, 2015 11:05 am (PDT) . Posted by:

"Randy Randall" randyr_cds

Pete -

I don't know of a way to do it through SMF, but I found a macro that I
modified.

P.S. I added comments through out the macro after copying here, so hope I
didn't dork it up.

Randy

Sub Import_CBOE_Weeklys()
Dim wbMe As Workbook
Dim wbURL As Workbook
Dim url As String

Set wbMe = ThisWorkbook
url = "http://www.cboe.com/publish/weelkysmf/weeklysmf.xls"

'## Clear out previous week's data from local spreadsheet
wbMe.Sheets("CBOE Weeklys").Activate
wbMe.Sheets("CBOE Weeklys").Rows.Delete

'## Open CBOE weeklys spreadsheet
Set wbURL = Workbooks.Open(url)

'## Only select most recent week's data. Find "Ticker", then select
down->Right
' Note there are 2 "Ticker" in the first column. The second "Ticker" is
for the previous week.

wbURL.Sheets("Sheet1").Activate
wbURL.Sheets("Sheet1").Columns(1).Find(What:="Ticker").Activate
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select

'## Copy & Paste this data in to our worksheet:'
Selection.Cells.Copy Destination:=wbMe.Sheets("CBOE Weeklys").Range("A1")

'## Close the downloaded version which we no longer need:'
wbURL.Close SaveChanges:=False

On Fri, Mar 13, 2015 at 1:39 PM, Pete A optionzz@outlook.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hi Folks,
>
> Anyone know how to use SMF to test a stock for weekly option support?
>
> I have a fair list of otherwise desirable stocks, but want to add weeklies
> as a test criteria.
>
>
>
> Thanks!
>
>
>
> Pete A
>
> *TtP-S* Investing <http://www.ttp-s.com/>
>
>
>
>
>

Fri Mar 13, 2015 12:50 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can grab the XLS file from the CBOE website without the add-in or any
VBA coding. Just array-enter a formula something like this and it will load
the data from that online XLS file directly into your workbook:

=IF('
http://www.cboe.com/publish/weelkysmf/[weeklysmf.xls]Sheet1'!$A$1:$M$2000=
"","",'
http://www.cboe.com/publish/weelkysmf/[weeklysmf.xls]Sheet1'!$A$1:$M$2000)

On Fri, Mar 13, 2015 at 10:39 AM, Pete A optionzz@outlook.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Anyone know how to use SMF to test a stock for weekly option support?
>
> I have a fair list of otherwise desirable stocks, but want to add weeklies
> as a test criteria.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar