6 Messages
Digest #3018
Messages
Mon Mar 24, 2014 10:42 am (PDT) . Posted by:
lewglenn
I'm running a code with:
SelPack = "SPY"
Sheets(SelPack).Select
Range("A1:B20000") = RCHGetYahooHistory(SelStr, , , , , , , , "DA", 1, 1, 1, 20000, 2)
What I'm getting is a skip in the dates; here's a partial listing:
12/23/2013 181.73 12/24/2013 182.13 12/26/2013 183.05 12/27/2013 183.04 12/30/2013 183.01 12/31/2013 183.88 1/2/2014 182.12 1/3/2014 182.09 1/6/2014 181.56 1/7/2014 182.67 1/8/2014 182.71 1/9/2014 182.83 1/23/2014 181.99 1/24/2014 178.1 1/27/2014 177.23 1/28/2014 178.28 1/29/2014 176.57 Note that after 1/9/2014, the next date is 1/23/2014. I've used this command many times with no problem. Is there a problem with Yahoo today, or it is it me that has the problem and, if so, what could I be doing wrong?
When I go to Yahoo and query historical prices I get the same result so I think the problem is with Yahoo.
Thanks.
SelPack = "SPY"
Sheets(SelPack)
Range("
What I'm getting is a skip in the dates; here's a partial listing:
12/23/2013 181.73 12/24/2013 182.13 12/26/2013 183.05 12/27/2013 183.04 12/30/2013 183.01 12/31/2013 183.88 1/2/2014 182.12 1/3/2014 182.09 1/6/2014 181.56 1/7/2014 182.67 1/8/2014 182.71 1/9/2014 182.83 1/23/2014 181.99 1/24/2014 178.1 1/27/2014 177.23 1/28/2014 178.28 1/29/2014 176.57 Note that after 1/9/2014, the next date is 1/23/2014. I've used this command many times with no problem. Is there a problem with Yahoo today, or it is it me that has the problem and, if so, what could I be doing wrong?
When I go to Yahoo and query historical prices I get the same result so I think the problem is with Yahoo.
Thanks.
Mon Mar 24, 2014 11:00 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sounds like the problem is with Yahoo, if your query is seeing the same
data that the add-in is retrieving when it queries for the data.
Unfortunately, problems on Yahoo are not unusual lately...
They haven't had options for SPY for several weeks now.
On Mon, Mar 24, 2014 at 10:42 AM, <lewglenn@yahoo.com> wrote:
>
> I'm running a code with:
> SelPack = "SPY"
> Sheets(SelPack).Select
> Range("A1:B20000") = RCHGetYahooHistory(SelStr, , , , , , , , "DA", 1,
> 1, 1, 20000, 2)
>
> What I'm getting is a skip in the dates; here's a partial listing:
> 12/23/2013 181.73 12/24/2013 182.13 12/26/2013 183.05 12/27/2013
> 183.04 12/30/2013 183.01 12/31/2013 183.88 1/2/2014 182.12 1/3/2014
> 182.09 1/6/2014 181.56 1/7/2014 182.67 1/8/2014 182.71 1/9/2014 182.83
> 1/23/2014 181.99 1/24/2014 178.1 1/27/2014 177.23 1/28/2014 178.28
> 1/29/2014 176.57 Note that after 1/9/2014, the next date is 1/23/2014.
> I've used this command many times with no problem. Is there a problem with
> Yahoo today, or it is it me that has the problem and, if so, what could I
> be doing wrong?
> When I go to Yahoo and query historical prices I get the same result so I
> think the problem is with Yahoo.
>
data that the add-in is retrieving when it queries for the data.
Unfortunately, problems on Yahoo are not unusual lately...
They haven't had options for SPY for several weeks now.
On Mon, Mar 24, 2014 at 10:42 AM, <lewglenn@yahoo.com> wrote:
>
> I'm running a code with:
> SelPack = "SPY"
> Sheets(SelPack)
> Range("
> 1, 1, 20000, 2)
>
> What I'm getting is a skip in the dates; here's a partial listing:
> 12/23/2013 181.73 12/24/2013 182.13 12/26/2013 183.05 12/27/2013
> 183.04 12/30/2013 183.01 12/31/2013 183.88 1/2/2014 182.12 1/3/2014
> 182.09 1/6/2014 181.56 1/7/2014 182.67 1/8/2014 182.71 1/9/2014 182.83
> 1/23/2014 181.99 1/24/2014 178.1 1/27/2014 177.23 1/28/2014 178.28
> 1/29/2014 176.57 Note that after 1/9/2014, the next date is 1/23/2014.
> I've used this command many times with no problem. Is there a problem with
> Yahoo today, or it is it me that has the problem and, if so, what could I
> be doing wrong?
> When I go to Yahoo and query historical prices I get the same result so I
> think the problem is with Yahoo.
>
Mon Mar 24, 2014 11:01 am (PDT) . Posted by:
rajarjrtj
Similar Yahoo history experiences today, and for many tickers quoted dates and prices are changing with each consecutive identical query.
Yahoo financial data has been inconsistent over the last couple of weeks, I hope it is a temporary rather than permanent change.
Yahoo financial data has been inconsistent over the last couple of weeks, I hope it is a temporary rather than permanent change.
Mon Mar 24, 2014 4:10 pm (PDT) . Posted by:
jsmetank74
Randy,
I have tried a variation of this but it returns 'Error'. Any suggestions?
=smfConvertData(smfGetTagContent("http://www.marketwatch.com/investing/Stock/hsbc","p",1,"Div Yield")) http://www.marketwatch.com/investing/Stock/hsbc
For reference, I am just looking for a reliable place to get dividend yield so I am open to other ideas if you have a recommendation. Preferably one that can handle ETFs and CEFs along with stocks.
I have tried a variation of this but it returns 'Error'. Any suggestions?
=smfConvertData(smfGetTagContent("http://www.marketwatch.com/investing/Stock/hsbc","p",1,"Div Yield")) http://www.marketwatch.com/investing/Stock/hsbc
For reference, I am just looking for a reliable place to get dividend yield so I am open to other ideas if you have a recommendation. Preferably one that can handle ETFs and CEFs along with stocks.
Mon Mar 24, 2014 4:46 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you. That formula worked just fine for me.
On Mon, Mar 24, 2014 at 4:10 PM, <jsmetank74@hotmail.com> wrote:
>
> I have tried a variation of this but it returns 'Error'. Any suggestions?
> =smfConvertData(smfGetTagContent("http://www.marketwatch.com/investing/Stock/hsbc","p",1,"Div
> Yield")) <http://www.marketwatch.com/investing/Stock/hsbc>
>
> For reference, I am just looking for a reliable place to get dividend
> yield so I am open to other ideas if you have a recommendation. Preferably
> one that can handle ETFs and CEFs along with stocks.
>
On Mon, Mar 24, 2014 at 4:10 PM, <jsmetank74@hotmail.com> wrote:
>
> I have tried a variation of this but it returns 'Error'. Any suggestions?
> =smfConvertData(smfGetTagContent("http://www.marketwatch.com/investing/Stock/hsbc","p",1,"Div
> Yield")) <http://www.marketwatch.com/investing/Stock/hsbc>
>
> For reference, I am just looking for a reliable place to get dividend
> yield so I am open to other ideas if you have a recommendation. Preferably
> one that can handle ETFs and CEFs along with stocks.
>
Mon Mar 24, 2014 6:54 pm (PDT) . Posted by:
jsmetank74
Randy, thank you for the prompt response. It turns out I did not have the latest .xla file. I updated that and it now works.
Tidak ada komentar:
Posting Komentar