Messages In This Digest (10 Messages)
- 1a.
- Re: Quick Start From: sophoclessophocleous
- 2a.
- Re: Problem with retrieving data from Google. From: verncush
- 3a.
- Can you guide me where is website with S&P500? From: bleushin19
- 3b.
- Re: Can you guide me where is website with S&P500? From: Randy Harmelink
- 3c.
- Re: Can you guide me where is website with S&P500? From: bleushin19
- 3d.
- Re: Can you guide me where is website with S&P500? From: Randy Harmelink
- 4a.
- Re: RCHGetElementNumber Error From: Bo Sutton
- 4b.
- Re: RCHGetElementNumber Error From: Randy Harmelink
- 5a.
- ^GSPC vs VFINX v SPY From: lexstar
- 5b.
- Re: ^GSPC vs VFINX v SPY From: Tim Price
Messages
- 1a.
-
Re: Quick Start
Posted by: "sophoclessophocleous" sophoclessophocleous@yahoo.com sophoclessophocleous
Thu Jun 21, 2012 5:48 am (PDT)
This fixed it:
http://finance.groups.yahoo. com/group/ smf_addin/ message/10464
It was the Internet settings!!!!!!!
Thanks Randy! You rock!
Sophocles
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Take a look at the AdvFN item in the LINKS area of the group. Some people
> have needed that fix before AdvFN would work.
>
> Another issue might be if you are in a foreign country. The AdvFN website
> does redirect people to different URLs based on their location, which can
> affect how you access their data.
>
> On Wed, Jun 20, 2012 at 6:27 AM, sophoclessophocleous <
> sophoclessophocleous@...> wrote:
>
> > This is the 2nd time I writing this. Unfortunately my very lengthy first
> > reply may have been lost :(
> > Overall I am starting to understand but am having problems with the data.
> > This formula works:
> > =RCHGetElementNumber("GOOG", 3308)
> >
> > Please note that 3312 and 3313 produce an error and I guess it is because
> > google now only gives 4 yrs of data.
> >
> > What is the equivalent for AdvFN?
> > I tried =RCHGetElementNumber("GOOG", 5296)
> > But that does not work. I even registered for their website but still
> > nothing.
> >
> > Do I need to use some other formula?
> >
>
- 2a.
-
Re: Problem with retrieving data from Google.
Posted by: "verncush" verncush@yahoo.com verncush
Thu Jun 21, 2012 6:38 am (PDT)
Hi Doug,
Would you mind sharing the spreadsheet you put together to extract the tickers from this code?
Thanks,
Vern Cushenbery
913-707-1136
vern@cushcapital.com
--- In smf_addin@yahoogroups.com , "paddoq" <paddoq@...> wrote:
>
>
>
> well said Doug - a long overdue thank you to you Randy - this has been huge for me, your incredible product, as well as your generosity & giving is really something. THANK YOU VERY MUCH.
>
> Doug - I tried several different ways to get at that particular data also - but I couldn't figure it out, in fact I struggled to get at any data on google finance using gettablecell GetWebData ec..
>
> Great if you figure it out.
>
> --- In smf_addin@yahoogroups.com , "Douglas" <jurisdoctor74@> wrote:
> >
> > Randy,
> >
> > Let me first compliment you on creating a revolutionary piece of software that, for the first time, single-handedly equalizes the playing field between institutional and individual investors' access to key investment data. Not many individuals can afford the many thousands of dollars it would cost for a subscription to the Compustat data base. And the "SMF Add-In" you generously made available to the public at absolutely no cost runs a close second to Compustat's power to retrieve market data. Thank you for this unbelievable show of largesse.
> >
> > Now for my question. I am trying to figure out a way to download the list of "Related" companies that appears upon inputting a stock symbol on the page: http://www.google.com/finance? (IBM is my example). The page conveniently provides a list of companies that are similar to and compete with the subject company. So, for example, it lists IBM's competitors as ORCL, MSFT, HPQ, INTC, JAVA, CSCO, GOOG, DELL, AMC, and AMD.q=ibm
> >
> > I have already unsuccessfully tried the following functions: RCHGetHTMLTable, RCHGetTableCell, RCHGetWebData, and smfGetCSVFile (this one I'm not sure how to use), but had no luck in extracting the subject data. (I was able to download a little of the data in the extreme right column, but this was of no interest to me.)
> >
> > Generally speaking, I have had good luck in using these functions but, after spending many fruitless hours of trying, I am now totally "clueless" as to how to proceed. Your assistance would be most appreciated.
> >
> > Sincere regards,
> >
> > Doug
> >
>
- 3a.
-
Can you guide me where is website with S&P500?
Posted by: "bleushin19" bleushin19@yahoo.com bleushin19
Thu Jun 21, 2012 7:49 am (PDT)
Hello Randy,
Thank you for creating this very great program, it really teaches me alot. I have some few questions though,I am using yahoo , google, msn and reuters finance in getting datas. Before there was an S&P500 data at reuters but they removed it. Are there any sites except msn finance that I could go with to gather data for an S&P500?
Thank You
Archie
- 3b.
-
Re: Can you guide me where is website with S&P500?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jun 21, 2012 7:52 am (PDT)
What kind of data?
On Thu, Jun 21, 2012 at 7:49 AM, bleushin19 <bleushin19@yahoo.com > wrote:
>
> Thank you for creating this very great program, it really teaches me alot.
> I have some few questions though,I am using yahoo , google, msn and reuters
> finance in getting datas. Before there was an S&P500 data at reuters but
> they removed it. Are there any sites except msn finance that I could go
> with to gather data for an S&P500?
>
- 3c.
-
Re: Can you guide me where is website with S&P500?
Posted by: "bleushin19" bleushin19@yahoo.com bleushin19
Thu Jun 21, 2012 8:38 am (PDT)
I used this before getting data for reuters and it work but now they kind of a removed it from there sit.
ex: RCHGetElementNumber(Ticker,13629) for valuation ratio S&P500
I could use msn too, but data were quite few but its working
ex: RCHGetElementNumber(Ticker, 152) MSN key ratio
are there any other website where I can get data for S&P500?
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> What kind of data?
>
> On Thu, Jun 21, 2012 at 7:49 AM, bleushin19 <bleushin19@...> wrote:
>
> >
> > Thank you for creating this very great program, it really teaches me alot.
> > I have some few questions though,I am using yahoo , google, msn and reuters
> > finance in getting datas. Before there was an S&P500 data at reuters but
> > they removed it. Are there any sites except msn finance that I could go
> > with to gather data for an S&P500?
> >
>
- 3d.
-
Re: Can you guide me where is website with S&P500?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jun 21, 2012 9:01 am (PDT)
Yahoo's ETF browser has a lot of few data items:
http://finance.yahoo.com/ etf/browser/ mkt?c=0&k= 5&f=0&o=d& cs=1&ce=1438
On Thu, Jun 21, 2012 at 8:35 AM, bleushin19 <bleushin19@yahoo.com > wrote:
>
> I used this before getting data for reuters and it work but now they kind
> of a removed it from there sit.
>
> ex: RCHGetElementNumber(Ticker,13629) for valuation ratio S&P500
>
> I could use msn too, but data were quite few but its working
>
> ex: RCHGetElementNumber(Ticker, 152) MSN key ratio
>
> are there any other website where I can get data for S&P500?
>
- 4a.
-
Re: RCHGetElementNumber Error
Posted by: "Bo Sutton" stepuptome229@yahoo.com stepuptome229
Thu Jun 21, 2012 12:25 pm (PDT)
That makes sense. Thank you for your help. It is pretty incredible you help so many people learn how to use this wonderful tool. Well my next question would be, is there some sort of template out there that would allow me to pull standardized financial statements for financial companies? I found this cool tool on here called smfGetAdvFNElement-Template- All-Line- Items which works awesome since it includes all the line items. The bummer is that each company reports different line items, so it is not feasible to link cells as the position and names of each line change as the company selected changes/
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Tuesday, June 19, 2012 11:39 AM
Subject: Re: [smf_addin] RCHGetElementNumber Error
The reason PCC doesn't work is that it's a financial institution. They have different line items than normal companies.
On Tue, Jun 19, 2012 at 9:35 AM, Bo Sutton <stepuptome229@yahoo.com > wrote:
>
>Files>templates and examples> uploaded by forum members> 10 year financial summary
>
- 4b.
-
Re: RCHGetElementNumber Error
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jun 21, 2012 1:25 pm (PDT)
You can use that template, but pick and choose which line items you want.
Just convert the list of line items into values on a financial company and
that would be your fixed location line items for financial companies.
Even on the normal companies' templates, all possible line items are not
being accounted for. Only those I chose to implement.
On Thu, Jun 21, 2012 at 12:22 PM, Bo Sutton <stepuptome229@yahoo.com > wrote:
>
> That makes sense. Thank you for your help. It is pretty incredible you
> help so many people learn how to use this wonderful tool. Well my next
> question would be, is there some sort of template out there that would
> allow me to pull standardized financial statements for financial companies?
> I found this cool tool on here called
> smfGetAdvFNElement-Template- All-Line- Items which works awesome since it
> includes all the line items. The bummer is that each company reports
> different line items, so it is not feasible to link cells as the position
> and names of each line change as the company selected changes/
>
- 5a.
-
^GSPC vs VFINX v SPY
Posted by: "lexstar" lexstar@yahoo.com lexstar
Thu Jun 21, 2012 6:16 pm (PDT)
Does anyone know why ^GSPC have returns different from VFINX and SPY? My assumption is that ^GSPC is a total return index, and therefore, should give a return similar to (or should be MORE) than VFINX and SPY. But, my calculations show that the returns for ^GSPC are always LOWER than VFINX and SPY.
What's the reason behind that, anyone know?
- 5b.
-
Re: ^GSPC vs VFINX v SPY
Posted by: "Tim Price" tim@riverrockinvestors.com sweetpercyz
Thu Jun 21, 2012 6:22 pm (PDT)
I do not believe ^GSPC includes dividends
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of lexstar
Sent: Thursday, June 21, 2012 8:16 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] ^GSPC vs VFINX v SPY
Does anyone know why ^GSPC have returns different from VFINX and SPY? My
assumption is that ^GSPC is a total return index, and therefore, should give
a return similar to (or should be MORE) than VFINX and SPY. But, my
calculations show that the returns for ^GSPC are always LOWER than VFINX and
SPY.
What's the reason behind that, anyone know?
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