15 New Messages
Digest #2966
Messages
Thu Feb 13, 2014 12:53 am (PST) . Posted by:
"Randy Harmelink" rharmelink
To which functionality are you referring? You can find more information on
the smfForceRecalculation and smfUpdateDownloadTable macros in the LINKS
area of the group. But neither of them is an "automatic update" process.
On Thu, Feb 13, 2014 at 1:33 AM, <matthewpaulreid@gmail.com> wrote:
>
> Where is this macro? which folder? for some reason i could not find it...
>
the smfForceRecalculati
area of the group. But neither of them is an "automatic update" process.
On Thu, Feb 13, 2014 at 1:33 AM, <matthewpaulreid@
>
> Where is this macro? which folder? for some reason i could not find it...
>
Thu Feb 13, 2014 9:15 am (PST) . Posted by:
"Marc ." whichwaytobeach
Thank you, John. I appreciate the help.
Marc
To: smf_addin@yahoogroups.com
From: thomas.m.carnevale@gmail.com
Date: Wed, 12 Feb 2014 19:41:58 -0800
Subject: [smf_addin] RE: Want to Make Dividend Histogram
The "date" value is just one value in the array. Select an array of cells that's 2 columns by 15 rows. Hit F2 and type in =rchgetyahoohistory("aapl";,,,,,,,"v") (entering the ticker you want) and then hit control shift enter. You can also put the ticker in a cell so it's easy to change. The date by default will be formatted as a number, you should format it as a date.
Marc
To: smf_addin@yahoogrou
From: thomas.m.carnevale@
Date: Wed, 12 Feb 2014 19:41:58 -0800
Subject: [smf_addin] RE: Want to Make Dividend Histogram
The "date" value is just one value in the array. Select an array of cells that's 2 columns by 15 rows. Hit F2 and type in =rchgetyahoohistory
Thu Feb 13, 2014 9:15 am (PST) . Posted by:
"Marc ." whichwaytobeach
Thank you, Mike. I will look into this some more.
Regards,
Marc
To: smf_addin@yahoogroups.com
From: mikemcq802@yahoo.com
Date: Wed, 12 Feb 2014 19:38:18 -0800
Subject: RE: [smf_addin] RE: Want to Make Dividend Histogram
You just need to enter it as an array formula. Search the conversations, see the help, or Google excel and array formula. It's well covered.
A specific example for Yahoo dividend history is in the Files / Templates section of this group. See SMF-Template-Yahoo-Historical-Quotes.xls. It is setup for pricing. To get dividends the trick is to put a "V" in the "period" box. You can blank out the "items" flags.
Regards,
Marc
To: smf_addin@yahoogrou
From: mikemcq802@yahoo.
Date: Wed, 12 Feb 2014 19:38:18 -0800
Subject: RE: [smf_addin] RE: Want to Make Dividend Histogram
You just need to enter it as an array formula. Search the conversations, see the help, or Google excel and array formula. It's well covered.
A specific example for Yahoo dividend history is in the Files / Templates section of this group. See SMF-Template-
Thu Feb 13, 2014 11:52 am (PST) . Posted by:
"Marc ." whichwaytobeach
It be nice, as it is with so many other fundamental areas covered already, that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 - FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not sure why there needs to be a struggle just to get the same thing for Dividends. I do not see this in the listing.
Marc
To: smf_addin@yahoogroups.com
From: thomas.m.carnevale@gmail.com
Date: Wed, 12 Feb 2014 19:41:58 -0800
Subject: [smf_addin] RE: Want to Make Dividend Histogram
The "date" value is just one value in the array. Select an array of cells that's 2 columns by 15 rows. Hit F2 and type in =rchgetyahoohistory("aapl";,,,,,,,"v") (entering the ticker you want) and then hit control shift enter. You can also put the ticker in a cell so it's easy to change. The date by default will be formatted as a number, you should format it as a date.
For instance, I already pull in and graph, things like: EPS for FY1 - FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not sure why there needs to be a struggle just to get the same thing for Dividends. I do not see this in the listing.
Marc
To: smf_addin@yahoogrou
From: thomas.m.carnevale@
Date: Wed, 12 Feb 2014 19:41:58 -0800
Subject: [smf_addin] RE: Want to Make Dividend Histogram
The "date" value is just one value in the array. Select an array of cells that's 2 columns by 15 rows. Hit F2 and type in =rchgetyahoohistory
Thu Feb 13, 2014 12:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
If you want them by fiscal years, you could try AdvFN elements #5896 thru
#5905...
Most people want dividends by calendar periods rather than fiscal periods.
They don't always line up the same, for comparisons between companies. And
getting them from the annual financials will always mean reporting delays
for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <WHICHWAYTOBEACH@hotmail.com>wrote:
>
> It be nice, as it is with so many other fundamental areas covered already,
> that Dividends was covered in the FY1-FY10 format.
>
> For instance, I already pull in and graph, things like: EPS for FY1 -
> FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am
> not sure why there needs to be a struggle just to get the same thing for
> Dividends. I do not see this in the listing.
>
>
#5905...
Most people want dividends by calendar periods rather than fiscal periods.
They don't always line up the same, for comparisons between companies. And
getting them from the annual financials will always mean reporting delays
for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <WHICHWAYTOBEACH@
>
> It be nice, as it is with so many other fundamental areas covered already,
> that Dividends was covered in the FY1-FY10 format.
>
> For instance, I already pull in and graph, things like: EPS for FY1 -
> FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am
> not sure why there needs to be a struggle just to get the same thing for
> Dividends. I do not see this in the listing.
>
>
Thu Feb 13, 2014 1:00 pm (PST) . Posted by:
mmkantor
I have a list of muni bond cusips and am using the add-in to access information on the Emma site.(the description) I would like to actually return the link to the OS PDF document that is found towards the bottom of the page. It would be even cooler if I could also (via addin) retrieve a paragraph of text from the pdf as well.
That would make my life and excel worksheet complete. Not really, but would be awesome.
Thanks.
-Mark
That would make my life and excel worksheet complete. Not really, but would be awesome.
Thanks.
-Mark
Thu Feb 13, 2014 1:04 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Without a sample URL, I can't give details.
Retrieval of the link should be possible. But I've only seen one instance
where data could be extracted from a PDF, since the data is typically not
stored as actual text.
On Thu, Feb 13, 2014 at 1:53 PM, <mmkantor@gmail.com> wrote:
>
> I have a list of muni bond cusips and am using the add-in to access
> information on the Emma site.(the description)
> I would like to actually return the link to the OS PDF document that is
> found towards the bottom of the page. It would be even cooler if I could
> also (via addin) retrieve a paragraph of text from the pdf as well.
> That would make my life and excel worksheet complete. Not really, but
> would be awesome.
>
>
Retrieval of the link should be possible. But I've only seen one instance
where data could be extracted from a PDF, since the data is typically not
stored as actual text.
On Thu, Feb 13, 2014 at 1:53 PM, <mmkantor@gmail.
>
> I have a list of muni bond cusips and am using the add-in to access
> information on the Emma site.(the description)
> I would like to actually return the link to the OS PDF document that is
> found towards the bottom of the page. It would be even cooler if I could
> also (via addin) retrieve a paragraph of text from the pdf as well.
> That would make my life and excel worksheet complete. Not really, but
> would be awesome.
>
>
Thu Feb 13, 2014 4:16 pm (PST) . Posted by:
"Mark Kantor" mmkantor
Sorry about that....
http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=130483AM
I've also attached the xls I started on..... In this example, the pdf is..
http://emma.msrb.org/MS262064-MS237372-MD463155.pdf
On Thu, Feb 13, 2014 at 4:04 PM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>
> Without a sample URL, I can't give details.
>
> Retrieval of the link should be possible. But I've only seen one instance
> where data could be extracted from a PDF, since the data is typically not
> stored as actual text.
>
>
> On Thu, Feb 13, 2014 at 1:53 PM, <mmkantor@gmail.com> wrote:
>
>>
>> I have a list of muni bond cusips and am using the add-in to access
>> information on the Emma site.(the description)
>> I would like to actually return the link to the OS PDF document that is
>> found towards the bottom of the page. It would be even cooler if I could
>> also (via addin) retrieve a paragraph of text from the pdf as well.
>> That would make my life and excel worksheet complete. Not really, but
>> would be awesome.
>>
>>
>
>
http://emma.
I've also attached the xls I started on..... In this example, the pdf is..
http://emma.
On Thu, Feb 13, 2014 at 4:04 PM, Randy Harmelink <rharmelink@gmail.
>
>
> Without a sample URL, I can't give details.
>
> Retrieval of the link should be possible. But I've only seen one instance
> where data could be extracted from a PDF, since the data is typically not
> stored as actual text.
>
>
> On Thu, Feb 13, 2014 at 1:53 PM, <mmkantor@gmail.
>
>>
>> I have a list of muni bond cusips and am using the add-in to access
>> information on the Emma site.(the description)
>> I would like to actually return the link to the OS PDF document that is
>> found towards the bottom of the page. It would be even cooler if I could
>> also (via addin) retrieve a paragraph of text from the pdf as well.
>> That would make my life and excel worksheet complete. Not really, but
>> would be awesome.
>>
>>
>
>
Attachments with this message:
1 of 1 File(s)
Thu Feb 13, 2014 4:44 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You should be able to get the name of the PDF file with something like:
=smfstrExtr(smfGetTagContent("
http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=130483AM","td",2,"Download
Document"),"href=""/","""")
Just concatenate the domain to the front to get the link.
However, the content of the PDF document is encoded, so I don't see a way
for the add-in to extract anything from it. I'm sure there are other tools
that can do a PDF to TXT conversion, but I don't currently use any.
On Thu, Feb 13, 2014 at 5:16 PM, Mark Kantor <mmkantor@gmail.com> wrote:
>
> Sorry about that....
>
> http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=130483AM
>
> I've also attached the xls I started on..... In this example, the pdf is..
> http://emma.msrb.org/MS262064-MS237372-MD463155.pdf
>
>
=smfstrExtr(
http://emma.
Document"
Just concatenate the domain to the front to get the link.
However, the content of the PDF document is encoded, so I don't see a way
for the add-in to extract anything from it. I'm sure there are other tools
that can do a PDF to TXT conversion, but I don't currently use any.
On Thu, Feb 13, 2014 at 5:16 PM, Mark Kantor <mmkantor@gmail.
>
> Sorry about that....
>
> http://emma.
>
> I've also attached the xls I started on..... In this example, the pdf is..
> http://emma.
>
>
Thu Feb 13, 2014 4:12 pm (PST) . Posted by:
Charles8839
Write a message...
Thu Feb 13, 2014 6:44 pm (PST) . Posted by:
mikemcq802
SMF is "screen scraping" - it does not maintain any data files of its own.
You can use it to scrape any website using functions such as RCHGetTableCell, RCHGetWebData, SMFGetTagContent and so on. The GetElement and some of the other functions are just Randy providing an easier method so each person doesn't have to hand-code the details of the "scrape".
You can use it to scrape any website using functions such as RCHGetTableCell, RCHGetWebData, SMFGetTagContent and so on. The GetElement and some of the other functions are just Randy providing an easier method so each person doesn't have to hand-code the details of the "scrape"
Thu Feb 13, 2014 10:39 pm (PST) . Posted by:
amir.rehman
I want to load entire data rows from google stock screener based on my criteria.
Thanks,
Amir
Thanks,
Amir
Thu Feb 13, 2014 10:55 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but the output isn't within the source code of the web page, so it's
not accessible to the add-in.
On Thu, Feb 13, 2014 at 11:39 PM, <amir.rehman@yahoo.com> wrote:
>
> I want to load entire data rows from google stock screener based on my
> criteria.
>
not accessible to the add-in.
On Thu, Feb 13, 2014 at 11:39 PM, <amir.rehman@
>
> I want to load entire data rows from google stock screener based on my
> criteria.
>
Thu Feb 13, 2014 11:22 pm (PST) . Posted by:
amir.rehman
=smfPricesByDates("TICKER", today())
Thu Feb 13, 2014 11:28 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Not recommended. That first gets historical quotes from Yahoo, and then
fills it in from this function if it's not there and later than the latest
historical date:
=RCHGetYahooQuotes("MMM","l1")
So you'd end up with two Internet accesses for each quote. You're better
off just using the function above, and getting it directly with one
Internet access. Plus, it can get you data on up to 200 ticker symbols with
a single Internet access.
On Fri, Feb 14, 2014 at 12:22 AM, <amir.rehman@yahoo.com> wrote:
>
> =smfPricesByDates("TICKER", today())
>
fills it in from this function if it's not there and later than the latest
historical date:
=RCHGetYahooQuotes(
So you'd end up with two Internet accesses for each quote. You're better
off just using the function above, and getting it directly with one
Internet access. Plus, it can get you data on up to 200 ticker symbols with
a single Internet access.
On Fri, Feb 14, 2014 at 12:22 AM, <amir.rehman@
>
> =smfPricesByDates(
>
Tidak ada komentar:
Posting Komentar