Selasa, 22 November 2011

[smf_addin] Digest Number 2023

Messages In This Digest (9 Messages)

1.
Cannot Retrieve Data from within employers network From: michael
2a.
Data Updation From: ashwinan83@ymail.com
2b.
Re: Data Updation From: Randy Harmelink
2c.
Data Updation From: ashwinan83@ymail.com
2d.
Re: Data Updation From: Randy Harmelink
2e.
Re: Data Updation From: ashwinan83@ymail.com
2f.
Re: Data Updation From: Randy Harmelink
3a.
Array enter to get yahoo history with multiple symols for one data f From: bliu88
3b.
Re: Array enter to get yahoo history with multiple symols for one da From: Randy Harmelink

Messages

1.

Cannot Retrieve Data from within employers network

Posted by: "michael" michael.cannavaro@yahoo.com   michael.cannavaro

Mon Nov 21, 2011 7:26 am (PST)



As of a few weeks ago, without changing or re-configuring anything on my laptop, I could no longer retrieve any data from within my employers network. I have no issues retrieving data on the same laptop while on other networks. Has anyone had any similar issues with proxy servers? (I am assuming this is perhaps a proxy server issue) If so, can anyone offer some suggestions? I am hoping to perhaps request approval to access the specific URL's once I identify them if that is the case.
Thanks very much for any suggestions and you time.

2a.

Data Updation

Posted by: "ashwinan83@ymail.com" ashwinan83@ymail.com   ashwinan83@ymail.com

Mon Nov 21, 2011 7:27 am (PST)



I have been using yahoo for EOD data for past few days. Today as i write @5.51 IST..Data for ^NSEI is still not updated. Wanted to know by when will EOD data get updated.

2b.

Re: Data Updation

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 21, 2011 7:32 am (PST)



That would be a question for Yahoo. However, recently Yahoo has had
problems with indexes having current data on their CSV interface. I don't
know if they have some server update issue, or some other issue.

On Mon, Nov 21, 2011 at 5:21 AM, ashwinan83@ymail.com
<ashwinan83@ymail.com>wrote:

> I have been using yahoo for EOD data for past few days. Today as i write
> @5.51 IST..Data for ^NSEI is still not updated. Wanted to know by when will
> EOD data get updated.
>
2c.

Data Updation

Posted by: "ashwinan83@ymail.com" ashwinan83@ymail.com   ashwinan83@ymail.com

Mon Nov 21, 2011 8:39 pm (PST)




As of Today i.e 22.11.2011..yesterdays EOD data for ^NSEI as well as stocks listed on National stock exchange has not been updated. Pls help.or let me know whom to contact. Thanks.

2d.

Re: Data Updation

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 21, 2011 8:42 pm (PST)



As you were told earlier today, you need to contact Yahoo.

On Mon, Nov 21, 2011 at 9:35 PM, ashwinan83@ymail.com
<ashwinan83@ymail.com>wrote:

>
> As of Today i.e 22.11.2011..yesterdays EOD data for ^NSEI as well as
> stocks listed on National stock exchange has not been updated. Pls help.or
> let me know whom to contact. Thanks.
>
2e.

Re: Data Updation

Posted by: "ashwinan83@ymail.com" ashwinan83@ymail.com   ashwinan83@ymail.com

Mon Nov 21, 2011 9:26 pm (PST)



Whom or where or which group in Yahoo? Pls

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> As you were told earlier today, you need to contact Yahoo.
>
> On Mon, Nov 21, 2011 at 9:35 PM, ashwinan83@...
> <ashwinan83@...>wrote:
>
> >
> > As of Today i.e 22.11.2011..yesterdays EOD data for ^NSEI as well as
> > stocks listed on National stock exchange has not been updated. Pls help.or
> > let me know whom to contact. Thanks.
> >
>

2f.

Re: Data Updation

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 21, 2011 9:31 pm (PST)



Did you look? If you go to the historical quotes page, you'll see a "Send
Feedback" link at the bottom. Or, if you're on the main Yahoo page for the
equity, there's a "Report problems" link at the bottom. You'd be better off
with this one, because it leads directly to a link for a "Data Inaccuracy
Form"...

On Mon, Nov 21, 2011 at 10:22 PM, ashwinan83@ymail.com <ashwinan83@ymail.com
> wrote:

> Whom or where or which group in Yahoo? Pls
>
3a.

Array enter to get yahoo history with multiple symols for one data f

Posted by: "bliu88" bliu88@yahoo.com   bliu88

Mon Nov 21, 2011 7:58 am (PST)



I try to array enter a formula to get yahoo history with multiple symbols for multiple days but only for one data like "h" or "l". Such use does not work apparently: RCHGetYahooHistory(A1:A10,2011,11,21,2011,11,15,,"h"). I have to enter (copy paste) the formula for each cell. What is the best way to accomplish this efficiently?

3b.

Re: Array enter to get yahoo history with multiple symols for one da

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 21, 2011 8:29 am (PST)



As per the documentation, the function only takes a single ticker symbol.
There would be no advantage to array-enter it for multiple ticker symbols
vs individual functions for each ticker symbol -- each ticker symbol would
still need to go to the Internet to get its own data. So just use a
separate function for each ticker symbol.

In such instances, I rarely copy and paste. I either "Fill Right" (ctrl+r)
or "Fill Down" (ctrl+d) depending on whether I am copying by column or row.

Also, if you are always getting data ending with the most recent date, you
don't need to give the beginning and ending dates.

On Mon, Nov 21, 2011 at 8:58 AM, bliu88 <bliu88@yahoo.com> wrote:

> I try to array enter a formula to get yahoo history with multiple symbols
> for multiple days but only for one data like "h" or "l". Such use does not
> work apparently: RCHGetYahooHistory(A1:A10,2011,11,21,2011,11,15,,"h"). I
> have to enter (copy paste) the formula for each cell. What is the best way
> to accomplish this efficiently?
>
Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Groups

Small Business Group

A community for

small business owners

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Tidak ada komentar:

Posting Komentar