Selasa, 17 Februari 2015

[smf_addin] Digest Number 3328

15 Messages

Digest #3328
1a
1c
1f
Re: Company Fundamentals Workbook by "Randy Harmelink" rharmelink
2a
2b
Re: Nutrition Data Page by "Randy Harmelink" rharmelink
4a
DailyFinance by lexstar
4b
Re: DailyFinance by "Randy Harmelink" rharmelink
4c
4d
Re: DailyFinance by "Randy Harmelink" rharmelink
4e

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.

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?


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?

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?

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?
>

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

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?
>
>

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

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&quot;,"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.
>
>

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!


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
> ?
>
>

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?
>
>

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