15 New Messages
Digest #2964
Messages
Wed Feb 12, 2014 12:53 am (PST) . Posted by:
carron948
HI Randy,
Do you have to this for Australia as well ue "AU" in the "smf-AdvFN-Prefix.txt" file.
Regards,
Ballterrier1
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
What you can do is create a file in the same folder as add-in, called "smf-AdvFN-Prefix.txt", All the file should contain is the two letters "uk". You can create the file with Notepad. This file overrides the add-in default, and the add-in will then use the "uk" version of the URL instead of the default "www" version of the URL.
You'll need the 2.1.2012.12.29 version of the add-in for this to work...
On Sun, Jan 27, 2013 at 7:26 AM, Rosendo Manuel <rosendo.jose@... mailto:rosendo.jose@...> wrote:
I'm living in Lisbon (Portugal) and you are right. When I entered your suggested address the browser redirected me to "http://uk.advfn.com/p.php?pid=financials&symbol=MMM http://uk.advfn.com/p.php?pid=financials&symbol=MMM".
Is there a way to force it to work properly (as I desire, of course :))?
Do you have to this for Australia as well ue "AU" in the "smf-AdvFN-
Regards,
Ballterrier1
---In smf_addin@yahoogrou
What you can do is create a file in the same folder as add-in, called "smf-AdvFN-
You'll need the 2.1.2012.12.
On Sun, Jan 27, 2013 at 7:26 AM, Rosendo Manuel <rosendo.
I'm living in Lisbon (Portugal) and you are right. When I entered your suggested address the browser redirected me to "http://uk.advfn.
Is there a way to force it to work properly (as I desire, of course :))?
Wed Feb 12, 2014 12:55 am (PST) . Posted by:
"Randy Harmelink" rharmelink
As far as I know, as long as that is where you're redirected, but I have no
way to test it myself.
"UK" was just an example.
On Wed, Feb 12, 2014 at 1:41 AM, <carron948@yahoo.com.au> wrote:
> Do you have to this for Australia as well ue "AU" in the
> "smf-AdvFN-Prefix.txt" file.
> ---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
>
> What you can do is create a file in the same folder as add-in, called
> "smf-AdvFN-Prefix.txt", All the file should contain is the two letters
> "uk". You can create the file with Notepad. This file overrides the add-in
> default, and the add-in will then use the "uk" version of the URL instead
> of the default "www" version of the URL.
>
> You'll need the 2.1.2012.12.29 version of the add-in for this to work...
>
> On Sun, Jan 27, 2013 at 7:26 AM, Rosendo Manuel <rosendo.jose@...> wrote:
>
>
> I'm living in Lisbon (Portugal) and you are right. When I entered your
> suggested address the browser redirected me to "
> http://uk.advfn.com/p.php?pid=financials&symbol=MMM".
> Is there a way to force it to work properly (as I desire, of course :))?
>
>
way to test it myself.
"UK" was just an example.
On Wed, Feb 12, 2014 at 1:41 AM, <carron948@yahoo.
> Do you have to this for Australia as well ue "AU" in the
> "smf-AdvFN-
> ---In smf_addin@yahoogrou
>
> What you can do is create a file in the same folder as add-in, called
> "smf-AdvFN-
> "uk"
> default, and the add-in will then use the "uk" version of the URL instead
> of the default "www" version of the URL.
>
> You'll need the 2.1.2012.12.
>
> On Sun, Jan 27, 2013 at 7:26 AM, Rosendo Manuel <rosendo.
>
>
> I'm living in Lisbon (Portugal) and you are right. When I entered your
> suggested address the browser redirected me to "
> http://uk.advfn.
> Is there a way to force it to work properly (as I desire, of course :))?
>
>
Wed Feb 12, 2014 1:32 pm (PST) . Posted by:
7fdc563d58c7c22f83a4739671305987
Awesome awesome add-in, I absolutely love it. Lately my excel workbook has been unable to complete the recalculate process, it just grinds to a halt and doesn't respond. I've read a few threads about using smfUpdateTable macro, but I'm not sure if that did anything when I tried it. I think I've narrowed my issue to a specific worksheet, I'm guessing there's a website down in one of the formulas. Do you know of a way to tell which formula is causing the hangup, or which URL is down so I can fix the formula? I'll be most grateful for any suggestions. Thank you so much!
Wed Feb 12, 2014 1:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The progress of smfUpdateDownloadTable can be seen in two ways:
1. The status line at the bottom of the worksheet
2. Delete all the data you're going to retrieve, and you'll see the visible
portion of the worksheet "fill in"
I don't know of any way to pinpoint a specific formula failing because of a
web site that is down. It will be obvious for smfUpdateDownloadTable, as
long as it is in the visible area of the worksheet, because the "fill in"
will pause at that point. For a long time.
The most common reason for a slow responding worksheet is the use of
numerous RCHGetYahooQuotes() functions. Especially lately, since Yahoo
seems to be slowed down. From time to time, quite a bit. The solution there
is to array-enter RCHGetYahooQuotes() functions over a range, going to as
few of them as possible.
On Wed, Feb 12, 2014 at 2:11 PM, <cjbcathouse5@gmail.com> wrote:
>
> Awesome awesome add-in, I absolutely love it. Lately my excel workbook
> has been unable to complete the recalculate process, it just grinds to a
> halt and doesn't respond. I've read a few threads about using
> smfUpdateTable macro, but I'm not sure if that did anything when I tried
> it. I think I've narrowed my issue to a specific worksheet, I'm guessing
> there's a website down in one of the formulas. Do you know of a way to
> tell which formula is causing the hangup, or which URL is down so I can fix
> the formula? I'll be most grateful for any suggestions. Thank you so much!
>
1. The status line at the bottom of the worksheet
2. Delete all the data you're going to retrieve, and you'll see the visible
portion of the worksheet "fill in"
I don't know of any way to pinpoint a specific formula failing because of a
web site that is down. It will be obvious for smfUpdateDownloadTa
long as it is in the visible area of the worksheet, because the "fill in"
will pause at that point. For a long time.
The most common reason for a slow responding worksheet is the use of
numerous RCHGetYahooQuotes(
seems to be slowed down. From time to time, quite a bit. The solution there
is to array-enter RCHGetYahooQuotes(
few of them as possible.
On Wed, Feb 12, 2014 at 2:11 PM, <cjbcathouse5@
>
> Awesome awesome add-in, I absolutely love it. Lately my excel workbook
> has been unable to complete the recalculate process, it just grinds to a
> halt and doesn't respond. I've read a few threads about using
> smfUpdateTable macro, but I'm not sure if that did anything when I tried
> it. I think I've narrowed my issue to a specific worksheet, I'm guessing
> there's a website down in one of the formulas. Do you know of a way to
> tell which formula is causing the hangup, or which URL is down so I can fix
> the formula? I'll be most grateful for any suggestions. Thank you so much!
>
Wed Feb 12, 2014 1:32 pm (PST) . Posted by:
ganevniko
Hi,
I am trying to create a spreadsheet that could give the most recent s&p500, s&p600 and s&p400 components. Is there a smf function that could help me ?
Wed Feb 12, 2014 1:44 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Which function to use would depend on your data source. For my own use, I
usually just grab the components of the ETF that is supposed to match the
index. For example:
=smfGetCSVFile("
http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=SPY
")
On Wed, Feb 12, 2014 at 2:21 PM, <ganevniko@yahoo.com> wrote:
>
> I am trying to create a spreadsheet that could give the most recent
> s&p500, s&p600 and s&p400 components. Is there a smf function that could
> help me ?
>
usually just grab the components of the ETF that is supposed to match the
index. For example:
=smfGetCSVFile(
http://portfolios.
")
On Wed, Feb 12, 2014 at 2:21 PM, <ganevniko@yahoo.
>
> I am trying to create a spreadsheet that could give the most recent
> s&p500, s&p600 and s&p400 components. Is there a smf function that could
> help me ?
>
Wed Feb 12, 2014 2:09 pm (PST) . Posted by:
"Nikola Ganev" ganevniko
Thank you Randy but this link opens a new window with the csv file and all the data is in the first column I need to convert it manually, is there not a way to get it clean right away and be able to update it every time I want ?
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 12, 2014 10:44 PM
Subject: Re: [smf_addin] Getting S&P500 components
Which function to use would depend on your data source. For my own use, I usually just grab the components of the ETF that is supposed to match the index. For example:
=smfGetCSVFile("http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=SPY")
On Wed, Feb 12, 2014 at 2:21 PM, <ganevniko@yahoo.com> wrote:
>I am trying to create a spreadsheet that could give the most recent s&p500, s&p600 and s&p400 components. Is there a smf function that could help me ?
>
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Wednesday, February 12, 2014 10:44 PM
Subject: Re: [smf_addin] Getting S&P500 components
Which function to use would depend on your data source. For my own use, I usually just grab the components of the ETF that is supposed to match the index. For example:
=smfGetCSVFile(
On Wed, Feb 12, 2014 at 2:21 PM, <ganevniko@yahoo.
>I am trying to create a spreadsheet that could give the most recent s&p500, s&p600 and s&p400 components. Is there a smf function that could help me ?
>
Wed Feb 12, 2014 2:31 pm (PST) . Posted by:
mikemcq802
You can retrieve the constituents of S&P indices from S&P's site. Example:
http://us.spindices.com/idsexport/file.xls?hostIdentifier=48190c8c-42c4-46af-8d1a-0cd5db894797&selectedModule=c&indexId=340 http://us.spindices.com/idsexport/file.xls?hostIdentifier=48190c8c-42c4-46af-8d1a-0cd5db894797&selectedModule=c&indexId=340
Downloads the constituents for the 500. I found this link by:
1) Go to S&P's site for the index
http://us.spindices.com/indices/equity/sp-500 http://us.spindices.com/indices/equity/sp-500
2) Click the constituents tab next to the performance tab
3) right-click the "Export" button and note the URL displayed (FF shows at the bottom, e.g.)
This exports as XLS which you could then link to from your base workbook. These indices don't change very often so a refresh shouldn't be often needed.
http://us.spindices
Downloads the constituents for the 500. I found this link by:
1) Go to S&P's site for the index
http://us.spindices
2) Click the constituents tab next to the performance tab
3) right-click the "Export" button and note the URL displayed (FF shows at the bottom, e.g.)
This exports as XLS which you could then link to from your base workbook. These indices don't change very often so a refresh shouldn'
Wed Feb 12, 2014 2:46 pm (PST) . Posted by:
"Nikola Ganev" ganevniko
Thank you, it works
________________________________
From: "mikemcq802@yahoo.com" <mikemcq802@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 12, 2014 11:31 PM
Subject: Re: [smf_addin] Getting S&P500 components
You can retrieve the constituents of S&P indices from S&P's site. Example:
http://us.spindices.com/idsexport/file.xls?hostIdentifier=48190c8c-42c4-46af-8d1a-0cd5db894797&selectedModule=c&indexId=340
Downloads the constituents for the 500. I found this link by:
1) Go to S&P's site for the index
http://us.spindices.com/indices/equity/sp-500
2) Click the constituents tab next to the performance tab
3) right-click the "Export" button and note the URL displayed (FF shows at the bottom, e.g.)
This exports as XLS which you could then link to from your base workbook. These indices don't change very often so a refresh shouldn't be often needed.
____________
From: "mikemcq802@yahoo.
To: smf_addin@yahoogrou
Sent: Wednesday, February 12, 2014 11:31 PM
Subject: Re: [smf_addin] Getting S&P500 components
You can retrieve the constituents of S&P indices from S&P's site. Example:
http://us.spindices
Downloads the constituents for the 500. I found this link by:
1) Go to S&P's site for the index
http://us.spindices
2) Click the constituents tab next to the performance tab
3) right-click the "Export" button and note the URL displayed (FF shows at the bottom, e.g.)
This exports as XLS which you could then link to from your base workbook. These indices don't change very often so a refresh shouldn'
Wed Feb 12, 2014 3:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't get the symptoms you describe when I use the formula. It opens it
clean right away, and updates any time I open the workbook, or run the
smfForceRecalculation macro. To double-check, I just cut and pasted the
formula that was repeated in your message, and it worked fine here.
For example, the first few rows and first few columns look like this:
Holdings Weighting Type Ticker Style Apple Inc 2.96 EQUITY AAPL
Large Core Exxon
Mobil Corporation 2.43 EQUITY XOM Large Value Google, Inc. Class A 2.05
EQUITY GOOG Large Growth Microsoft Corporation 1.74 EQUITY MSFT Large
Core Johnson
& Johnson 1.6 EQUITY JNJ Large Value
Did you array-enter it over a range?
On Wed, Feb 12, 2014 at 3:07 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
> Thank you Randy but this link opens a new window with the csv file and all
> the data is in the first column I need to convert it manually, is there not
> a way to get it clean right away and be able to update it every time I want
> ?
>
> *From:* Randy Harmelink <rharmelink@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Wednesday, February 12, 2014 10:44 PM
> *Subject:* Re: [smf_addin] Getting S&P500 components
>
> Which function to use would depend on your data source. For my own use,
> I usually just grab the components of the ETF that is supposed to match the
> index. For example:
>
> =smfGetCSVFile("
> http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=SPY
> ")
>
clean right away, and updates any time I open the workbook, or run the
smfForceRecalculati
formula that was repeated in your message, and it worked fine here.
For example, the first few rows and first few columns look like this:
Holdings Weighting Type Ticker Style Apple Inc 2.96 EQUITY AAPL
Large Core Exxon
Mobil Corporation 2.43 EQUITY XOM Large Value Google, Inc. Class A 2.05
EQUITY GOOG Large Growth Microsoft Corporation 1.74 EQUITY MSFT Large
Core Johnson
& Johnson 1.6 EQUITY JNJ Large Value
Did you array-enter it over a range?
On Wed, Feb 12, 2014 at 3:07 PM, Nikola Ganev <ganevniko@yahoo.
>
> Thank you Randy but this link opens a new window with the csv file and all
> the data is in the first column I need to convert it manually, is there not
> a way to get it clean right away and be able to update it every time I want
> ?
>
> *From:* Randy Harmelink <rharmelink@gmail.
> *To:* smf_addin@yahoogrou
> *Sent:* Wednesday, February 12, 2014 10:44 PM
> *Subject:* Re: [smf_addin] Getting S&P500 components
>
> Which function to use would depend on your data source. For my own use,
> I usually just grab the components of the ETF that is supposed to match the
> index. For example:
>
> =smfGetCSVFile(
> http://portfolios.
> ")
>
Wed Feb 12, 2014 5:18 pm (PST) . Posted by:
curt.brandt@ymail.com
Why is get element number 25 obsolete?
What is the simplest way to get the last close for one stock?
What is the simplest way to get the last close for one stock?
Wed Feb 12, 2014 7:01 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I obsoleted element #25 because ever since MSN redesigned their stock print
page last year (or was it 2012?), they've been posting the previous day's
closing price as the "Last Price".
Instead, use:
=RCHGetYahooQuotes("MMM","l1")
If you have a number of requests, see the documentation on how to
array-enter the formula so you can speed up your retrieval time
significantly.
On Wed, Feb 12, 2014 at 6:18 PM, <curt_brandt@verizon.net> wrote:
> Why is get element number 25 obsolete?
>
> What is the simplest way to get the last close for one stock?
>
page last year (or was it 2012?), they've been posting the previous day's
closing price as the "Last Price".
Instead, use:
=RCHGetYahooQuotes(
If you have a number of requests, see the documentation on how to
array-enter the formula so you can speed up your retrieval time
significantly.
On Wed, Feb 12, 2014 at 6:18 PM, <curt_brandt@
> Why is get element number 25 obsolete?
>
> What is the simplest way to get the last close for one stock?
>
Wed Feb 12, 2014 6:43 pm (PST) . Posted by:
whichwaytobeach
Hello Folks,
I am grateful to have SMF as a tool, it really helps create powerful financial spreadsheets.
I want to make a dividend history graph, much like those done by the Dividend Channel, http://www.dividendchannel.com/history/?symbol=jnj http://www.dividendchannel.com/history/?symbol=jnj , but don't see the table elements to pull this data together. Does anyone know the data element index numbers? In other words, I don't think I am able to make a histogram, because there isn't a yearly, past 10 years or more RCH Elements at my disposal.
Help?
Thanks,
Marc
I am grateful to have SMF as a tool, it really helps create powerful financial spreadsheets.
I want to make a dividend history graph, much like those done by the Dividend Channel, http://www.dividend
Help?
Thanks,
Marc
Wed Feb 12, 2014 6:54 pm (PST) . Posted by:
mikemcq802
See Randy and my comments in this thread:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/24929 https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/24929
https://groups.
Wed Feb 12, 2014 7:01 pm (PST) . Posted by:
tc_nyc85
What I use to get dividend history is the RCHgetyahoohistory function (which when entered as an array gets you the dividend history). The syntax is as follows =rchgetyahoohistory("ticker",,,,,,,"v"). Make sure you include the V, that's what tells it you want the dividend history).
Tidak ada komentar:
Posting Komentar