15 New Messages
Digest #2795
Messages
Wed Oct 2, 2013 5:05 am (PDT) . Posted by:
copthornelabs
Randy,
Apologies for the slip of the mouse yesterday.
I have tried to use the smfGetCSVFile to download the fund
holdings from Morningstar using the address you gave me (I
previously tried to use a slightly longer url and it didnt work).
The current problem is this: I want to get holdings for more than
one fund and Im content to cut and paste them to a single
database after individual download.
I can get the first set of holdings to download.
No matter how I try to get another to download (changing the fund
symbol, copy the whole function to next line, re-enter the
function from the beginning) I get the same initial set of fund
holdings.
I set up my spreadsheet with a list of fund symbols in Col a and
am trying to get the holdings in sequential order by entering the
retrieval function in Col B.
Each call opens a new spreadsheet with the downloaded holdings.
So far they appear to be the same set of fund holdings each time.
Can you suggest a better method? Array entering the functions
seems innappropriate.
Dave C.
Wed Oct 2, 2013 6:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. I just entered the function several times with different ticker
symbols and got different lists...
=smfGetCSVFile("
http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX
")
=smfGetCSVFile("
http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=IWM
")
I'm not sure where you're running into problems.
And I'm confused by your array-entering comment.
On Wed, Oct 2, 2013 at 5:05 AM, <davecharlaff@hotmail.com> wrote:
> Apologies for the slip of the mouse yesterday.
>
> I have tried to use the smfGetCSVFile to download the fund holdings from
> Morningstar using the address you gave me (I previously tried to use a
> slightly longer url and it didnt work).
>
> The current problem is this: I want to get holdings for more than one fund
> and Im content to cut and paste them to a single database after individual
> download.
>
> I can get the first set of holdings to download.
>
> No matter how I try to get another to download (changing the fund symbol,
> copy the whole function to next line, re-enter the function from the
> beginning) I get the same initial set of fund holdings.
>
> I set up my spreadsheet with a list of fund symbols in Col a and am trying
> to get the holdings in sequential order by entering the retrieval function
> in Col B.
>
> Each call opens a new spreadsheet with the downloaded holdings. So far
> they appear to be the same set of fund holdings each time.
>
> Can you suggest a better method? Array entering the functions seems
> innappropriate.
>
>
symbols and got different lists...
=smfGetCSVFile(
http://portfolios.
")
=smfGetCSVFile(
http://portfolios.
")
I'm not sure where you're running into problems.
And I'm confused by your array-entering comment.
On Wed, Oct 2, 2013 at 5:05 AM, <davecharlaff@
> Apologies for the slip of the mouse yesterday.
>
> I have tried to use the smfGetCSVFile to download the fund holdings from
> Morningstar using the address you gave me (I previously tried to use a
> slightly longer url and it didnt work).
>
> The current problem is this: I want to get holdings for more than one fund
> and Im content to cut and paste them to a single database after individual
> download.
>
> I can get the first set of holdings to download.
>
> No matter how I try to get another to download (changing the fund symbol,
> copy the whole function to next line, re-enter the function from the
> beginning) I get the same initial set of fund holdings.
>
> I set up my spreadsheet with a list of fund symbols in Col a and am trying
> to get the holdings in sequential order by entering the retrieval function
> in Col B.
>
> Each call opens a new spreadsheet with the downloaded holdings. So far
> they appear to be the same set of fund holdings each time.
>
> Can you suggest a better method? Array entering the functions seems
> innappropriate.
>
>
Wed Oct 2, 2013 8:04 am (PDT) . Posted by:
"Dave Charlaff" copthornelabs
Randy,
BIPIX
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX>
UJPIX
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX>
INPIX
GAAEX
FBIOX
Holdings
FTDZX
DXRLX
This is what I'm trying to get.
IWM
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=IWM>
BIPIX
Holdings
UJPIX
INPIX
GAAEX
The top two rows have different symbols. Yet try as I might, having copied your function into col B, I cannot get the sheet saved with a different symbol.
Each time I either paste your function into col B and change the symbol after the =&t= statement, it returns the holdings for VFINX (what you sent last night).
Question: should this work if I substitute a cell reference for the fund symbol? Eg ..&t=A1") ? I cannot get it to do so.
Question 2: do I need to be logged in to Morningstar for their cookie?
What might be causing the function I entered manually in B2 for BIPIX not to work at all while the function in B1, copied and pasted from your post, works fine?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, October 02, 2013 9:44 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar fund holdings
Hmmm. I just entered the function several times with different ticker symbols and got different lists...
=smfGetCSVFile("http://portfolios.morningstar.com/fund/holdingsExport?exportType=details <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX> &t=VFINX")
=smfGetCSVFile("http://portfolios.morningstar.com/fund/holdingsExport?exportType=details <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=IWM> &t=IWM")
I'm not sure where you're running into problems.
And I'm confused by your array-entering comment.
On Wed, Oct 2, 2013 at 5:05 AM, <davecharlaff@hotmail.com> wrote:
Apologies for the slip of the mouse yesterday.
I have tried to use the smfGetCSVFile to download the fund holdings from Morningstar using the address you gave me (I previously tried to use a slightly longer url and it didnt work).
The current problem is this: I want to get holdings for more than one fund and Im content to cut and paste them to a single database after individual download.
I can get the first set of holdings to download.
No matter how I try to get another to download (changing the fund symbol, copy the whole function to next line, re-enter the function from the beginning) I get the same initial set of fund holdings.
I set up my spreadsheet with a list of fund symbols in Col a and am trying to get the holdings in sequential order by entering the retrieval function in Col B.
Each call opens a new spreadsheet with the downloaded holdings. So far they appear to be the same set of fund holdings each time.
Can you suggest a better method? Array entering the functions seems innappropriate.
BIPIX
Holdings <http://portfolios.
UJPIX
Holdings <http://portfolios.
INPIX
GAAEX
FBIOX
Holdings
FTDZX
DXRLX
This is what I'm trying to get.
IWM
Holdings <http://portfolios.
BIPIX
Holdings
UJPIX
INPIX
GAAEX
The top two rows have different symbols. Yet try as I might, having copied your function into col B, I cannot get the sheet saved with a different symbol.
Each time I either paste your function into col B and change the symbol after the =&t= statement, it returns the holdings for VFINX (what you sent last night).
Question: should this work if I substitute a cell reference for the fund symbol? Eg ..&t=A1") ? I cannot get it to do so.
Question 2: do I need to be logged in to Morningstar for their cookie?
What might be causing the function I entered manually in B2 for BIPIX not to work at all while the function in B1, copied and pasted from your post, works fine?
From: smf_addin@yahoogrou
Sent: Wednesday, October 02, 2013 9:44 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Morningstar fund holdings
Hmmm. I just entered the function several times with different ticker symbols and got different lists...
=smfGetCSVFile(
=smfGetCSVFile(
I'm not sure where you're running into problems.
And I'm confused by your array-entering comment.
On Wed, Oct 2, 2013 at 5:05 AM, <davecharlaff@
Apologies for the slip of the mouse yesterday.
I have tried to use the smfGetCSVFile to download the fund holdings from Morningstar using the address you gave me (I previously tried to use a slightly longer url and it didnt work).
The current problem is this: I want to get holdings for more than one fund and Im content to cut and paste them to a single database after individual download.
I can get the first set of holdings to download.
No matter how I try to get another to download (changing the fund symbol, copy the whole function to next line, re-enter the function from the beginning) I get the same initial set of fund holdings.
I set up my spreadsheet with a list of fund symbols in Col a and am trying to get the holdings in sequential order by entering the retrieval function in Col B.
Each call opens a new spreadsheet with the downloaded holdings. So far they appear to be the same set of fund holdings each time.
Can you suggest a better method? Array entering the functions seems innappropriate.
Wed Oct 2, 2013 8:21 am (PDT) . Posted by:
"Dave Charlaff" copthornelabs
Randy,
Solved the problem.
The copy and paste function in excel is my culprit. I pasted just the formula this time, changed the symbol and voila! it works fine.
Many apologies for being too damn tired late at night to troubleshoot properly.
Truly sorry to bother you with such a triviality.
Thx
Dave C.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Dave Charlaff
Sent: Wednesday, October 02, 2013 11:05 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Morningstar fund holdings
Randy,
BIPIX
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX>
UJPIX
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX>
INPIX
GAAEX
FBIOX
Holdings
FTDZX
DXRLX
This is what I'm trying to get.
IWM
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=IWM>
BIPIX
Holdings
UJPIX
INPIX
GAAEX
The top two rows have different symbols. Yet try as I might, having copied your function into col B, I cannot get the sheet saved with a different symbol.
Each time I either paste your function into col B and change the symbol after the =&t= statement, it returns the holdings for VFINX (what you sent last night).
Question: should this work if I substitute a cell reference for the fund symbol? Eg ..&t=A1") ? I cannot get it to do so.
Question 2: do I need to be logged in to Morningstar for their cookie?
What might be causing the function I entered manually in B2 for BIPIX not to work at all while the function in B1, copied and pasted from your post, works fine?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, October 02, 2013 9:44 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar fund holdings
Hmmm. I just entered the function several times with different ticker symbols and got different lists...
=smfGetCSVFile("http://portfolios.morningstar.com/fund/holdingsExport?exportType=details <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX> &t=VFINX")
=smfGetCSVFile("http://portfolios.morningstar.com/fund/holdingsExport?exportType=details <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=IWM> &t=IWM")
I'm not sure where you're running into problems.
And I'm confused by your array-entering comment.
On Wed, Oct 2, 2013 at 5:05 AM, <davecharlaff@hotmail.com> wrote:
Apologies for the slip of the mouse yesterday.
I have tried to use the smfGetCSVFile to download the fund holdings from Morningstar using the address you gave me (I previously tried to use a slightly longer url and it didnt work).
The current problem is this: I want to get holdings for more than one fund and Im content to cut and paste them to a single database after individual download.
I can get the first set of holdings to download.
No matter how I try to get another to download (changing the fund symbol, copy the whole function to next line, re-enter the function from the beginning) I get the same initial set of fund holdings.
I set up my spreadsheet with a list of fund symbols in Col a and am trying to get the holdings in sequential order by entering the retrieval function in Col B.
Each call opens a new spreadsheet with the downloaded holdings. So far they appear to be the same set of fund holdings each time.
Can you suggest a better method? Array entering the functions seems innappropriate.
Solved the problem.
The copy and paste function in excel is my culprit. I pasted just the formula this time, changed the symbol and voila! it works fine.
Many apologies for being too damn tired late at night to troubleshoot properly.
Truly sorry to bother you with such a triviality.
Thx
Dave C.
From: smf_addin@yahoogrou
Sent: Wednesday, October 02, 2013 11:05 AM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] Morningstar fund holdings
Randy,
BIPIX
Holdings <http://portfolios.
UJPIX
Holdings <http://portfolios.
INPIX
GAAEX
FBIOX
Holdings
FTDZX
DXRLX
This is what I'm trying to get.
IWM
Holdings <http://portfolios.
BIPIX
Holdings
UJPIX
INPIX
GAAEX
The top two rows have different symbols. Yet try as I might, having copied your function into col B, I cannot get the sheet saved with a different symbol.
Each time I either paste your function into col B and change the symbol after the =&t= statement, it returns the holdings for VFINX (what you sent last night).
Question: should this work if I substitute a cell reference for the fund symbol? Eg ..&t=A1") ? I cannot get it to do so.
Question 2: do I need to be logged in to Morningstar for their cookie?
What might be causing the function I entered manually in B2 for BIPIX not to work at all while the function in B1, copied and pasted from your post, works fine?
From: smf_addin@yahoogrou
Sent: Wednesday, October 02, 2013 9:44 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Morningstar fund holdings
Hmmm. I just entered the function several times with different ticker symbols and got different lists...
=smfGetCSVFile(
=smfGetCSVFile(
I'm not sure where you're running into problems.
And I'm confused by your array-entering comment.
On Wed, Oct 2, 2013 at 5:05 AM, <davecharlaff@
Apologies for the slip of the mouse yesterday.
I have tried to use the smfGetCSVFile to download the fund holdings from Morningstar using the address you gave me (I previously tried to use a slightly longer url and it didnt work).
The current problem is this: I want to get holdings for more than one fund and Im content to cut and paste them to a single database after individual download.
I can get the first set of holdings to download.
No matter how I try to get another to download (changing the fund symbol, copy the whole function to next line, re-enter the function from the beginning) I get the same initial set of fund holdings.
I set up my spreadsheet with a list of fund symbols in Col a and am trying to get the holdings in sequential order by entering the retrieval function in Col B.
Each call opens a new spreadsheet with the downloaded holdings. So far they appear to be the same set of fund holdings each time.
Can you suggest a better method? Array entering the functions seems innappropriate.
Wed Oct 2, 2013 8:22 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You do have to array-enter the formula. Not sure why you're getting links.
It looks like you want to transpose the results, so I did this:
BIPIX Holdings Amgen Inc Gilead Sciences Inc AbbVie Inc UJPIX Holdings Nikkei
225 Cme Fut Jun13 Profunds Swap Secuirty Gs INPIX Holdings Google, Inc.
Class A Amazon.com Inc eBay Inc GAAEX Holdings SunPower Corporation Vestas
Wind Systems A/S Good Energy Group PLC FBIOX Holdings Gilead Sciences
Inc Amgen
Inc Celgene Corporation FTDZX Holdings Gilead Sciences Inc Celgene
Corporation Biogen Idec Inc DXRLX Holdings Russell Index Swap Bllt
My formula looks something like:
=TRANSPOSE(smfGetCSVFile("
http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=
"&C4,,20,1))
On Wed, Oct 2, 2013 at 8:04 AM, Dave Charlaff <davecharlaff@hotmail.com>wrote:
>
>
> Randy,****
>
> BIPIX ****
>
> *Holdings<http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX>
> *
>
> UJPIX ****
>
> *Holdings<http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX>
> *
>
> INPIX ****
>
> GAAEX****
>
> FBIOX ****
>
> *Holdings*
>
> FTDZX****
>
> DXRLX****
>
> ** **
>
> This is what I'm trying to get.****
>
> IWM****
>
> *Holdings<http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=IWM>
> *
>
> BIPIX ****
>
> *Holdings*
>
> UJPIX ****
>
> INPIX ****
>
> GAAEX****
>
> ****
>
> ** **
>
> ** **
>
> * *
>
> ** **
>
> * *
>
> ** **
>
> ** **
>
> The top two rows have different symbols. Yet try as I might, having copied
> your function into col B, I cannot get the sheet saved with a different
> symbol.****
>
> Each time I either paste your function into col B and change the symbol
> after the =&t= statement, it returns the holdings for VFINX (what you sent
> last night).****
>
> ** **
>
> Question: should this work if I substitute a cell reference for the fund
> symbol? Eg ..&t=A1") ? I cannot get it to do so.****
>
> Question 2: do I need to be logged in to Morningstar for their cookie?****
>
> ** **
>
> What might be causing the function I entered manually in B2 for BIPIX not
> to work at all while the function in B1, copied and pasted from your post,
> works fine?
>
It looks like you want to transpose the results, so I did this:
BIPIX Holdings Amgen Inc Gilead Sciences Inc AbbVie Inc UJPIX Holdings Nikkei
225 Cme Fut Jun13 Profunds Swap Secuirty Gs INPIX Holdings Google, Inc.
Class A Amazon.com Inc eBay Inc GAAEX Holdings SunPower Corporation Vestas
Wind Systems A/S Good Energy Group PLC FBIOX Holdings Gilead Sciences
Inc Amgen
Inc Celgene Corporation FTDZX Holdings Gilead Sciences Inc Celgene
Corporation Biogen Idec Inc DXRLX Holdings Russell Index Swap Bllt
My formula looks something like:
=TRANSPOSE(smfGetCS
http://portfolios.
"&C4,,20,
On Wed, Oct 2, 2013 at 8:04 AM, Dave Charlaff <davecharlaff@
>
>
> Randy,****
>
> BIPIX ****
>
> *Holdings<http://portfolios.
> *
>
> UJPIX ****
>
> *Holdings<http://portfolios.
> *
>
> INPIX ****
>
> GAAEX****
>
> FBIOX ****
>
> *Holdings*
>
> FTDZX****
>
> DXRLX****
>
> ** **
>
> This is what I'm trying to get.****
>
> IWM****
>
> *Holdings<http://portfolios.
> *
>
> BIPIX ****
>
> *Holdings*
>
> UJPIX ****
>
> INPIX ****
>
> GAAEX****
>
> ****
>
> ** **
>
> ** **
>
> * *
>
> ** **
>
> * *
>
> ** **
>
> ** **
>
> The top two rows have different symbols. Yet try as I might, having copied
> your function into col B, I cannot get the sheet saved with a different
> symbol.****
>
> Each time I either paste your function into col B and change the symbol
> after the =&t= statement, it returns the holdings for VFINX (what you sent
> last night).****
>
> ** **
>
> Question: should this work if I substitute a cell reference for the fund
> symbol? Eg ..&t=A1") ? I cannot get it to do so.****
>
> Question 2: do I need to be logged in to Morningstar for their cookie?****
>
> ** **
>
> What might be causing the function I entered manually in B2 for BIPIX not
> to work at all while the function in B1, copied and pasted from your post,
> works fine?
>
Wed Oct 2, 2013 8:57 am (PDT) . Posted by:
"Dave Charlaff" copthornelabs
Much more elegant and better than my solution.
I humbly thank you
Last question on this: I actually want the stock symbol only, which is under the Equity Prices tab, and I would like to capture all 25 symbols only in order, left to right, in each row opposite the fund symbol.
I presume that the array must be at least 26 columns wide? How would the get CSV file function be amended to go to this page?
Dave C.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, October 02, 2013 11:23 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar fund holdings
You do have to array-enter the formula. Not sure why you're getting links. It looks like you want to transpose the results, so I did this:
BIPIX
Holdings
Amgen Inc
Gilead Sciences Inc
AbbVie Inc
UJPIX
Holdings
Nikkei 225 Cme Fut Jun13
Profunds Swap Secuirty Gs
INPIX
Holdings
Google, Inc. Class A
Amazon.com Inc
eBay Inc
GAAEX
Holdings
SunPower Corporation
Vestas Wind Systems A/S
Good Energy Group PLC
FBIOX
Holdings
Gilead Sciences Inc
Amgen Inc
Celgene Corporation
FTDZX
Holdings
Gilead Sciences Inc
Celgene Corporation
Biogen Idec Inc
DXRLX
Holdings
Russell Index Swap Bllt
My formula looks something like:
=TRANSPOSE(smfGetCSVFile("http://portfolios.morningstar.com/fund/holdingsExport?exportType=details <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=> &t="&C4,,20,1))
On Wed, Oct 2, 2013 at 8:04 AM, Dave Charlaff <davecharlaff@hotmail.com> wrote:
Randy,
BIPIX
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX>
UJPIX
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=VFINX>
INPIX
GAAEX
FBIOX
Holdings
FTDZX
DXRLX
This is what I'm trying to get.
IWM
Holdings <http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=IWM>
BIPIX
Holdings
UJPIX
INPIX
GAAEX
The top two rows have different symbols. Yet try as I might, having copied your function into col B, I cannot get the sheet saved with a different symbol.
Each time I either paste your function into col B and change the symbol after the =&t= statement, it returns the holdings for VFINX (what you sent last night).
Question: should this work if I substitute a cell reference for the fund symbol? Eg ..&t=A1") ? I cannot get it to do so.
Question 2: do I need to be logged in to Morningstar for their cookie?
What might be causing the function I entered manually in B2 for BIPIX not to work at all while the function in B1, copied and pasted from your post, works fine?
I humbly thank you
Last question on this: I actually want the stock symbol only, which is under the Equity Prices tab, and I would like to capture all 25 symbols only in order, left to right, in each row opposite the fund symbol.
I presume that the array must be at least 26 columns wide? How would the get CSV file function be amended to go to this page?
Dave C.
From: smf_addin@yahoogrou
Sent: Wednesday, October 02, 2013 11:23 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Morningstar fund holdings
You do have to array-enter the formula. Not sure why you're getting links. It looks like you want to transpose the results, so I did this:
BIPIX
Holdings
Amgen Inc
Gilead Sciences Inc
AbbVie Inc
UJPIX
Holdings
Nikkei 225 Cme Fut Jun13
Profunds Swap Secuirty Gs
INPIX
Holdings
Google, Inc. Class A
Amazon.com Inc
eBay Inc
GAAEX
Holdings
SunPower Corporation
Vestas Wind Systems A/S
Good Energy Group PLC
FBIOX
Holdings
Gilead Sciences Inc
Amgen Inc
Celgene Corporation
FTDZX
Holdings
Gilead Sciences Inc
Celgene Corporation
Biogen Idec Inc
DXRLX
Holdings
Russell Index Swap Bllt
My formula looks something like:
=TRANSPOSE(smfGetCS
On Wed, Oct 2, 2013 at 8:04 AM, Dave Charlaff <davecharlaff@
Randy,
BIPIX
Holdings <http://portfolios.
UJPIX
Holdings <http://portfolios.
INPIX
GAAEX
FBIOX
Holdings
FTDZX
DXRLX
This is what I'm trying to get.
IWM
Holdings <http://portfolios.
BIPIX
Holdings
UJPIX
INPIX
GAAEX
The top two rows have different symbols. Yet try as I might, having copied your function into col B, I cannot get the sheet saved with a different symbol.
Each time I either paste your function into col B and change the symbol after the =&t= statement, it returns the holdings for VFINX (what you sent last night).
Question: should this work if I substitute a cell reference for the fund symbol? Eg ..&t=A1") ? I cannot get it to do so.
Question 2: do I need to be logged in to Morningstar for their cookie?
What might be causing the function I entered manually in B2 for BIPIX not to work at all while the function in B1, copied and pasted from your post, works fine?
Wed Oct 2, 2013 9:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Then change the formula to something like:
=TRANSPOSE(INDEX(smfGetCSVFile("
http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=SPY
",,26,4),,4))
On Wed, Oct 2, 2013 at 8:57 AM, Dave Charlaff <davecharlaff@hotmail.com>wrote:
>
>
> Much more elegant and better than my solution. ****
>
> ** **
>
> I humbly thank you****
>
> ** **
>
> Last question on this: I actually want the stock symbol only, which is
> under the Equity Prices tab, and I would like to capture all 25 *symbols
> only* in order, left to right, in each row opposite the fund symbol.****
>
> I presume that the array must be at least 26 columns wide? How would the
> get CSV file function be amended to go to this page?****
>
> ** **
>
> Dave C.
>
=TRANSPOSE(INDEX(
http://portfolios.
",,26,4)
On Wed, Oct 2, 2013 at 8:57 AM, Dave Charlaff <davecharlaff@
>
>
> Much more elegant and better than my solution. ****
>
> ** **
>
> I humbly thank you****
>
> ** **
>
> Last question on this: I actually want the stock symbol only, which is
> under the Equity Prices tab, and I would like to capture all 25 *symbols
> only* in order, left to right, in each row opposite the fund symbol.****
>
> I presume that the array must be at least 26 columns wide? How would the
> get CSV file function be amended to go to this page?****
>
> ** **
>
> Dave C.
>
Wed Oct 2, 2013 5:35 am (PDT) . Posted by:
petekoch
I learned to use the parameters from Randy (who else ?) in the
message he cites.
---In smf_addin@yahoogrou
Hey petekoch.
I am very new to all this. I am trying to use thee smfgetcsv
function. My question is how did you hard-code the URL to get
the exact table you want? I would greatly appreciate your
response. I have recently learned to write VBA I am trying my
best to learn quickly.
---In smf_addin@yahoogrou
The Altman_Piotroski.
and Quarterly Morningstar data for both the Income Statement and
the Balance Sheet.
Wed Oct 2, 2013 9:49 am (PDT) . Posted by:
jovica.bozic
Everything was working as it should until today. Now
RCHGetTableCell or RCHGetWebData are not working on Yahoo
Finance. Formula that I'm using :
=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_r\
ates",3,"20yr AAA")
Also view html source on link above shows all yields but can not
get any results (Error) using RCHGetWebData.
If some1 can help...Thanks.
RCHGetTableCell or RCHGetWebData are not working on Yahoo
Finance. Formula that I'm using :
=RCHGetTableCell(
ates",3,"
Also view html source on link above shows all yields but can not
get any results (Error) using RCHGetWebData.
If some1 can help...Thanks.
Wed Oct 2, 2013 9:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your formula worked fine for me. Probably just a temp glitch with Yahoo or
you communications, so you errored out in retrieving the web page.
Just use the smfForceRecalculation macro to get a fresh copy of the web
page for the add-in. See the LINKS area of the group for more info on that
macro.
On Wed, Oct 2, 2013 at 9:49 AM, <jovica.bozic@yahoo.com> wrote:
>
> Everything was working as it should until today. Now RCHGetTableCell or
> RCHGetWebData are not working on Yahoo Finance. Formula that I'm using :
> =RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",3,"20yr
> AAA")
>
> Also view html source on link above shows all yields but can not get any
> results (Error) using RCHGetWebData.
>
> If some1 can help...Thanks.
>
you communications, so you errored out in retrieving the web page.
Just use the smfForceRecalculati
page for the add-in. See the LINKS area of the group for more info on that
macro.
On Wed, Oct 2, 2013 at 9:49 AM, <jovica.bozic@
>
> Everything was working as it should until today. Now RCHGetTableCell or
> RCHGetWebData are not working on Yahoo Finance. Formula that I'm using :
> =RCHGetTableCell(
> AAA")
>
> Also view html source on link above shows all yields but can not get any
> results (Error) using RCHGetWebData.
>
> If some1 can help...Thanks.
>
Wed Oct 2, 2013 12:05 pm (PDT) . Posted by:
jovica.bozic
You were right. It was some temporary glitch. Strange thing was
that all other formulas were working fine even those using data
from YF summary page. Never happened to me before.
Thank you.
---In smf_addin@yahoogrou
Your formula worked fine for me. Probably just a temp glitch with
Yahoo or you communications, so you errored out in retrieving the
web page.
Just use the smfForceRecalculati
the web page for the add-in. See the LINKS area of the group for
more info on that macro.
On Wed, Oct 2, 2013 at 9:49 AM, <jovica.bozic@
<mailto:jovica.
Everything was working as it should until today. Now
RCHGetTableCell or RCHGetWebData are not working on Yahoo
Finance. Formula that I'm using :
=RCHGetTableCell(
ates <http://finance.
",3,"
Also view html source on link above shows all yields but can not
get any results (Error) using RCHGetWebData.
If some1 can help...Thanks.
Wed Oct 2, 2013 10:03 am (PDT) . Posted by:
option2z
Just checking to see if anyone else is having similar
problems.RCHGetElementNumber
13865 13867 990 989Aren't working as of this morning. (But
13862 is working). Perhaps just a short term (I hope) YAHOO
glitch. Or, maybe something has gone awry with my system.
I downloaded the latest TXT files (1 and 4) that have changed.
Restarted Excel (2013). But since at least one is working, I'm
suspecting that YAHOO has, sigh, once again changed
something.Pete A
problems.RCHGetElem
13865 13867 990 989Aren'
13862 is working). Perhaps just a short term (I hope) YAHOO
glitch. Or, maybe something has gone awry with my system.
I downloaded the latest TXT files (1 and 4) that have changed.
Restarted Excel (2013). But since at least one is working, I'm
suspecting that YAHOO has, sigh, once again changed
something.Pete A
Wed Oct 2, 2013 12:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I tried the elements with ticker MMM and got blanks for the first two and
"Error" for the last two. When I go to Yahoo with my browser, there are no
sector name and industry name listed (the first two items), and the key
statistics page doesn't exists (from which the list two items would be
extracted).
So it's definitely a Yahoo problem. Hopefully temporary.
On Wed, Oct 2, 2013 at 10:03 AM, <optionzz@gmail.com> wrote:
>
> Just checking to see if anyone else is having similar problems.
> RCHGetElementNumber
> *13865* *13867* *990* *989*Aren't working as of this morning. (But 13862
> is working). Perhaps just a short term (I hope) YAHOO glitch. Or, maybe
> something has gone awry with my system.
>
> I downloaded the latest TXT files (1 and 4) that have changed. Restarted
> Excel (2013). But since at least one is working, I'm suspecting that YAHOO
> has, sigh, once again changed something.
>
>
"Error" for the last two. When I go to Yahoo with my browser, there are no
sector name and industry name listed (the first two items), and the key
statistics page doesn't exists (from which the list two items would be
extracted).
So it's definitely a Yahoo problem. Hopefully temporary.
On Wed, Oct 2, 2013 at 10:03 AM, <optionzz@gmail.
>
> Just checking to see if anyone else is having similar problems.
> RCHGetElementNumber
> *13865* *13867* *990* *989*Aren'
> is working). Perhaps just a short term (I hope) YAHOO glitch. Or, maybe
> something has gone awry with my system.
>
> I downloaded the latest TXT files (1 and 4) that have changed. Restarted
> Excel (2013). But since at least one is working, I'm suspecting that YAHOO
> has, sigh, once again changed something.
>
>
Wed Oct 2, 2013 6:36 pm (PDT) . Posted by:
gpommer1982
I'm always impressed with the knowledge base of this group so I
thought I'd throw this out as I've been scratching my head. Has
anyone built a stock screener in Excel? I've been building some
financial analysis spreadsheets and have no problem analyzing a
single company but I'd like to make custom screens to sort
through and return companies that meet my criteria. My
programming knowledge is pretty basic but I haven't found
anything out in cyberspace that describes how one would go about
doing this.
Thanks in advance.
thought I'd throw this out as I've been scratching my head. Has
anyone built a stock screener in Excel? I've been building some
financial analysis spreadsheets and have no problem analyzing a
single company but I'd like to make custom screens to sort
through and return companies that meet my criteria. My
programming knowledge is pretty basic but I haven't found
anything out in cyberspace that describes how one would go about
doing this.
Thanks in advance.
Wed Oct 2, 2013 7:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Please don't use the add-in to build a stock screener. I would consider it
an abuse of the free data sources.
Instead, you should be using the on-line screeners to get down to a
manageable number of stocks, and then use the add-in to get more detailed
information on that small group.
For a good online screener (and a backtester free of survivorship bias),
I'd recommend Portfolio123.com.
On Wed, Oct 2, 2013 at 6:36 PM, <gpommer1982@yahoo.com> wrote:
>
> I'm always impressed with the knowledge base of this group so I thought
> I'd throw this out as I've been scratching my head. Has anyone built a
> stock screener in Excel? I've been building some financial analysis
> spreadsheets and have no problem analyzing a single company but I'd like to
> make custom screens to sort through and return companies that meet my
> criteria. My programming knowledge is pretty basic but I haven't found
> anything out in cyberspace that describes how one would go about doing this.
>
>
>
an abuse of the free data sources.
Instead, you should be using the on-line screeners to get down to a
manageable number of stocks, and then use the add-in to get more detailed
information on that small group.
For a good online screener (and a backtester free of survivorship bias),
I'd recommend Portfolio123.
On Wed, Oct 2, 2013 at 6:36 PM, <gpommer1982@
>
> I'm always impressed with the knowledge base of this group so I thought
> I'd throw this out as I've been scratching my head. Has anyone built a
> stock screener in Excel? I've been building some financial analysis
> spreadsheets and have no problem analyzing a single company but I'd like to
> make custom screens to sort through and return companies that meet my
> criteria. My programming knowledge is pretty basic but I haven't found
> anything out in cyberspace that describes how one would go about doing this.
>
>
>
Tidak ada komentar:
Posting Komentar