15 New Messages
Digest #2821
Messages
Mon Oct 21, 2013 5:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetYahooQuotes() for current quotes from Yahoo.
RCHGetYahooHistory() for historical quotes from Yahoo.
On Mon, Oct 21, 2013 at 4:56 PM, <cschwartz@nf.sympatico.ca> wrote:
> I am sure this has been covered, but I can not find it anywhere - is
> there a way to pull Mutual Fund quotes with this add-in.
>
> If so, how? Thanks.
>
RCHGetYahooHistory(
On Mon, Oct 21, 2013 at 4:56 PM, <cschwartz@nf.
> I am sure this has been covered, but I can not find it anywhere - is
> there a way to pull Mutual Fund quotes with this add-in.
>
> If so, how? Thanks.
>
Mon Oct 21, 2013 5:15 pm (PDT) . Posted by:
stumpy_chris
Thanks... I try this, but comes up blank... Which mutual fund code do I use. Can you give me an example.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
RCHGetYahooQuotes() for current quotes from Yahoo.
RCHGetYahooHistory() for historical quotes from Yahoo.
On Mon, Oct 21, 2013 at 4:56 PM, <cschwartz@... mailto:cschwartz@...> wrote:
I am sure this has been covered, but I can not find it anywhere - is there a way to pull Mutual Fund quotes with this add-in.
If so, how? Thanks.
---In smf_addin@yahoogrou
RCHGetYahooQuotes(
RCHGetYahooHistory(
On Mon, Oct 21, 2013 at 4:56 PM, <cschwartz@
I am sure this has been covered, but I can not find it anywhere - is there a way to pull Mutual Fund quotes with this add-in.
If so, how? Thanks.
Mon Oct 21, 2013 5:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This should return the last traded price:
=RCHGetYahooQuotes("VFINX";,"l1")
This would need to be array-entered over a range:
=RCHGetYahooQuotes("VFINX";)
And both functions have additional parameters to customize what is returned.
On Mon, Oct 21, 2013 at 5:15 PM, <cschwartz@nf.sympatico.ca> wrote:
> Thanks... I try this, but comes up blank... Which mutual fund code do I
> use. Can you give me an example.
>
=RCHGetYahooQuotes(
This would need to be array-entered over a range:
=RCHGetYahooQuotes(
And both functions have additional parameters to customize what is returned.
On Mon, Oct 21, 2013 at 5:15 PM, <cschwartz@nf.
> Thanks... I try this, but comes up blank... Which mutual fund code do I
> use. Can you give me an example.
>
Mon Oct 21, 2013 5:47 pm (PDT) . Posted by:
stumpy_chris
Thanks... Worked for your example, but I am trying it for Russell Lifepoints Balanced Sr B - here is the symbol from Yahoo Finance (F0CAN071IY.TO) and I get 0 value.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
This should return the last traded price:
=RCHGetYahooQuotes("VFINX";,"l1")
This would need to be array-entered over a range:
=RCHGetYahooQuotes("VFINX";)
And both functions have additional parameters to customize what is returned.
On Mon, Oct 21, 2013 at 5:15 PM, <cschwartz@... mailto:cschwartz@...> wrote:
Thanks... I try this, but comes up blank... Which mutual fund code do I use. Can you give me an example.
---In smf_addin@yahoogrou
This should return the last traded price:
=RCHGetYahooQuotes(
This would need to be array-entered over a range:
=RCHGetYahooQuotes(
And both functions have additional parameters to customize what is returned.
On Mon, Oct 21, 2013 at 5:15 PM, <cschwartz@
Thanks... I try this, but comes up blank... Which mutual fund code do I use. Can you give me an example.
Mon Oct 21, 2013 5:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's the value Yahoo is providing on their CSV file feed (which is what
RCHGetYahooQuotes() uses).
However, since they do carry historical quotes, you could get the most
recent closing price with:
=RCHGetYahooHistory("F0CAN071IY.TO",,,,,,,,"a",0)
...but the current day's quote probably won't be available until about 6 pm
EST.
On Mon, Oct 21, 2013 at 5:47 PM, <cschwartz@nf.sympatico.ca> wrote:
> Thanks... Worked for your example, but I am trying it for Russell
> Lifepoints Balanced Sr B - here is the symbol from Yahoo Finance (
> F0CAN071IY.TO) and I get 0 value.
>
RCHGetYahooQuotes(
However, since they do carry historical quotes, you could get the most
recent closing price with:
=RCHGetYahooHistory
...but the current day's quote probably won't be available until about 6 pm
EST.
On Mon, Oct 21, 2013 at 5:47 PM, <cschwartz@nf.
> Thanks... Worked for your example, but I am trying it for Russell
> Lifepoints Balanced Sr B - here is the symbol from Yahoo Finance (
> F0CAN071IY.TO) and I get 0 value.
>
Mon Oct 21, 2013 5:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They probably calculate them on the fly, since you can specify any period
you want for the moving averages. Just because they calculate them there
doesn't mean they would provide them on the CSV file feed, or state the
average on any of their web pages.
You could always calculate it yourself from their historical quotes, but it
would be a slow process if you need it for a number of funds. For example:
=AVERAGE(RCHGetYahooHistory("FBIOX";,,,,,,,,"a",0,,,50,1))
By the way, this would give you a different answer for stocks and ETFs than
what Yahoo provides. Because, for some reason, Yahoo's 50-day (and 200-day)
moving average values are based on the number of calendar days instead of
trading days.
On Mon, Oct 21, 2013 at 4:58 PM, <lewglenn@yahoo.com> wrote:
> When I go to Yahoo! Finance and pull up FBIOX, then go to 'Charts >
> Interactive' I can display the price of this fund over any period I choose,
> and also (under Technical Indicators) the SMA over any period I choose. So
> Yahoo most certainly computes the 50-day moving average. The question then,
> is where does it store this info.
>
you want for the moving averages. Just because they calculate them there
doesn't mean they would provide them on the CSV file feed, or state the
average on any of their web pages.
You could always calculate it yourself from their historical quotes, but it
would be a slow process if you need it for a number of funds. For example:
=AVERAGE(RCHGetYaho
By the way, this would give you a different answer for stocks and ETFs than
what Yahoo provides. Because, for some reason, Yahoo's 50-day (and 200-day)
moving average values are based on the number of calendar days instead of
trading days.
On Mon, Oct 21, 2013 at 4:58 PM, <lewglenn@yahoo.
> When I go to Yahoo! Finance and pull up FBIOX, then go to 'Charts >
> Interactive&#
> and also (under Technical Indicators) the SMA over any period I choose. So
> Yahoo most certainly computes the 50-day moving average. The question then,
> is where does it store this info.
>
Mon Oct 21, 2013 6:00 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
I'm having different problem with RCHGetYahooQuotes. I set it up for just 3 codes, Price, PE and Mkt Cap and it's working fine when I type in each symbol one at a time.
Then I try to paste in a list of symbols, and the number does not exceed the length of my table, I'm using the SP500 list and the array is set up for =RCHGetYahooQuotes(A3:A502,B2:D2).
After I paste in the list, the array stops working. The data from the handful of tickers I had in there to test it disappear and all the cells become empty.
And even if I try to go back and enter tickers manually one at a time, after having tried to paste a list, no data appears. It's like the array gets ruined or something.
I've pasted tickers in before on other spreadsheets and it worked OK. Am I exceeding a parameter? I thought you could have multiple requests/codes on one ticker and it was treated as a single webpage query.
I've even tried starting a whole new spreadsheet file from scratch and it does the same thing.
What nuance am I missing here?
Win7 64 bit, Excel 2010.
Thanks,
Jim
I'm having different problem with RCHGetYahooQuotes. I set it up for just 3 codes, Price, PE and Mkt Cap and it's working fine when I type in each symbol one at a time.
Then I try to paste in a list of symbols, and the number does not exceed the length of my table, I'm using the SP500 list and the array is set up for =RCHGetYahooQuotes(
After I paste in the list, the array stops working. The data from the handful of tickers I had in there to test it disappear and all the cells become empty.
And even if I try to go back and enter tickers manually one at a time, after having tried to paste a list, no data appears. It's like the array gets ruined or something.
I've pasted tickers in before on other spreadsheets and it worked OK. Am I exceeding a parameter? I thought you could have multiple requests/codes on one ticker and it was treated as a single webpage query.
I've even tried starting a whole new spreadsheet file from scratch and it does the same thing.
What nuance am I missing here?
Win7 64 bit, Excel 2010.
Thanks,
Jim
Mon Oct 21, 2013 6:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo only allows 200 ticker symbols at a time, so that's probably the
problem.
Just do several function invocations, each with no more than 200 ticker
symbols.
On Mon, Oct 21, 2013 at 6:00 PM, Jim Ranum <amt2100@gmail.com> wrote:
>
>
> I'm having different problem with RCHGetYahooQuotes. I set it up for just
> 3 codes, Price, PE and Mkt Cap and it's working fine when I type in each
> symbol one at a time.****
>
> Then I try to paste in a list of symbols, and the number does not exceed
> the length of my table, I'm using the SP500 list and the array is set up
> for =RCHGetYahooQuotes(A3:A502,B2:D2).****
>
> ** **
>
> After I paste in the list, the array stops working. The data from the
> handful of tickers I had in there to test it disappear and all the cells
> become empty.****
>
> And even if I try to go back and enter tickers manually one at a time,
> after having tried to paste a list, no data appears. It's like the array
> gets ruined or something.****
>
> I've pasted tickers in before on other spreadsheets and it worked OK. Am I
> exceeding a parameter? I thought you could have multiple requests/codes on
> one ticker and it was treated as a single webpage query.****
>
> ** **
>
> I've even tried starting a whole new spreadsheet file from scratch and it
> does the same thing.****
>
> What nuance am I missing here?****
>
> Win7 64 bit, Excel 2010.****
>
>
>
problem.
Just do several function invocations, each with no more than 200 ticker
symbols.
On Mon, Oct 21, 2013 at 6:00 PM, Jim Ranum <amt2100@gmail.
>
>
> I'm having different problem with RCHGetYahooQuotes. I set it up for just
> 3 codes, Price, PE and Mkt Cap and it's working fine when I type in each
> symbol one at a time.****
>
> Then I try to paste in a list of symbols, and the number does not exceed
> the length of my table, I'm using the SP500 list and the array is set up
> for =RCHGetYahooQuotes(
>
> ** **
>
> After I paste in the list, the array stops working. The data from the
> handful of tickers I had in there to test it disappear and all the cells
> become empty.****
>
> And even if I try to go back and enter tickers manually one at a time,
> after having tried to paste a list, no data appears. It's like the array
> gets ruined or something.**
>
> I've pasted tickers in before on other spreadsheets and it worked OK. Am I
> exceeding a parameter? I thought you could have multiple requests/codes on
> one ticker and it was treated as a single webpage query.****
>
> ** **
>
> I've even tried starting a whole new spreadsheet file from scratch and it
> does the same thing.****
>
> What nuance am I missing here?****
>
> Win7 64 bit, Excel 2010.****
>
>
>
Mon Oct 21, 2013 6:21 pm (PDT) . Posted by:
"Jim Ranum" amt2100
That fixed it. Somehow I missed the 200 ticker limitation.
Thanks very much.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Monday, October 21, 2013 9:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: Re: [smf_addin] RCHGetYahooQuotes
Yahoo only allows 200 ticker symbols at a time, so that's probably the problem.
Just do several function invocations, each with no more than 200 ticker symbols.
On Mon, Oct 21, 2013 at 6:00 PM, Jim Ranum <amt2100@gmail.com> wrote:
I'm having different problem with RCHGetYahooQuotes. I set it up for just 3 codes, Price, PE and Mkt Cap and it's working fine when I type in each symbol one at a time.
Then I try to paste in a list of symbols, and the number does not exceed the length of my table, I'm using the SP500 list and the array is set up for =RCHGetYahooQuotes(A3:A502,B2:D2).
After I paste in the list, the array stops working. The data from the handful of tickers I had in there to test it disappear and all the cells become empty.
And even if I try to go back and enter tickers manually one at a time, after having tried to paste a list, no data appears. It's like the array gets ruined or something.
I've pasted tickers in before on other spreadsheets and it worked OK. Am I exceeding a parameter? I thought you could have multiple requests/codes on one ticker and it was treated as a single webpage query.
I've even tried starting a whole new spreadsheet file from scratch and it does the same thing.
What nuance am I missing here?
Win7 64 bit, Excel 2010.
Thanks very much.
Jim
From: smf_addin@yahoogrou
Sent: Monday, October 21, 2013 9:07 PM
To: smf_addin@yahoogrou
Subject: Re: Re: [smf_addin] RCHGetYahooQuotes
Yahoo only allows 200 ticker symbols at a time, so that's probably the problem.
Just do several function invocations, each with no more than 200 ticker symbols.
On Mon, Oct 21, 2013 at 6:00 PM, Jim Ranum <amt2100@gmail.
I'm having different problem with RCHGetYahooQuotes. I set it up for just 3 codes, Price, PE and Mkt Cap and it's working fine when I type in each symbol one at a time.
Then I try to paste in a list of symbols, and the number does not exceed the length of my table, I'm using the SP500 list and the array is set up for =RCHGetYahooQuotes(
After I paste in the list, the array stops working. The data from the handful of tickers I had in there to test it disappear and all the cells become empty.
And even if I try to go back and enter tickers manually one at a time, after having tried to paste a list, no data appears. It's like the array gets ruined or something.
I've pasted tickers in before on other spreadsheets and it worked OK. Am I exceeding a parameter? I thought you could have multiple requests/codes on one ticker and it was treated as a single webpage query.
I've even tried starting a whole new spreadsheet file from scratch and it does the same thing.
What nuance am I missing here?
Win7 64 bit, Excel 2010.
Mon Oct 21, 2013 6:35 pm (PDT) . Posted by:
clayspurgeon
Randy -
First of all, many thanks for all your work and for making this available. I'm new so apologies in advance, but I'm getting errors on the AdvFN elements. All other data elements seem to work fine for me. I'm using the 10.17 version.
Thanks again,
Clay
First of all, many thanks for all your work and for making this available. I'm new so apologies in advance, but I'm getting errors on the AdvFN elements. All other data elements seem to work fine for me. I'm using the 10.17 version.
Thanks again,
Clay
Mon Oct 21, 2013 7:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Do you need a prefix other than "www"? I don't know if those work with the
new code.
On Mon, Oct 21, 2013 at 6:14 PM, <clayspurgeon@gmail.com> wrote:
>
> First of all, many thanks for all your work and for making this
> available. I'm new so apologies in advance, but I'm getting errors on the
> AdvFN elements. All other data elements seem to work fine for me. I'm
> using the 10.17 version.
>
new code.
On Mon, Oct 21, 2013 at 6:14 PM, <clayspurgeon@
>
> First of all, many thanks for all your work and for making this
> available. I'm new so apologies in advance, but I'm getting errors on the
> AdvFN elements. All other data elements seem to work fine for me. I'm
> using the 10.17 version.
>
Mon Oct 21, 2013 6:50 pm (PDT) . Posted by:
lawrence.leesh
Hi Randy
I am getting Error with this formula. Did I do something wrongly?
=RCHGetTableCell("http://www. marketwatch.com/investing/ Stock/1/analystestimates? countrycode=hk http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=hk",1,"Average Target Price:")
thanks
LL
I am getting Error with this formula. Did I do something wrongly?
=RCHGetTableCell(
thanks
LL
Mon Oct 21, 2013 7:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your URL has a several internal spaces in it (in front of "marketwatch" and
"Stock/". Try:
=RCHGetTableCell("
http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=hk
",
1,"Average Target Price:")
On Mon, Oct 21, 2013 at 6:50 PM, <lawrence.leesh@yahoo.com> wrote:
>
> I am getting Error with this formula. Did I do something wrongly?
>
> =RCHGetTableCell("http://www. marketwatch.com/investing/
> Stock/1/analystestimates? countrycode=hk<http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=hk>",1,"Average
> Target Price:")
>
>
"Stock/
=RCHGetTableCell(
http://www.marketwa
",
1,"Average Target Price:"
On Mon, Oct 21, 2013 at 6:50 PM, <lawrence.leesh@
>
> I am getting Error with this formula. Did I do something wrongly?
>
> =RCHGetTableCell(
> Stock/1/analystesti
> Target Price:"
>
>
Mon Oct 21, 2013 7:07 pm (PDT) . Posted by:
lawrence.leesh
Thanks.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Your URL has a several internal spaces in it (in front of "marketwatch" and "Stock/". Try:
=RCHGetTableCell("http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=hk http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=hk",
1,"Average Target Price:")
On Mon, Oct 21, 2013 at 6:50 PM, <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:
I am getting Error with this formula. Did I do something wrongly?
=RCHGetTableCell("http://www. marketwatch.com/investing/ Stock/1/analystestimates? countrycode=hk http://www.marketwatch.com/investing/Stock/1/analystestimates?countrycode=hk",1,"Average Target Price:")
---In smf_addin@yahoogrou
Your URL has a several internal spaces in it (in front of "marketwatch&q
=RCHGetTableCell(
1,"Average Target Price:"
On Mon, Oct 21, 2013 at 6:50 PM, <lawrence.
I am getting Error with this formula. Did I do something wrongly?
=RCHGetTableCell(
Mon Oct 21, 2013 11:18 pm (PDT) . Posted by:
schlange.meister
Hi Randy,
I am thinking of using smfUpdateDownloadTable and/or RCHGetYahooQuotes for some larger sheets and large downloads. Currently I have access to bloomberg terminal at work and want to develop alternative data sources for fall back purposes (change of job).
Where can I read more about how those functions work and the limitations on them? I currently use the GetElement function and refer to the excellent Excel list of all data elements, but I guess that is rather inefficient compared to Download table or YahooQuotes.
Thanks,
Schlange
I am thinking of using smfUpdateDownloadTa
Where can I read more about how those functions work and the limitations on them? I currently use the GetElement function and refer to the excellent Excel list of all data elements, but I guess that is rather inefficient compared to Download table or YahooQuotes.
Thanks,
Schlange
Tidak ada komentar:
Posting Komentar