Messages In This Digest (12 Messages)
- 1a.
- Re: Hi, Japanese Tickers earning date From: Randy Harmelink
- 2a.
- Table update From: Bruce Hedrick
- 2b.
- Re: Table update From: Randy Harmelink
- 3a.
- Re: Macintosh users? From: JP
- 3b.
- Re: Macintosh users? From: Randy Harmelink
- 3c.
- Re: Macintosh users? From: JP
- 3d.
- Re: Macintosh users? From: Randy Harmelink
- 4.1.
- RCHGetYahooQuotes() From: Randy H
Messages
- 1a.
-
Re: Hi, Japanese Tickers earning date
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 17, 2012 2:36 am (PDT)
You retrieve what they have...
If you want specific items, you'll need to retrieve multiple items and then
pick and choose.
On Wed, May 16, 2012 at 11:05 PM, Chirag Vyas <vyas.chirag@yahoo.in > wrote:
>
> Thanks, that really helped but is there anyway that I can get the most
> recent earnings. Like earnings about to come in May or already came last
> month in April. Like 60 days before Today and 60 days after today? This
> formula fetches earnings even for 2013.
>
- 2a.
-
Table update
Posted by: "Bruce Hedrick" bmh910427@comcast.net bmhedrick2000
Thu May 17, 2012 7:56 am (PDT)
Randy. I have struggled with updating a download table using ctrl-shift-j. The results of the table update no longer picks up name element (either 13862 or 13863). I have updated the new smf-elements-1.txt you sent out. In fact, this command (example) =RCHGetElementNumbe r("PG",13862) , when used on it's own in my spreadsheet, works fine and pulls in the company name. However, when I try to update the same element number in a table update, I get "error" under name whether I use 13862 or 13863. The other table elements seem to get updated OK (eg. price, beta, etc. I have searched my hard drive and updated any occurrences of smf-elements- 1.txt to make sure I have the latest version. Any thoughts on this?
Thanks for your help.
BruceH
- 2b.
-
Re: Table update
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 17, 2012 8:36 am (PDT)
The new method of defining elements, specifying a formula, no longer seems
to work for the table update process. You'd need to hard-code those
definitions in the table. See:
http://finance.groups.yahoo. com/group/ smf_addin/ message/18470
On Thu, May 17, 2012 at 7:51 AM, Bruce Hedrick <bmh910427@comcast.net >wrote:
> Randy. I have struggled with updating a download table using ctrl-shift-j.
> The results of the table update no longer picks up name element (either
> 13862 or 13863). I have updated the new smf-elements-1.txt you sent out. In
> fact, this command (example) =RCHGetElementNumber("PG",13862) , when used on
> it's own in my spreadsheet, works fine and pulls in the company name.
> However, when I try to update the same element number in a table update, I
> get "error" under name whether I use 13862 or 13863. The other table
> elements seem to get updated OK (eg. price, beta, etc. I have searched my
> hard drive and updated any occurrences of smf-elements-1.txt to make sure I
> have the latest version. Any thoughts on this?
>
- 3a.
-
Re: Macintosh users?
Posted by: "JP" front.paige@yahoo.com front.paige
Thu May 17, 2012 9:32 am (PDT)
Thanks for the info. I have tried this before. But, it never worked. This did work. Now I need to find all those attributes to get the info I want and need.
Thank,
James
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, May 16, 2012 3:59 PM
Subject: Re: [smf_addin] Macintosh users?
Can you open a file from the Internet? For example:
http://download.finance.yahoo. com/d/quotes. csv?s=MMM, IBM,SPY,IWM& f=sl1d1t1c1ohgv& e=.csv
On Wed, May 16, 2012 at 1:22 PM, JP <front.paige@yahoo.com > wrote:
I am using Excel 2011 for Mac. I would like to pull data from any website to update a stock portfolio. But, The Mac version os Excel will do not do Web Queries like older versions.
>
>I have been told that I need another software package that allows Excel for mac to preform Web Queries to pull data. Does anyone have any experience with this?
>
- 3b.
-
Re: Macintosh users?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 17, 2012 9:36 am (PDT)
Check out the documentation for the RCHGetYahooQuotes() function in the
"Documentation" folder of the files area of the group. Most, if not all, of
the usable data codes are defined there.
On Thu, May 17, 2012 at 9:32 AM, JP <front.paige@yahoo.com > wrote:
>
> Thanks for the info. I have tried this before. But, it never worked. This
> did work. Now I need to find all those attributes to get the info I want
> and need.
>
- 3c.
-
Re: Macintosh users?
Posted by: "JP" front.paige@yahoo.com front.paige
Thu May 17, 2012 10:27 am (PDT)
thanks that helps a lot.
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, May 17, 2012 11:36 AM
Subject: Re: [smf_addin] Macintosh users?
Check out the documentation for the RCHGetYahooQuotes() function in the "Documentation" folder of the files area of the group. Most, if not all, of the usable data codes are defined there.
On Thu, May 17, 2012 at 9:32 AM, JP <front.paige@yahoo.com > wrote:
>
>Thanks for the info. I have tried this before. But, it never worked. This did work. Now I need to find all those attributes to get the info I want and need.
>
- 3d.
-
Re: Macintosh users?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 17, 2012 10:37 am (PDT)
Another item you may want to look at -- go to the "Links" area of the group
and find the link to documentation on using FinViz. Their screener tool
creates a CSV file. And you can customize/create that CSV file via the URL
parameters.
For example, try opening this CSV file in EXCEL:
http://finviz.com/export. ashx?v=151& t=MMM,NFLX& c=1,17,18, 19,20,21
On Thu, May 17, 2012 at 9:32 AM, JP <front.paige@yahoo.com > wrote:
>
>
> Thanks for the info. I have tried this before. But, it never worked. This
> did work. Now I need to find all those attributes to get the info I want
> and need.
>
- 4.1.
-
RCHGetYahooQuotes()
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Thu May 17, 2012 1:31 pm (PDT)
No numbers -- Yahoo codes. "l1" is what to use for last price. Check the
documentation for other available Yahoo codes.
On Thu, May 17, 2012 at 1:19 PM, ricky.parikh <ricky.parikh@...
<mailto:ricky.parikh@yahoo.com > > wrote:
Thanks so much for your work. You mentioned people should use
getyahooquotes() instead of getelementnumber( __, 25) for last price.
What number besides my cell number corresponding to the ticker should I
use for yahoo, i.e. to replace the 25? Thanks for your help.
- 5a.
-
MSN10
Posted by: "Paulo" palminha@yahoo.com palminha
Thu May 17, 2012 2:29 pm (PDT)
Hi,
Is there any new way to get the MSN10 data ? Because now I can´t get it.
I have many sheets linked and using thata information, so I can apreciate some guidance about how to get the same data in any other way!
Thany you all for any help I can get to solve my problem.
Paulo
- 5b.
-
Re: MSN10
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 17, 2012 2:42 pm (PDT)
Do you have the new element definitions from the "Works in Progress"
folder? It was a big topic of conversation here a month or so ago when MSN
changed their web site structure. You may want to look over some of those
message threads.
On Thu, May 17, 2012 at 2:29 PM, Paulo <palminha@yahoo.com > wrote:
>
> Is there any new way to get the MSN10 data ? Because now I can´t get it.
>
> I have many sheets linked and using thata information, so I can apreciate
> some guidance about how to get the same data in any other way!
>
> Thany you all for any help I can get to solve my problem.
>
- 5c.
-
Re: MSN10
Posted by: "Paulo" palminha@yahoo.com palminha
Thu May 17, 2012 3:26 pm (PDT)
Well I check it once again, and I have to say yes to your question!
I prefer to say no, because I guess it was the best way to solve it :-))
Now I don´t know what maybe wrong! :-((
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Do you have the new element definitions from the "Works in Progress"
> folder? It was a big topic of conversation here a month or so ago when MSN
> changed their web site structure. You may want to look over some of those
> message threads.
>
> On Thu, May 17, 2012 at 2:29 PM, Paulo <palminha@...> wrote:
>
> >
> > Is there any new way to get the MSN10 data ? Because now I can´t get it.
> >
> > I have many sheets linked and using thata information, so I can apreciate
> > some guidance about how to get the same data in any other way!
> >
> > Thany you all for any help I can get to solve my problem.
> >
>
- 5d.
-
Re: MSN10
Posted by: "Paulo" palminha@yahoo.com palminha
Thu May 17, 2012 4:12 pm (PDT)
Ups sorry but finaly I know whay happen!
It is solved :-))
Thank you
--- In smf_addin@yahoogroups.com , "Paulo" <palminha@...> wrote:
>
> Well I check it once again, and I have to say yes to your question!
>
> I prefer to say no, because I guess it was the best way to solve it :-))
>
> Now I don´t know what maybe wrong! :-((
>
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Do you have the new element definitions from the "Works in Progress"
> > folder? It was a big topic of conversation here a month or so ago when MSN
> > changed their web site structure. You may want to look over some of those
> > message threads.
> >
> > On Thu, May 17, 2012 at 2:29 PM, Paulo <palminha@> wrote:
> >
> > >
> > > Is there any new way to get the MSN10 data ? Because now I can´t get it.
> > >
> > > I have many sheets linked and using thata information, so I can apreciate
> > > some guidance about how to get the same data in any other way!
> > >
> > > Thany you all for any help I can get to solve my problem.
> > >
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar