8 Messages
Digest #3327
Messages
Mon Feb 16, 2015 3:41 am (PST) . Posted by:
d.asodekar
Hi,
Can we run smfGetOptionQuote on google spreadsheet...
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...
>
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
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
-----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.
>
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
>
>
>
='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
-----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?
>
>
>
>
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:
Posting Komentar