Selasa, 17 Februari 2015

[smf_addin] Digest Number 3327

8 Messages

Digest #3327
1b
Re: smfGetOptionQuote on google spreadsheet by "Randy Harmelink" rharmelink
2a
Company Fundamentals Workbook by bobsledproductions
2c
Re: Company Fundamentals Workbook by "Randy Harmelink" rharmelink
2d
Re: Company Fundamentals Workbook by "Randy Harmelink" rharmelink
2f
Re: Company Fundamentals Workbook by "Randy Harmelink" rharmelink

Messages

Mon Feb 16, 2015 3:41 am (PST) . Posted by:

d.asodekar

Hi,
Can we run smfGetOptionQuote on google spreadsheet...

Mon Feb 16, 2015 4:42 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Nope. Google spreadsheets won't run the VBA code.

However, there are ways to pull data into Google spreadsheets, using their
functions. For example, this:

=importhtml("http://finance.yahoo.com/q?s=GE160115C00025000","table",0)

...pulls in this:

Prev Close: 1.25 Open: 1.1 Bid: 1.32 Ask: 1.37 Strike: 25 Expire Date:
1/15/2016
If you just wanted the bid price, you can use the Google spreadsheet
INDEX() function like this:

=index(importhtml("http://finance.yahoo.com/q?s=GE160115C00025000
","table",0),3,2)

If you just want the data values spread in a row, you could do something
like:

=transpose(index(importhtml("http://finance.yahoo.com/q?s="&A19
,"table",0),,2))

...referring to the ticker symbol in another cell, ending up with a row
like this:

GE160115C00025000 1.25 1.1 1.32 1.37 25 1/15/2016
You can get all calls or puts for a given ticker symbol and a given date
with:

=importHTML("http://finance.yahoo.com/q/op?s=MMM&date=1424995200","table",2)
=importHTML("http://finance.yahoo.com/q/op?s=MMM&date=1424995200","table",3)

If you put the ticker symbol in cell B2 and the expiration date in cell B3,
you can create that URL with:

="http://finance.yahoo.com/q/op?s="&B2&"&date="&86400*(B3-date(1970,1,1))

On Mon, Feb 16, 2015 at 4:41 AM, d.asodekar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Can we run smfGetOptionQuote on google spreadsheet...
>

Mon Feb 16, 2015 11:12 am (PST) . Posted by:

bobsledproductions

Take a look at the Company Fundamentals workbook. It allows you to view the 10 most recent periods and look at the values either as reported, in common size form, or the % change from the prior period. It leverages the advfn.com data to do this.


Company Fundamentals | The Toteboard @Toteboard.net http://toteboard.net/blog/workbooks/company-fundamentals/



http://toteboard.net/blog/workbooks/company-fundamentals/

Company Fundamentals | The Toteboard @Toteboard.net http://toteboard.net/blog/workbooks/company-fundamentals/ Functionality Overview



View on toteboard.net http://toteboard.net/blog/workbooks/company-fundamentals/
Preview by Yahoo






Mon Feb 16, 2015 3:51 pm (PST) . Posted by:

jimmymc00

Nice work. I was able to download into Excel 2013 and view each work sheet. I could not use any of the menu choices to change the stock being analyzed. It would present a choice but I could not select it, e.g. report type - annual or quarterly. I saw that the file was being shown in "protected mode" so clicked on the enable icon. Message then appeared that said linkages were now disengaged or words to that effect. All the values in the spread sheet went to #name! Downloaded again, enabled worksheet and got same result. Not sure how to get around this.


-----Original Message-----
From: JPeters3515@snet.net [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Mon, Feb 16, 2015 2:12 pm
Subject: [smf_addin] Company Fundamentals Workbook

Take a look at the Company Fundamentals workbook. It allows you to view the 10 most recent periods and look at the values either as reported, in common size form, or the % change from the prior period. It leverages the advfn.com data to do this.

Company Fundamentals | The Toteboard @Toteboard.net

Company Fundamentals | The Toteboard @Toteboard.net
Functionality Overview







View on toteboard.net



Preview by Yahoo







Mon Feb 16, 2015 4:23 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you may have unresolved links, or location errors? If so, just
running the smfFixLinks macro might solve it.

On Mon, Feb 16, 2015 at 4:51 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Nice work. I was able to download into Excel 2013 and view each work
> sheet. I could not use any of the menu choices to change the stock being
> analyzed. It would present a choice but I could not select it, e.g. report
> type - annual or quarterly. I saw that the file was being shown in
> "protected mode" so clicked on the enable icon. Message then appeared that
> said linkages were now disengaged or words to that effect. All the values
> in the spread sheet went to #name! Downloaded again, enabled worksheet and
> got same result. Not sure how to get around this.
>

Mon Feb 16, 2015 4:26 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You have an external link that can't be resolved:

='C:\SMF Add-In\Templates\[CompanyTemplate.xlsm]Company'!$L$2

...in cell AE1 of the Data worksheet.

On Mon, Feb 16, 2015 at 12:12 PM, JPeters3515@snet.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Take a look at the Company Fundamentals workbook. It allows you to view
> the 10 most recent periods and look at the values either as reported, in
> common size form, or the % change from the prior period. It leverages the
> advfn.com data to do this.
>
> Company Fundamentals | The Toteboard @Toteboard.net
> <http://toteboard.net/blog/workbooks/company-fundamentals/>
> [image: image]
> <http://toteboard.net/blog/workbooks/company-fundamentals/>
> Company Fundamentals | The Toteboard @Toteboard.net
> <http://toteboard.net/blog/workbooks/company-fundamentals/>
> Functionality Overview
> View on toteboard.net
> <http://toteboard.net/blog/workbooks/company-fundamentals/>
> Preview by Yahoo
>
>
>

Mon Feb 16, 2015 4:34 pm (PST) . Posted by:

jimmymc00

Thanks Randy. I do have the SMF Add-In directory in C: but no Templates directory. How do I rectify?


-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Mon, Feb 16, 2015 7:26 pm
Subject: Re: [smf_addin] Company Fundamentals Workbook

You have an external link that can't be resolved:

='C:\SMF Add-In\Templates\[CompanyTemplate.xlsm]Company'!$L$2

...in cell AE1 of the Data worksheet.

On Mon, Feb 16, 2015 at 12:12 PM, JPeters3515@snet.net [smf_addin] <smf_addin@yahoogroups.com> wrote:

Take a look at the Company Fundamentals workbook. It allows you to view the 10 most recent periods and look at the values either as reported, in common size form, or the % change from the prior period. It leverages the advfn.com data to do this.

Company Fundamentals | The Toteboard @Toteboard.net

Company Fundamentals | The Toteboard @Toteboard.net
Functionality Overview







View on toteboard.net



Preview by Yahoo







Mon Feb 16, 2015 6:12 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You don't need to. That was a correction for the author of the workbook.

On Mon, Feb 16, 2015 at 5:34 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks Randy. I do have the SMF Add-In directory in C: but no Templates
> directory. How do I rectify?
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar