8 New Messages
Digest #2315
| 2b Re: RCHGetElementNumber(), how to update the data, hit shift F9 or j by "Randy Harmelink" rharmelink |
Messages
Wed Aug 15, 2012 6:48 am (PDT) . Posted by:
"grabthecashanddash" grabthecashanddash
Randy,
You have 2 addins for downloading Yahoo, one for a date range, one file at a time and the other for current data, many files at a time.
Why can't the date range addin retrieve the current date data? For example, last night I tried to get the AAPL data 08/01/2012 - 08/14/2012. It only retrieves thru the 13th.
Also, it would be nice if the date sort could be specified [descending or ascending].
Thanx,
Jay
You have 2 addins for downloading Yahoo, one for a date range, one file at a time and the other for current data, many files at a time.
Why can't the date range addin retrieve the current date data? For example, last night I tried to get the AAPL data 08/01/2012 - 08/14/2012. It only retrieves thru the 13th.
Also, it would be nice if the date sort could be specified [descending or ascending].
Thanx,
Jay
Wed Aug 15, 2012 7:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetYahooHistory() has a parameter to allow sorting in either way.
I don't want the function to grab current data because then it requires two
Internet accesses, and they are usually the speed bottleneck. If you wait
until they update the historical quotes for the night, you should get the
current day's data. It's usually updated a few hours after the market
closes.
On Wed, Aug 15, 2012 at 6:48 AM, grabthecashanddash <drjay001@gmail.com >wrote:
> You have 2 addins for downloading Yahoo, one for a date range, one file at
> a time and the other for current data, many files at a time.
>
> Why can't the date range addin retrieve the current date data? For
> example, last night I tried to get the AAPL data 08/01/2012 - 08/14/2012.
> It only retrieves thru the 13th.
>
> Also, it would be nice if the date sort could be specified [descending or
> ascending].
>
I don't want the function to grab current data because then it requires two
Internet accesses, and they are usually the speed bottleneck. If you wait
until they update the historical quotes for the night, you should get the
current day's data. It's usually updated a few hours after the market
closes.
On Wed, Aug 15, 2012 at 6:48 AM, grabthecashanddash <drjay001@gmail.
> You have 2 addins for downloading Yahoo, one for a date range, one file at
> a time and the other for current data, many files at a time.
>
> Why can't the date range addin retrieve the current date data? For
> example, last night I tried to get the AAPL data 08/01/2012 - 08/14/2012.
> It only retrieves thru the 13th.
>
> Also, it would be nice if the date sort could be specified [descending or
> ascending].
>
Wed Aug 15, 2012 9:11 am (PDT) . Posted by:
"rr76012" rr76012
Hello Randy,
I have been wondering about rules of thumb updating data using the rchgetyahoohistory and rchgetelementnumber and RCHGetYahooQuotes()?
Do I just hit F9, or hit Shift F9 to update data?
Randy, Thanks, have a great day.
I have been wondering about rules of thumb updating data using the rchgetyahoohistory and rchgetelementnumber and RCHGetYahooQuotes(
Do I just hit F9, or hit Shift F9 to update data?
Randy, Thanks, have a great day.
Wed Aug 15, 2012 10:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The best way to update all of them is to use the smfForceRecalculation
macro -- see the LINKS area of the group for more info on it. F9 typically
will NOT update those functions.
On Wed, Aug 15, 2012 at 9:11 AM, rr76012 <rr76012@yahoo.com > wrote:
>
> I have been wondering about rules of thumb updating data using the
> rchgetyahoohistory and rchgetelementnumber and RCHGetYahooQuotes()?
>
> Do I just hit F9, or hit Shift F9 to update data?
>
macro -- see the LINKS area of the group for more info on it. F9 typically
will NOT update those functions.
On Wed, Aug 15, 2012 at 9:11 AM, rr76012 <rr76012@yahoo.
>
> I have been wondering about rules of thumb updating data using the
> rchgetyahoohistory and rchgetelementnumber and RCHGetYahooQuotes(
>
> Do I just hit F9, or hit Shift F9 to update data?
>
Wed Aug 15, 2012 1:22 pm (PDT) . Posted by:
"Faisal PK" idforexcel
Dear All,
Is there any way that I can join this group with my Gmail Id.
Your valuable suggestions are highly appreciated.
Thanks,
Excel Lover.
Is there any way that I can join this group with my Gmail Id.
Your valuable suggestions are highly appreciated.
Thanks,
Excel Lover.
Wed Aug 15, 2012 1:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm pretty sure you need a Yahoo ID in order to access the files area...
On Wed, Aug 15, 2012 at 1:11 PM, Faisal PK <idforexcel@yahoo.in > wrote:
>
> Is there any way that I can join this group with my Gmail Id.
>
> Your valuable suggestions are highly appreciated.
>
>
On Wed, Aug 15, 2012 at 1:11 PM, Faisal PK <idforexcel@yahoo.
>
> Is there any way that I can join this group with my Gmail Id.
>
> Your valuable suggestions are highly appreciated.
>
>
Wed Aug 15, 2012 3:40 pm (PDT) . Posted by:
"barmarjeff01" barmarjeff01
I'm using Excel 2010. I'm new to using the SMF addin and I've been having some trouble getting the right information in my spreadsheet. I'm trying to get the one year, three year, and five returns for certain tickers. I have no problems extracting other data such as beta, standard deviation, etc.
I've been using RCHGetElementNumber(The cell containing the ticker, 4893) for the one year return. The result is 0. Some of the tickers I have had trouble with are TIP, IJJ, and IVV. The returns are non-zero when I look them up on morningstar.
Any help would be greatly appreciated. Thanks!
I've been using RCHGetElementNumber
Any help would be greatly appreciated. Thanks!
Wed Aug 15, 2012 3:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just checked for TIP. The problem is that they aren't populating the
Trailing Returns table data:
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=TIP
On Wed, Aug 15, 2012 at 2:54 PM, barmarjeff01 <markavramovich@yahoo.com >wrote:
> I'm using Excel 2010. I'm new to using the SMF addin and I've been having
> some trouble getting the right information in my spreadsheet. I'm trying
> to get the one year, three year, and five returns for certain tickers. I
> have no problems extracting other data such as beta, standard deviation,
> etc.
>
> I've been using RCHGetElementNumber(The cell containing the ticker, 4893)
> for the one year return. The result is 0. Some of the tickers I have had
> trouble with are TIP, IJJ, and IVV. The returns are non-zero when I look
> them up on morningstar.
>
> Any help would be greatly appreciated. Thanks!
>
Trailing Returns table data:
http://quicktake.
On Wed, Aug 15, 2012 at 2:54 PM, barmarjeff01 <markavramovich@
> I'm using Excel 2010. I'm new to using the SMF addin and I've been having
> some trouble getting the right information in my spreadsheet. I'm trying
> to get the one year, three year, and five returns for certain tickers. I
> have no problems extracting other data such as beta, standard deviation,
> etc.
>
> I've been using RCHGetElementNumber
> for the one year return. The result is 0. Some of the tickers I have had
> trouble with are TIP, IJJ, and IVV. The returns are non-zero when I look
> them up on morningstar.
>
> Any help would be greatly appreciated. Thanks!
>
Tidak ada komentar:
Posting Komentar