4 New Messages
Digest #2752
Messages
Fri Aug 30, 2013 5:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't see how the number of rows is a problem. You just use the
RCHGetHTMLTable() over enough rows to grab what you expect to be the
largest table. Even 100 rows if you need.
And if there is no table, the RCHGetHTMLTable() area will just be filled
with blanks, so I don't see how it's a problem.
On Thu, Aug 29, 2013 at 10:34 AM, Kermit W. Prather <kermitp@tampabay.rr.com
> wrote:
>
>
> I want to download the complete table and then calculate the shares
> because the number of rows varies from stock to stock. Some stocks have no
> splits (AGNC)****
>
> so there is not table. ****
>
> Just a text message at top of page. I can retrieve with ****
>
> =smfGetTagContent("http://getsplithistory.com/ "&A1,"div",0,"splits-text";)
> ****
>
> this returns****
>
> <b>International Business Machines Corp.</b> has had <b>7</b> splits.****
>
> Where the 7 tell me there has been 7 splits so there will be 7 rows in
> the table. ****
>
> Some stock will have more Walmart has 9 splits.****
>
> So I need the table to be expandable.****
>
> ** **
>
> My real problem is I can't figure out how to download the table. ****
>
>
>
RCHGetHTMLTable(
largest table. Even 100 rows if you need.
And if there is no table, the RCHGetHTMLTable(
with blanks, so I don't see how it's a problem.
On Thu, Aug 29, 2013 at 10:34 AM, Kermit W. Prather <kermitp@tampabay.
> wrote:
>
>
> I want to download the complete table and then calculate the shares
> because the number of rows varies from stock to stock. Some stocks have no
> splits (AGNC)****
>
> so there is not table. ****
>
> Just a text message at top of page. I can retrieve with ****
>
> =smfGetTagContent(
> ****
>
> this returns****
>
> <b>Internatio
>
> Where the 7 tell me there has been 7 splits so there will be 7 rows in
> the table. ****
>
> Some stock will have more Walmart has 9 splits.****
>
> So I need the table to be expandable.*
>
> ** **
>
> My real problem is I can't figure out how to download the table. ****
>
>
>
Fri Aug 30, 2013 7:23 am (PDT) . Posted by:
bushpilote
Good morning Randy,
Just want to add my two cents to the Advfn data discussion.
I was able to bring FTR'S latest and historical financial data into a spreadsheet from the new Advfn site with the smf-addin. It's not as elegant and efficient as it was prior to the revamped website but it worked with FTR.
For those who are interested in testing it out here's how you do it:
1. Go to this Group files section
2. Open SmfGetTagContent
3. Download and open SmfGetTagContent-Quick-Webpage-Examination.xls
4. Paste the following url (http://www.advfn.com/common/financial/NASDAQ/frontier-communications-corp-mm-FTR/full-financials?isfull=1&bsfull=1&cffull=1 ) in the web page cell. Do this in all of the five sheets of the spreadsheet. Data will start to appear.
5. Make a copy of "By Table Cell" sheet in the same spreadsheet
a)Paste the url address in 4 in cell C9
b)Keep cells c10:c14 blank
c)Paste =IF($C$9="None","--",RCHGetTableCell($C$9,C$17,"<body",,,,$B18,,,"--")) in C18
d)Drag formula in C18 across columns(to 12) and rows (to 7)
f)Extending columns and formula from 12 (N17) to 90 (CN17) and rows B25 (7) to 371 (B389) or so will give you all annual financial statements for frontier communications.
g) For Quarterly data paste this url:(http://www.advfn.com/common/financial/NASDAQ/frontier-communications-corp-mm-FTR/full-financials?isfull=1&bsfull=1&cffull=1&pm=Q )in C9.
h) Be patient. It will take some time to populate the spreadsheet.
Question: What does "mm" between "copr" and "FTR" stand for?
Hope this helps.
--- In smf_addin@yahoogroups.com , "osv_jaejun" <jjun0366@...> wrote:
>
>
>
> This is for you if you are in need of financial data to import into your spreadsheet.
>
> I am very grateful to Randy for his amazing add-in and I used it primarily for many years and built a lot of spreadsheets out of it.
>
> But last year, websites started to change designs to become more dynamic and used less tables which meant data couldn't be pulled. I figured that sooner than later, scraping data was going to become difficult.
>
> Seems like this situation is very close.
>
> My name is Jae Jun and I run a website (oldschoolvalue.com) with a subscription to my own data feed for my stock analyzer product. It downloads and imports all the financial data along with valuation models and the works. You can use the SMF add-in along with the spreadsheet without any issues.
>
> But here's the deal. Until I started paying for the data, I didn't realize how expensive it was.
>
> With Randy's permission, if you are interested in accessing JUST the financial statements (downloads 10 annual statements and 5 quarterly numbers) without worrying about websites screwing up, then I can create a barebones version of my spreadsheet and offer it to SMF members ONLY. Think of it as a template.
>
> There will be a subscription price associated with it.
> Discounted of course because it was thanks to Randy for giving me the idea in the first place. Cost will likely be $20/month which is peanuts compared to the time and headache you will save yourself.
>
> Below is a sample excel file of what I'm talking about. You get the full financial statements, just like you did with advfn before all these changes.
>
> http://oldschoolvalue.s3.amazonaws.com/demo/SMF-Members-Only-Sample_Stock_Analyzer_Barebones.xls
>
> If Randy doesn't like the idea of selling on his group, then I apologize and won't bring it up again. Just think that this will be a good long-term solution to the current problems.
>
> If Randy is ok with it and there is enough people who are interested, then I will try to set up everything to make it happen.
>
> Before I post any more details, I'll see what Randy and you all think.
>
>
>
> --- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@> wrote:
> >
> > Folks, I think we have pretty well established that ADVFN site is not
> > working.
> >
> > I don't think we need any more posting to tell us what we already know.
> >
> > Come to think of it, we probably don't need my posting either.
> >
> > Have a nice day, everyone
> >
> > Kermit
> >
> > -----Original Message-----
> > From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
> > Of codyklein
> > Sent: Wednesday, August 28, 2013 7:26 PM
> > To: smf_addin@yahoogroups.com
> > Subject: [smf_addin] Re: Advfn data not updating in smf_addin
> >
> > The new site is disappointing IMO. Heres a peek at FTR:
> > http://www.advfn.com/common/financial/NASDAQ/frontier-communications-corp-mm
> > -FTR/full-financials?pm=Q
> >
> >
> > --- In smf_addin@yahoogroups.com , "codyklein" <codyklein@> wrote:
> > >
> > > The ADVFN site isn't even working right if you try and go back to get
> > annual data starting in 2003 or so it takes you to the wrong page, it kicks
> > you back to the summary page.
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
Just want to add my two cents to the Advfn data discussion.
I was able to bring FTR'S latest and historical financial data into a spreadsheet from the new Advfn site with the smf-addin. It's not as elegant and efficient as it was prior to the revamped website but it worked with FTR.
For those who are interested in testing it out here's how you do it:
1. Go to this Group files section
2. Open SmfGetTagContent
3. Download and open SmfGetTagContent-
4. Paste the following url (http://www.advfn.
5. Make a copy of "By Table Cell" sheet in the same spreadsheet
a)Paste the url address in 4 in cell C9
b)Keep cells c10:c14 blank
c)Paste =IF($C$9="
d)Drag formula in C18 across columns(to 12) and rows (to 7)
f)Extending columns and formula from 12 (N17) to 90 (CN17) and rows B25 (7) to 371 (B389) or so will give you all annual financial statements for frontier communications.
g) For Quarterly data paste this url:(http://www.advfn.
h) Be patient. It will take some time to populate the spreadsheet.
Question: What does "mm" between "copr" and "FTR" stand for?
Hope this helps.
--- In smf_addin@yahoogrou
>
>
>
> This is for you if you are in need of financial data to import into your spreadsheet.
>
> I am very grateful to Randy for his amazing add-in and I used it primarily for many years and built a lot of spreadsheets out of it.
>
> But last year, websites started to change designs to become more dynamic and used less tables which meant data couldn't be pulled. I figured that sooner than later, scraping data was going to become difficult.
>
> Seems like this situation is very close.
>
> My name is Jae Jun and I run a website (oldschoolvalue.
>
> But here's the deal. Until I started paying for the data, I didn't realize how expensive it was.
>
> With Randy's permission, if you are interested in accessing JUST the financial statements (downloads 10 annual statements and 5 quarterly numbers) without worrying about websites screwing up, then I can create a barebones version of my spreadsheet and offer it to SMF members ONLY. Think of it as a template.
>
> There will be a subscription price associated with it.
> Discounted of course because it was thanks to Randy for giving me the idea in the first place. Cost will likely be $20/month which is peanuts compared to the time and headache you will save yourself.
>
> Below is a sample excel file of what I'm talking about. You get the full financial statements, just like you did with advfn before all these changes.
>
> http://oldschoolval
>
> If Randy doesn't like the idea of selling on his group, then I apologize and won't bring it up again. Just think that this will be a good long-term solution to the current problems.
>
> If Randy is ok with it and there is enough people who are interested, then I will try to set up everything to make it happen.
>
> Before I post any more details, I'll see what Randy and you all think.
>
>
>
> --- In smf_addin@yahoogrou
> >
> > Folks, I think we have pretty well established that ADVFN site is not
> > working.
> >
> > I don't think we need any more posting to tell us what we already know.
> >
> > Come to think of it, we probably don't need my posting either.
> >
> > Have a nice day, everyone
> >
> > Kermit
> >
> > -----Original Message-----
> > From: smf_addin@yahoogrou
> > Of codyklein
> > Sent: Wednesday, August 28, 2013 7:26 PM
> > To: smf_addin@yahoogrou
> > Subject: [smf_addin] Re: Advfn data not updating in smf_addin
> >
> > The new site is disappointing IMO. Heres a peek at FTR:
> > http://www.advfn.
> > -FTR/full-financial
> >
> >
> > --- In smf_addin@yahoogrou
> > >
> > > The ADVFN site isn't even working right if you try and go back to get
> > annual data starting in 2003 or so it takes you to the wrong page, it kicks
> > you back to the summary page.
> > >
> >
> >
> >
> >
> > ------------
> >
> > Yahoo! Groups Links
> >
>
Fri Aug 30, 2013 5:27 pm (PDT) . Posted by:
mokwit
Does anyone know the GOOGLE Finance data element for number of
shares in float as defined by GOOG in their stock screener?
FloatShares outstanding, excluding those owned by insiders,
owned by 5%-or-more owners, or subject to SEC rule 144
(regarding restricted securities).
shares in float as defined by GOOG in their stock screener?
FloatShares outstanding, excluding those owned by insiders,
owned by 5%-or-more owners, or subject to SEC rule 144
(regarding restricted securities).
Fri Aug 30, 2013 9:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nothing that I'm aware of...I don't think they even display it when getting
information by ticker symbol.
On Fri, Aug 30, 2013 at 5:27 PM, <pmanz@usa.net> wrote:
>
> Does anyone know the GOOGLE Finance data element for number of shares in
> float as defined by GOOG in their stock screener?
>
> Float
> Shares outstanding, excluding those owned by insiders, owned by 5%-or-more
> owners, or subject to SEC rule 144 (regarding restricted securities).
>
information by ticker symbol.
On Fri, Aug 30, 2013 at 5:27 PM, <pmanz@usa.net> wrote:
>
> Does anyone know the GOOGLE Finance data element for number of shares in
> float as defined by GOOG in their stock screener?
>
> Float
> Shares outstanding, excluding those owned by insiders, owned by 5%-or-more
> owners, or subject to SEC rule 144 (regarding restricted securities).
>
Tidak ada komentar:
Posting Komentar