11 New Messages
Digest #2472
Messages
Fri Jan 18, 2013 7:29 am (PST) . Posted by:
thomasdardanic
The yahoo finance website is still pulling 2012 numbers for YTD ? Is there a way to update this. I think it has to do with their site and not the functions on the add-in.
Fri Jan 18, 2013 7:51 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It's all Yahoo -- if you look here:
http://finance.yahoo.com/q/pm?s=VFINX
...it says: "as of Dec 30, 2012"
On Fri, Jan 18, 2013 at 8:29 AM, tomaj567@gmail.com > wrote:
>
> The yahoo finance website is still pulling 2012 numbers for YTD ? Is
> there a way to update this. I think it has to do with their site and not
> the functions on the add-in.
>
http://finance.
...it says: "as of Dec 30, 2012"
On Fri, Jan 18, 2013 at 8:29 AM, tomaj567@gmail.
>
> The yahoo finance website is still pulling 2012 numbers for YTD ? Is
> there a way to update this. I think it has to do with their site and not
> the functions on the add-in.
>
Fri Jan 18, 2013 8:02 am (PST) . Posted by:
thomasdardanic
You would think they update it given the number of people across the world who use the site.
From: Randy Harmelink
Sent: Friday, January 18, 2013 9:51 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo PM Fund Total Returns
It's all Yahoo -- if you look here:
http://finance.yahoo.com/q/pm?s=VFINX
...it says: "as of Dec 30, 2012"
On Fri, Jan 18, 2013 at 8:29 AM, tomaj567@gmail.com > wrote:
The yahoo finance website is still pulling 2012 numbers for YTD ? Is there a way to update this. I think it has to do with their site and not the functions on the add-in.
From: Randy Harmelink
Sent: Friday, January 18, 2013 9:51 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Yahoo PM Fund Total Returns
It's all Yahoo -- if you look here:
http://finance.
...it says: "as of Dec 30, 2012"
On Fri, Jan 18, 2013 at 8:29 AM, tomaj567@gmail.
The yahoo finance website is still pulling 2012 numbers for YTD ? Is there a way to update this. I think it has to do with their site and not the functions on the add-in.
Fri Jan 18, 2013 8:13 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm not even sure I'd trust the data at Yahoo. If you look at the "Annual"
and "Quarterly" historical returns, they only go as recent as 2010.
I think MorningStar provides the mutual fund data to Yahoo, so it may be
better to go directly to the source:
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=VFINX
On Fri, Jan 18, 2013 at 9:02 AM, tomaj567@gmail.com > wrote:
>
> You would think they update it given the number of people across the
> world who use the site.
>
and "Quarterly&quo
I think MorningStar provides the mutual fund data to Yahoo, so it may be
better to go directly to the source:
http://quicktake.
On Fri, Jan 18, 2013 at 9:02 AM, tomaj567@gmail.
>
> You would think they update it given the number of people across the
> world who use the site.
>
Fri Jan 18, 2013 9:00 am (PST) . Posted by:
thomasdardanic
Is that data subscription based: and is the add-in able to extract it?
From: Randy Harmelink
Sent: Friday, January 18, 2013 10:13 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo PM Fund Total Returns
I'm not even sure I'd trust the data at Yahoo. If you look at the "Annual" and "Quarterly" historical returns, they only go as recent as 2010.
I think MorningStar provides the mutual fund data to Yahoo, so it may be better to go directly to the source:
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=VFINX
On Fri, Jan 18, 2013 at 9:02 AM, tomaj567@gmail.com > wrote:
You would think they update it given the number of people across the world who use the site.
From: Randy Harmelink
Sent: Friday, January 18, 2013 10:13 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Yahoo PM Fund Total Returns
I'm not even sure I'd trust the data at Yahoo. If you look at the "Annual" and "Quarterly&quo
I think MorningStar provides the mutual fund data to Yahoo, so it may be better to go directly to the source:
http://quicktake.
On Fri, Jan 18, 2013 at 9:02 AM, tomaj567@gmail.
You would think they update it given the number of people across the world who use the site.
Fri Jan 18, 2013 1:04 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Not subscription based as far as I know. And, you can extract. For example,
YTD return:
=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=VFINX
",1,"Year-to-Date")
...and you can get the "as of" date with:
=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=VFINX ",1,"Trailing
Total Returns")
On Fri, Jan 18, 2013 at 10:00 AM, tomaj567@gmail.com > wrote:
>
> Is that data subscription based: and is the add-in able to extract it?
>
>
YTD return:
=RCHGetTableCell(
http://quicktake.
",1,"
...and you can get the "as of" date with:
=RCHGetTableCell(
http://quicktake.
Total Returns"
On Fri, Jan 18, 2013 at 10:00 AM, tomaj567@gmail.
>
> Is that data subscription based: and is the add-in able to extract it?
>
>
Fri Jan 18, 2013 7:46 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The RCHGetWebData() is just returning this JavaScript data:
( { "copyright":"Copyright (c) 2013 QuoteMedia, Inc.", "symbolcount":1,
"quotedata":[ { "symbol":"AGF2107", "datatype";:"mutual fund",
"entitlement":"EOD", "delaymin";:null,
"datetime";:"2013-01-17T20:00:00-05:00", "pricedata":{ "last":"15.81",
"change":"0.11", "changepercent":"0.700637", "sharevolume":"0" } } ] } );
So items out of that can be extracted.
But I don't see any of the additional items you mention shown there, and if
I remember correctly, the main page was dynamically displayed, so the data
couldn't be extracted there either.
If the data you want is available elsewhere, I'm not aware of it.
Hmmm. Took another look. Raw data appears to be here:
http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D8DCE5&chbdr=D8DCE5&chfill2=6d9641&chfill=cc6d9641&chln=313942&chaaon=true&cp=off&symbol=AGF2107&hiddenTabs=topnav&action=showDetailedQuote&targetURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en
...so you could extract it from there. For example, if that URL is in cell
C2:
=smfGetTagContent($C$2,"div",1,"Type:")
=0+smfGetTagContent($C$2,"div",1,"High:")
On Fri, Jan 18, 2013 at 8:23 AM, iamruf iamruf@yahoo.com > wrote:
> Hi Randy,
> The formula at the bottom is getting prices although I don`t understand
> how it works.
> Is it possible to adapt the formula to get other data on this page.
> Fund Type: Global Equity
> 52 Week High: 16.05
> 52 Week Low: 14.34
> YTD Return (as of December 31, 2012): 11.69%
> Load Type: Choice of Front or Back
> MER: 2.94%
> Eligiblity: RRSP
> Who Should Invest
> Consider this Fund if: the tax consequences of a mutual fund corporation
> are more suitable to your investment program or that of your registered
> plan; you want the growth potential of equity securities of foreign
> companies; you're investing for the longer term; you tolerate medium risk;
> with respect to Series T and Series V securities, you prefer monthly
> distribution of capital.(This is a box varies in length)
>
> =RCHGetWebData("
> http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba \ck=jsonp1358089488792&symbols=AGF2107&webmasterId=101020&_=1358089550952
> ",1,1000)
>
( { "copyright&quo
"quotedata&quo
"entitlement&q
"datetime"
"change"
So items out of that can be extracted.
But I don't see any of the additional items you mention shown there, and if
I remember correctly, the main page was dynamically displayed, so the data
couldn't be extracted there either.
If the data you want is available elsewhere, I'm not aware of it.
Hmmm. Took another look. Raw data appears to be here:
http://app.quotemed
...so you could extract it from there. For example, if that URL is in cell
C2:
=smfGetTagContent(
=0+smfGetTagContent
On Fri, Jan 18, 2013 at 8:23 AM, iamruf iamruf@yahoo.
> Hi Randy,
> The formula at the bottom is getting prices although I don`t understand
> how it works.
> Is it possible to adapt the formula to get other data on this page.
> Fund Type: Global Equity
> 52 Week High: 16.05
> 52 Week Low: 14.34
> YTD Return (as of December 31, 2012): 11.69%
> Load Type: Choice of Front or Back
> MER: 2.94%
> Eligiblity: RRSP
> Who Should Invest
> Consider this Fund if: the tax consequences of a mutual fund corporation
> are more suitable to your investment program or that of your registered
> plan; you want the growth potential of equity securities of foreign
> companies; you're investing for the longer term; you tolerate medium risk;
> with respect to Series T and Series V securities, you prefer monthly
> distribution of capital.(This is a box varies in length)
>
> =RCHGetWebData(
> http://tmx.quotemed
> ",1,1000)
>
Fri Jan 18, 2013 2:07 pm (PST) . Posted by:
"bholscher@rocketmail.com" bholscher@rocketmail.com
Hello - wondering if its possible to pull Delta values for Put options?
I see on the explanation doc for smfGetOXoptionquote it states Delta values are only available for Call options at this time....?
Is there any update to this or another way to pull the Deltas?
I see on the explanation doc for smfGetOXoptionquote it states Delta values are only available for Call options at this time....?
Is there any update to this or another way to pull the Deltas?
Fri Jan 18, 2013 3:49 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's only the "OX" data source that is calls only. The "OX2" data source
should have deltas for puts...
On Fri, Jan 18, 2013 at 3:07 PM, bholscher@rocketmail.com <
bholscher@rocketmail.com > wrote:
> Hello - wondering if its possible to pull Delta values for Put options?
>
> I see on the explanation doc for smfGetOXoptionquote it states Delta
> values are only available for Call options at this time....?
>
> Is there any update to this or another way to pull the Deltas?
>
should have deltas for puts...
On Fri, Jan 18, 2013 at 3:07 PM, bholscher@rocketmai
bholscher@rocketmai
> Hello - wondering if its possible to pull Delta values for Put options?
>
> I see on the explanation doc for smfGetOXoptionquote it states Delta
> values are only available for Call options at this time....?
>
> Is there any update to this or another way to pull the Deltas?
>
Fri Jan 18, 2013 11:44 pm (PST) . Posted by:
"bobc94595" bobc94595
I am currently using an array formula "RCHGetYahooQuotes(A4:A106,B3:E3)" I have about 100 stock symbols in Column A, and Columns B,C,D and E contain the Yahoo Codes. The retrieval from Yahoo is very fast.
Columns F, G and H contain formulas which pick up the data from Columns B,C and D.
As I update the spreadsheet from time to time, I need to add or delete a stock. When I try to delete the entire row for a particular stock (e.g. Row 25), I get blocked with the warning that you cannot change a part of the array. If I delete only the symbol in A25, cell A25 becomes blank, but all the information in B26, C26 and E26 moves up to B25, C25 and E25. That causes all the dependent formulas in F, G and H to miscalculate.
I tried using RCHGetElementNumber instead, but that is very slow.
Is there some formula modification to the array that can be made to avoid this array problem?
Columns F, G and H contain formulas which pick up the data from Columns B,C and D.
As I update the spreadsheet from time to time, I need to add or delete a stock. When I try to delete the entire row for a particular stock (e.g. Row 25), I get blocked with the warning that you cannot change a part of the array. If I delete only the symbol in A25, cell A25 becomes blank, but all the information in B26, C26 and E26 moves up to B25, C25 and E25. That causes all the dependent formulas in F, G and H to miscalculate.
I tried using RCHGetElementNumber instead, but that is very slow.
Is there some formula modification to the array that can be made to avoid this array problem?
Sat Jan 19, 2013 12:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, that's the nature of an array-entered formula. However,
there are easy solutions to working with the array-entered area.
First off, I would change the A4:A106 range to be A4:A203, so that it can
accommodate up to 200 ticker symbols (the maximum Yahoo allows for each CSV
file requested), and then you don't need to re-do the array-entered
function with each addition or deletion of a ticker symbol.
Secondly, instead of inserting and deleting rows, insert or delete a
cell/range. For example, if I want to insert a new ticker symbol above cell
A7, I would make A7 the active cell and then do a keyboard shortcut of
alt-i-e-d-Enter (i.e. Insert, Edit range, move items Downward to make
room). Then enter the new ticker symbol in the blank spot. If I want to
delete a ticker symbol, I would make that ticker cell active, and use the
keyboard shortcut of alt-e-d-u-Enter (i.e. Edit, Delete range, move items
from below up). Each action you take will cause a recalculation if you've
made the RCHGetYahooQuotes() function volatile.
All of your values in columns B:E should automatically adapt to the new set
of ticker symbols. And thus your columns F:H should automatically adapt to
the new set of ticker symbols.
Now, the workaround if you're using RCHGetElementNumber() is a little
trickier, since inserting and deleting ranges does affect a direct cell
reference. For example, suppose I have something like this is column J:
=RCHGetElementNumber($A7,984)
If you insert a cell/range above cell A7, that $A7 reference will become
$A8.
To avoid this problem, I would add a range name that says ticker symbol can
be found in column A of that row. So, if I position myself on cell G7,
keyboard shortcut alt-i-n-d-n (i.e. Insert, Names, Define, New) to bring
up the "New Name" dialog. Name it "Ticker" and set the "Refers to" value to
be "=Sheet1!$A7". In other words, always column "A" for whatever row you're
on. Then, the formula can be:
=RCHGetElementNumber(Ticker,984)
In row 7, "Ticker" will always refer to cell A7. In row 8, "Ticker" will
always refer to cell A8. After that, if you insert or delete cells in
column A, all of the formulas will pick up the new value in that row,
instead of changing the direct cell address.
On Sat, Jan 19, 2013 at 12:44 AM, bobc94595 conlonrc@comcast.net > wrote:
> I am currently using an array formula "RCHGetYahooQuotes(A4:A106,B3:E3)" I
> have about 100 stock symbols in Column A, and Columns B,C,D and E contain
> the Yahoo Codes. The retrieval from Yahoo is very fast.
>
> Columns F, G and H contain formulas which pick up the data from Columns
> B,C and D.
>
> As I update the spreadsheet from time to time, I need to add or delete a
> stock. When I try to delete the entire row for a particular stock (e.g. Row
> 25), I get blocked with the warning that you cannot change a part of the
> array. If I delete only the symbol in A25, cell A25 becomes blank, but all
> the information in B26, C26 and E26 moves up to B25, C25 and E25. That
> causes all the dependent formulas in F, G and H to miscalculate.
>
> I tried using RCHGetElementNumber instead, but that is very slow.
>
> Is there some formula modification to the array that can be made to avoid
> this array problem?
>
there are easy solutions to working with the array-entered area.
First off, I would change the A4:A106 range to be A4:A203, so that it can
accommodate up to 200 ticker symbols (the maximum Yahoo allows for each CSV
file requested), and then you don't need to re-do the array-entered
function with each addition or deletion of a ticker symbol.
Secondly, instead of inserting and deleting rows, insert or delete a
cell/range. For example, if I want to insert a new ticker symbol above cell
A7, I would make A7 the active cell and then do a keyboard shortcut of
alt-i-e-d-Enter (i.e. Insert, Edit range, move items Downward to make
room). Then enter the new ticker symbol in the blank spot. If I want to
delete a ticker symbol, I would make that ticker cell active, and use the
keyboard shortcut of alt-e-d-u-Enter (i.e. Edit, Delete range, move items
from below up). Each action you take will cause a recalculation if you've
made the RCHGetYahooQuotes(
All of your values in columns B:E should automatically adapt to the new set
of ticker symbols. And thus your columns F:H should automatically adapt to
the new set of ticker symbols.
Now, the workaround if you're using RCHGetElementNumber
trickier, since inserting and deleting ranges does affect a direct cell
reference. For example, suppose I have something like this is column J:
=RCHGetElementNumbe
If you insert a cell/range above cell A7, that $A7 reference will become
$A8.
To avoid this problem, I would add a range name that says ticker symbol can
be found in column A of that row. So, if I position myself on cell G7,
keyboard shortcut alt-i-n-d-n (i.e. Insert, Names, Define, New) to bring
up the "New Name" dialog. Name it "Ticker" and set the "Refers to" value to
be "=Sheet1!
on. Then, the formula can be:
=RCHGetElementNumbe
In row 7, "Ticker" will always refer to cell A7. In row 8, "Ticker" will
always refer to cell A8. After that, if you insert or delete cells in
column A, all of the formulas will pick up the new value in that row,
instead of changing the direct cell address.
On Sat, Jan 19, 2013 at 12:44 AM, bobc94595 conlonrc@comcast.
> I am currently using an array formula "RCHGetYahooQu
> have about 100 stock symbols in Column A, and Columns B,C,D and E contain
> the Yahoo Codes. The retrieval from Yahoo is very fast.
>
> Columns F, G and H contain formulas which pick up the data from Columns
> B,C and D.
>
> As I update the spreadsheet from time to time, I need to add or delete a
> stock. When I try to delete the entire row for a particular stock (e.g. Row
> 25), I get blocked with the warning that you cannot change a part of the
> array. If I delete only the symbol in A25, cell A25 becomes blank, but all
> the information in B26, C26 and E26 moves up to B25, C25 and E25. That
> causes all the dependent formulas in F, G and H to miscalculate.
>
> I tried using RCHGetElementNumber instead, but that is very slow.
>
> Is there some formula modification to the array that can be made to avoid
> this array problem?
>
Tidak ada komentar:
Posting Komentar