15 Messages
Digest #3328
Messages
Tue Feb 17, 2015 6:00 am (PST) . Posted by:
bobsledproductions
Missed one. Fixed, zipped, and re-published. Apols for that.
Tue Feb 17, 2015 8:07 am (PST) . Posted by:
jimmymc00
Thanks. Re downloaded and saw the PG sheets. Looks good by the way. However, still experiencing same issues: the spreadsheet opens in a protective mode, can't select from drop down menus and when I enable editing I get a message back that says the links are disabled and all data immediately turns to #name?
Pretty sure the problem is on my end. Downloaded a few other sheets with same problem. Any advice would be appreciated.
-----Original Message-----
From: JPeters3515@snet.net [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 17, 2015 9:00 am
Subject: Re: [smf_addin] Company Fundamentals Workbook
Missed one. Fixed, zipped, and re-published. Apols for that.
Pretty sure the problem is on my end. Downloaded a few other sheets with same problem. Any advice would be appreciated.
-----Original Message-----
From: JPeters3515@snet.net [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 17, 2015 9:00 am
Subject: Re: [smf_addin] Company Fundamentals Workbook
Missed one. Fixed, zipped, and re-published. Apols for that.
Tue Feb 17, 2015 11:51 am (PST) . Posted by:
bobsledproductions
Take a look here, it may help you uncover your issues:
What is Protected View? https://support.office.com/en-au/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653
https://support.office.com/en-au/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653
What is Protected View? https://support.office.com/en-au/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653 Protected View is a read-only mode in which most editing functions are disabled to help protect you from potentially malicious software.
View on support.office.com https://support.office.com/en-au/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653
Preview by Yahoo
Is it just my workbooks, or have you had problems with other workbooks, and the addin itself?
What is Protected View? https://support.office.com/en-au/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653
https://support.office.com/en-au/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653
What is Protected View? https://support.office.com/en-au/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653 Protected View is a read-only mode in which most editing functions are disabled to help protect you from potentially malicious software.
View on support.office.com https://support.office.com/en-au/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653
Preview by Yahoo
Is it just my workbooks, or have you had problems with other workbooks, and the addin itself?
Tue Feb 17, 2015 12:44 pm (PST) . Posted by:
jimmymc00
Thanks I'll check it out. The trouble occurs with the 3 or 4 spreadsheets I've downloaded so far. Not just yours. I'm sure there is a setting somewhere that I need to change.
-----Original Message-----
From: JPeters3515@snet.net [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 17, 2015 2:51 pm
Subject: Re: [smf_addin] Company Fundamentals Workbook
Take a look here, it may help you uncover your issues:
What is Protected View?
What is Protected View?
Protected View is a read-only mode in which most editing functions are disabled to help protect you from potentially malicious software.
< /div>
View on support.office.com
Preview by Yahoo
Is it just my workbooks, or have you had problems with other workbooks, and the addin itself?
-----Original Message-----
From: JPeters3515@snet.net [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 17, 2015 2:51 pm
Subject: Re: [smf_addin] Company Fundamentals Workbook
Take a look here, it may help you uncover your issues:
What is Protected View?
What is Protected View?
Protected View is a read-only mode in which most editing functions are disabled to help protect you from potentially malicious software.
< /div>
View on support.office.
Preview by Yahoo
Is it just my workbooks, or have you had problems with other workbooks, and the addin itself?
Tue Feb 17, 2015 1:18 pm (PST) . Posted by:
jimmymc00
No help. No matter what protection or security function I allow the document continues to open with a Security Warning: Automatic update of links has been disabled. Once the Enable Content button is selected the spreadsheet values are replaced with !name?
-----Original Message-----
From: jmcatee133@aol.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 17, 2015 3:44 pm
Subject: Re: [smf_addin] Company Fundamentals Workbook
Thanks I'll check it out. The trouble occurs with the 3 or 4 spreadsheets I've downloaded so far. Not just yours. I'm sure there is a setting somewhere that I need to change.
-----Original Message-----
From: JPeters3515@snet.net [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 17, 2015 2:51 pm
Subject: Re: [smf_addin] Company Fundamentals Workbook
Take a look here, it may help you uncover your issues:
What is Protected View?
What is Protected View?
Protected View is a read-only mode in which most editing functions are disabled to help protect you from potentially malicious software.
< /div>
View on support.office.com
Preview by Yahoo
Is it just my workbooks, or have you had problems with other workbooks, and the addin itself?
-----Original Message-----
From: jmcatee133@aol.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 17, 2015 3:44 pm
Subject: Re: [smf_addin] Company Fundamentals Workbook
Thanks I'll check it out. The trouble occurs with the 3 or 4 spreadsheets I've downloaded so far. Not just yours. I'm sure there is a setting somewhere that I need to change.
-----Original Message-----
From: JPeters3515@snet.net [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 17, 2015 2:51 pm
Subject: Re: [smf_addin] Company Fundamentals Workbook
Take a look here, it may help you uncover your issues:
What is Protected View?
What is Protected View?
Protected View is a read-only mode in which most editing functions are disabled to help protect you from potentially malicious software.
< /div>
View on support.office.
Preview by Yahoo
Is it just my workbooks, or have you had problems with other workbooks, and the addin itself?
Tue Feb 17, 2015 2:51 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Did you try smfFixLinks?
On Tue, Feb 17, 2015 at 2:18 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> No help. No matter what protection or security function I allow the
> document continues to open with a Security Warning: Automatic update of
> links has been disabled. Once the Enable Content button is selected the
> spreadsheet values are replaced with !name?
>
On Tue, Feb 17, 2015 at 2:18 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> No help. No matter what protection or security function I allow the
> document continues to open with a Security Warning: Automatic update of
> links has been disabled. Once the Enable Content button is selected the
> spreadsheet values are replaced with !name?
>
Tue Feb 17, 2015 10:56 am (PST) . Posted by:
kitiany
Randy, anyone:
I attempted to parse data out of this site for nutrition stats to no avail.
http://nutritiondata.self.com/facts/vegetables-and-vegetable-products/2626/2 http://nutritiondata.self.com/facts/vegetables-and-vegetable-products/2626/2
Are the tables generated from some other program and in the web page at all?
Thanks,
Kit
I attempted to parse data out of this site for nutrition stats to no avail.
http://nutritiondata.self.com/facts/vegetables-and-vegetable-products/2626/2 http://nutritiondata.self.com/facts/vegetables-and-vegetable-products/2626/2
Are the tables generated from some other program and in the web page at all?
Thanks,
Kit
Tue Feb 17, 2015 11:39 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I don't see where the data is being loaded from...
On Tue, Feb 17, 2015 at 11:56 AM, Kitiany@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Randy, anyone:
>
> I attempted to parse data out of this site for nutrition stats to no avail.
>
>
> http://nutritiondata.self.com/facts/vegetables-and-vegetable-products/2626/2
>
> Are the tables generated from some other program and in the web page at
> all?
>
>
On Tue, Feb 17, 2015 at 11:56 AM, Kitiany@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Randy, anyone:
>
> I attempted to parse data out of this site for nutrition stats to no avail.
>
>
> http://nutritiondata.self.com/facts/vegetables-and-vegetable-products/2626/2
>
> Are the tables generated from some other program and in the web page at
> all?
>
>
Tue Feb 17, 2015 2:35 pm (PST) . Posted by:
option2z
Tried searching the Conversation archive in the SMF Yahoo group...but no luck. Does anyone know how to simply test to see if a ticker is a member of an index (preferably the S&P).
Maybe like:
=SMFsomefunction(Ticker, IndexName) (Boolean).
Thanks for any ideas on how to approach.
Pete A
Maybe like:
=SMFsomefunction(
Thanks for any ideas on how to approach.
Pete A
Tue Feb 17, 2015 2:57 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You could check for the index on the components web page on Yahoo:
http://finance.yahoo.com/q/ct?s=MMM
For example:
=IF(RCHGetTableCell("http://finance.yahoo.com/q/ct?s=MMM",0,"Indices that
include",">^DJI")="Error","No","Yes")
=IF(RCHGetTableCell("http://finance.yahoo.com/q/ct?s=MMM",0,"Indices that
include",">^GSPC")="Error","No","Yes")
On Tue, Feb 17, 2015 at 3:35 PM, optionzz@... wrote:
> Tried searching the Conversation archive in the SMF Yahoo group...but no
> luck. Does anyone know how to simply test to see if a ticker is a member
> of an index (preferably the S&P).
>
> Maybe like:
>
> =SMFsomefunction(Ticker, IndexName) (Boolean).
>
> Thanks for any ideas on how to approach.
>
>
http://finance.yahoo.com/q/ct?s=MMM
For example:
=IF(RCHGetTableCell("http://finance.yahoo.com/q/ct?s=MMM",0,"Indices that
include",">^DJI")="Error","No","Yes")
=IF(RCHGetTableCell("http://finance.yahoo.com/q/ct?s=MMM",0,"
include"
On Tue, Feb 17, 2015 at 3:35 PM, optionzz@... wrote:
> Tried searching the Conversation archive in the SMF Yahoo group...but no
> luck. Does anyone know how to simply test to see if a ticker is a member
> of an index (preferably the S&P).
>
> Maybe like:
>
> =SMFsomefunction(
>
> Thanks for any ideas on how to approach.
>
>
Tue Feb 17, 2015 6:03 pm (PST) . Posted by:
lexstar
Does anyone know if it's possible to pull data from Daily Finance website? For example, I want to pull symbol INCMX from:
http://www.dailyfinance.com/quote/NASDAQMUTFUND/fundx-flexible-income-fund/INCMX/historical-prices http://www.dailyfinance.com/quote/NASDAQMUTFUND/fundx-flexible-income-fund/INCMX/historical-prices?
Thanks in advance!
http://www.dailyfinance.com/quote/NASDAQMUTFUND/fundx-flexible-income-fund/INCMX/historical-prices http://www.dailyfinance.com/quote/NASDAQMUTFUND/fundx-flexible-income-fund/INCMX/historical-prices?
Thanks in advance!
Tue Feb 17, 2015 6:08 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The historical data is within a frame, so you need to access that frame's
URL. For example:
=RCHGetHTMLTable("
http://www.motleyfool.idmanagedsolutions.com/stocks/historical_quotes.idms?START_DATE=2013-02-17&END_DATE=2015-02-17&CODE_MARKET=US,@US&SYMBOL_US=INCMX&BLOCKSIZE=500&OFFSET=0","Historical
Rating",-1,"",1)
On Tue, Feb 17, 2015 at 7:03 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does anyone know if it's possible to pull data from Daily Finance website?
> For example, I want to pull symbol INCMX from:
>
>
> http://www.dailyfinance.com/quote/NASDAQMUTFUND/fundx-flexible-income-fund/INCMX/historical-prices
> ?
>
>
URL. For example:
=RCHGetHTMLTable("
http://www.motleyfool.idmanagedsolutions.com/stocks/historical_quotes.idms?START_DATE=2013-02-17&END_DATE=2015-02-17&CODE_MARKET=US,@US&SYMBOL_US=INCMX&BLOCKSIZE=500&OFFSET=0","Historical
Rating",-1,"",1)
On Tue, Feb 17, 2015 at 7:03 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does anyone know if it's possible to pull data from Daily Finance website?
> For example, I want to pull symbol INCMX from:
>
>
> http://www.dailyfinance.com/quote/NASDAQMUTFUND/fundx-flexible-income-fund/INCMX/historical-prices
> ?
>
>
Tue Feb 17, 2015 6:10 pm (PST) . Posted by:
lexstar
I meant to say, from this link, would it be possible to pull say the "CLOSE" data given a specific date, ie. 1/2/2015?
Tue Feb 17, 2015 6:17 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just do something like:
=RCHGetTableCell("
http://www.motleyfool.idmanagedsolutions.com/stocks/historical_quotes.idms?START_DATE=2015-01-01&END_DATE=2015-01-10&CODE_MARKET=US,@US&SYMBOL_US=INCMX&BLOCKSIZE=100&OFFSET=0
",4,"01/02/2015")
On Tue, Feb 17, 2015 at 7:10 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I meant to say, from this link, would it be possible to pull say the
> "CLOSE" data given a specific date, ie. 1/2/2015?
>
>
=RCHGetTableCell("
http://www.motleyfool.idmanagedsolutions.com/stocks/historical_quotes.idms?START_DATE=2015-01-01&END_DATE=2015-01-10&CODE_MARKET=US,@US&SYMBOL_US=INCMX&BLOCKSIZE=100&OFFSET=0
",4,"01/02/2015")
On Tue, Feb 17, 2015 at 7:10 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I meant to say, from this link, would it be possible to pull say the
> "CLOSE" data given a specific date, ie. 1/2/2015?
>
>
Tue Feb 17, 2015 6:22 pm (PST) . Posted by:
lexstar
If I have a cell with the date 01/02/2015, how do I refer to that cell in your given formula without using the quotation?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar