Messages In This Digest (3 Messages)

Messages

1a.: Re: Delete parameter

Posted by: "KailuaKid" Gary.Hartling@gmail.com garyhartling

Fri Jul 1, 2011 5:59 am (PDT)

You have to select the whole array, delete it, delete the column, then array enter again. Alternatively, you can just "Hide" the column in question.

Gary H.

--- In smf_addin@yahoogroups.com, "wenxi.drake" <wenxi.drake@...> wrote:
>
> Hi Randy,
>
> I've been using the RCHGetYahooQuotes() Function for a while. The problem I have right now is:
>
> After I put data in, for example, B2 to N100, I found I don't need one of the data code (for instance, I don't want "previous close" whose data code is "p"). So I want to delete the column N where I put in "previous close".
>
> After I highlight B2 to M100,and put new parameters for RCHGetYahooQuotes(), Excel returns "You cannot change part of array". I'm kind of frustrated with this. Please let me know what I can do.Thank you so much!
>
> Wenxi
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.: Yahoo History

Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112

Fri Jul 1, 2011 1:57 pm (PDT)

Use RCHGetYahooHistory to retrieve end-of-month stock market prices. Noticed yesterday, June 30 (after market close), that while Yahoo posted the closing value for that day in its Historical Prices, RCHGetYahooHistory was retrieving the value of two days earlier for all securities. Now today, it is doing just fine. Is there a way to get the EOM values before the first day of the following month through GetYahooHistory which otherwise works just fine?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)

3.: cia.gov factbook

Posted by: "alexander" alex.life2539@gmail.com life2539

Fri Jul 1, 2011 11:36 pm (PDT)

Just curious,

Has anybody looked up data from cia.gov factbook? I would like to pull some economic information about countries particularly their ranking system for the different socio-economic and demographic indicators which I have yet to find an alternative site where all the information is in one place.

here is the website if you are curious.

https://www.cia.gov/library/publications/the-world-factbook/rankorder/rankorderguide.html

If anybody has attempted anything on this, I'd like know what you did. thanks!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

Messages | Files | Photos | Polls