Rabu, 05 Desember 2012

[smf_addin] Digest Number 2424

15 New Messages

Digest #2424
1a
1b
1c
Re: Get Table Cell or Get HTML Table by "Randy Harmelink" rharmelink
2b
2d
3a
BarChart by "T" thomas777crown
3b
Re: BarChart by "Randy Harmelink" rharmelink
3c
Re: BarChart by "T" thomas777crown
3d
Re: BarChart by "Randy Harmelink" rharmelink
3e
Re: BarChart by "T" thomas777crown

Messages

Wed Dec 5, 2012 6:20 am (PST) . Posted by:

"Steven" stevenletzer

Thank you.

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> The data isn't in tables, so you need to use the smfGetTagContent()
> function. Here's what I got:
>
> =smfStrExtr(smfGetTagContent("http://www.valueappeal.com/tax-preparer/oa\
> kland-county/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-sh\
> apiro","div",-1,">Email"),"mailto:","""")
> =smfStrExtr(smfGetTagContent("http://www.valueappeal.com/tax-preparer/oa\
> kland-county/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-sh\
> apiro","div",-1,">Email"),"http://","""")
> =smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
> y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro","div\
> ",-1,"Phone:")
> =smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
> y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro","h1"\
> ,1,"Phone:")
> =smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
> y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro","h2"\
> ,1,"Phone:")
> =smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
> y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro","h3"\
> ,1,"Phone:")
>
> ...returned:
>
> ashapiro@... www.hswf.net/ Phone: 248-851-2211 Abba
> Shapiro Harelik Shapiro Wolgin & Fine Pc 30445 Northwestern
> Hwy #Ste, Farmington, MI 48334
>
> On Mon, Dec 3, 2012 at 7:09 AM, Steven <stevenletzer@...
> <mailto:stevenletzer@...> > wrote:
> This website provides contact information, for example tax preparers in
> Farmington MI; the web address is:
> http://www.valueappeal.com/tax-preparers/city/oakland-county/farmington-\
> mi
> <http://www.valueappeal.com/tax-preparers/city/oakland-county/farmington\
> -mi>
>
> I am trying to bring in the contact info without having to copy and
> paste. For example at this address:
> http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/527\
> 492/harelik-shapiro-wolgin-fine-pc/abba-shapiro
> <http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/52\
> 7492/harelik-shapiro-wolgin-fine-pc/abba-shapiro> , this information is
> displayed:
> ****************************************************************
> Abba Shapiro
>
>
> Harelik Shapiro Wolgin & Fine Pc
>
> 30445 Northwestern Hwy #Ste, Farmington, MI 48334
>
> Email (a link returns "ashapiro@... <mailto:ashapiro@...>
> <ashapiro@... <mailto:ashapiro@...> >")
> Website (a link that returns "http://www.hswf.net/
> <http://www.hswf.net/> ")
>
> Phone: 248-851-2211 <tel:248-851-2211> (text)
>
> ****************************************************************
>
> I know that I will have to copy and past the web address with the
> internal contact data. But that is one task vs. several.
>
> I need to capture the table data and the email and website data.
>
> Any ideas?
>

Wed Dec 5, 2012 11:16 am (PST) . Posted by:

"Steven" stevenletzer

There are 4 variables in the web address string. When I copy the web addess into Excel, the web address is copied in fields, that are determined by the "/". For example this address copied in Cell B5,
http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/345904/ernest-h-turken-pc-cpa/ernest-turken --- is copied as:

Cell b5 - http:
Cell c5 - empty
Cell d5 - www.valueappeal.com
Cell e5 - tax-preparer
Cell f5 - oakland-county
Cell g5 - farmington-mi [this is a variable]
Cell h5 - 345904 [this a variable]
Cell i5 - ernest-h-turken-pc-cpa [this is a variable]
Cell j5 - ernest-turken [this is a variable}

Rather than typing the address for each smfStrExtr data field, I tried to insert the cell address for the variables.

In this case:
http://www.valueappeal.com/tax-preparer/oakland-county/&g5/&h5/&i5/&j5

However, my idea returns an error. Any ideas?

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> The data isn't in tables, so you need to use the smfGetTagContent()
> function. Here's what I got:
>
> =smfStrExtr(smfGetTagContent("http://www.valueappeal.com/tax-preparer/oa\
> kland-county/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-sh\
> apiro","div",-1,">Email"),"mailto:","""")
> =smfStrExtr(smfGetTagContent("http://www.valueappeal.com/tax-preparer/oa\
> kland-county/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-sh\
> apiro","div",-1,">Email"),"http://","""")
> =smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
> y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro","div\
> ",-1,"Phone:")
> =smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
> y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro","h1"\
> ,1,"Phone:")
> =smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
> y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro","h2"\
> ,1,"Phone:")
> =smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
> y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro","h3"\
> ,1,"Phone:")
>
> ...returned:
>
> ashapiro@... www.hswf.net/ Phone: 248-851-2211 Abba
> Shapiro Harelik Shapiro Wolgin & Fine Pc 30445 Northwestern
> Hwy #Ste, Farmington, MI 48334
>
> On Mon, Dec 3, 2012 at 7:09 AM, Steven <stevenletzer@...
> <mailto:stevenletzer@...> > wrote:
> This website provides contact information, for example tax preparers in
> Farmington MI; the web address is:
> http://www.valueappeal.com/tax-preparers/city/oakland-county/farmington-\
> mi
> <http://www.valueappeal.com/tax-preparers/city/oakland-county/farmington\
> -mi>
>
> I am trying to bring in the contact info without having to copy and
> paste. For example at this address:
> http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/527\
> 492/harelik-shapiro-wolgin-fine-pc/abba-shapiro
> <http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/52\
> 7492/harelik-shapiro-wolgin-fine-pc/abba-shapiro> , this information is
> displayed:
> ****************************************************************
> Abba Shapiro
>
>
> Harelik Shapiro Wolgin & Fine Pc
>
> 30445 Northwestern Hwy #Ste, Farmington, MI 48334
>
> Email (a link returns "ashapiro@... <mailto:ashapiro@...>
> <ashapiro@... <mailto:ashapiro@...> >")
> Website (a link that returns "http://www.hswf.net/
> <http://www.hswf.net/> ")
>
> Phone: 248-851-2211 <tel:248-851-2211> (text)
>
> ****************************************************************
>
> I know that I will have to copy and past the web address with the
> internal contact data. But that is one task vs. several.
>
> I need to capture the table data and the email and website data.
>
> Any ideas?
>

Wed Dec 5, 2012 11:47 am (PST) . Posted by:

"Randy Harmelink" rharmelink

This:

http://www.valueappeal.com/tax-preparer/oakland-county/&g5/&h5/&i5/&j5

...would not resolve the cell references and place them in your URL. You
need something like, to concatenate each cell reference into the various
static string portions:

="http://www.valueappeal.com/tax-preparer/oakland-county/
"&G5&"/"&H5&"/"&I5&"/"&J5

On Wed, Dec 5, 2012 at 12:16 PM, Steven <stevenletzer@yahoo.com> wrote:

> There are 4 variables in the web address string. When I copy the web
> addess into Excel, the web address is copied in fields, that are determined
> by the "/". For example this address copied in Cell B5,
>
> http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/345904/ernest-h-turken-pc-cpa/ernest-turken--- is copied as:
>
> Cell b5 - http:
> Cell c5 - empty
> Cell d5 - www.valueappeal.com
> Cell e5 - tax-preparer
> Cell f5 - oakland-county
> Cell g5 - farmington-mi [this is a variable]
> Cell h5 - 345904 [this a variable]
> Cell i5 - ernest-h-turken-pc-cpa [this is a variable]
> Cell j5 - ernest-turken [this is a variable}
>
> Rather than typing the address for each smfStrExtr data field, I tried to
> insert the cell address for the variables.
>
> In this case:
> http://www.valueappeal.com/tax-preparer/oakland-county/&g5/&h5/&i5/&j5
>
> However, my idea returns an error. Any ideas?
>

Wed Dec 5, 2012 2:08 pm (PST) . Posted by:

"T" thomas777crown

All of the RCHGetElementNumber for barchart Technical Indicators aren't working.

Cheers

Wed Dec 5, 2012 2:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I just grabbed the file from the FILES area of the group, and it worked
fine for me. You'll have to describe what is happening to help me diagnose
what isn't working for you...

On Wed, Dec 5, 2012 at 3:08 PM, T <thomas777crown@yahoo.com> wrote:

> All of the RCHGetElementNumber for barchart Technical Indicators aren't
> working.
>

Wed Dec 5, 2012 2:49 pm (PST) . Posted by:

"T" thomas777crown

Hi,

I keep on getting undefined! Everything else on my spreadsheet is working like RCHGetYAhooQuotes but for some reason none of the RCHGetElementNumbers are working.

Cheers

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just grabbed the file from the FILES area of the group, and it worked
> fine for me. You'll have to describe what is happening to help me diagnose
> what isn't working for you...
>
> On Wed, Dec 5, 2012 at 3:08 PM, T <thomas777crown@...> wrote:
>
> > All of the RCHGetElementNumber for barchart Technical Indicators aren't
> > working.
> >
>

Wed Dec 5, 2012 3:08 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

From item 0.3 in the LINKS area of the group:

"Undefined" typically means you don't have the element definition files in
the same directory as the add-in -- the "smf-elements-n.txt" files. Most of
the element definitions are EXTERNAL to the add-in, for easier update.
That's why the installation instructions says to "extract all of the files
from the ZIP archive".

On Wed, Dec 5, 2012 at 3:49 PM, T <thomas777crown@yahoo.com> wrote:

>
> I keep on getting undefined! Everything else on my spreadsheet is working
> like RCHGetYAhooQuotes but for some reason none of the RCHGetElementNumbers
> are working.
>

Wed Dec 5, 2012 3:44 pm (PST) . Posted by:

"T" thomas777crown

Thank you,
It works perfectly now.

Cheers

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> From item 0.3 in the LINKS area of the group:
>
> "Undefined" typically means you don't have the element definition files in
> the same directory as the add-in -- the "smf-elements-n.txt" files. Most of
> the element definitions are EXTERNAL to the add-in, for easier update.
> That's why the installation instructions says to "extract all of the files
> from the ZIP archive".
>
> On Wed, Dec 5, 2012 at 3:49 PM, T <thomas777crown@...> wrote:
>
> >
> > I keep on getting undefined! Everything else on my spreadsheet is working
> > like RCHGetYAhooQuotes but for some reason none of the RCHGetElementNumbers
> > are working.
> >
>

Wed Dec 5, 2012 4:36 pm (PST) . Posted by:

"T" thomas777crown

I want to be able to pull a number of equity and futures data from barchart. It would be for up to 400 different equity or futures tickers.

Which option would be the best way to do that? An example would be for futures http://www.barchart.com/quotes/futures/SIH13
or http://www.barchart.com/quotes/stocks/AAPL

Any information for those two and it would be for a number of items like High, open, low, close, volume just information on those tables.

Cheers,
T

Wed Dec 5, 2012 5:23 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I would suggest using the smfUpdateDownloadTable process, so that you are
dealing with values where you control when they update versus formulas,
which would recalculate any time EXCEL deems it necessary.

See the LINKS area of the group for more info on that process.

Keep in mind that the add-in is limited to accessing 1000 web pages within
a given session.

On Wed, Dec 5, 2012 at 5:36 PM, T <thomas777crown@yahoo.com> wrote:

> I want to be able to pull a number of equity and futures data from
> barchart. It would be for up to 400 different equity or futures tickers.
>
> Which option would be the best way to do that? An example would be for
> futures http://www.barchart.com/quotes/futures/SIH13
> or http://www.barchart.com/quotes/stocks/AAPL
>
> Any information for those two and it would be for a number of items like
> High, open, low, close, volume just information on those tables.
>

Wed Dec 5, 2012 6:54 pm (PST) . Posted by:

"T" thomas777crown

Thanks,

I'm fairly new to this. I looked up the documentation. I was able to get retrieve some items but I can't seem to retrieve the high, open, low, close and volume with RCHGetTableCell for http://www.barchart.com/quotes/stocks/AAPL

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I would suggest using the smfUpdateDownloadTable process, so that you are
> dealing with values where you control when they update versus formulas,
> which would recalculate any time EXCEL deems it necessary.
>
> See the LINKS area of the group for more info on that process.
>
> Keep in mind that the add-in is limited to accessing 1000 web pages within
> a given session.
>
> On Wed, Dec 5, 2012 at 5:36 PM, T <thomas777crown@...> wrote:
>
> > I want to be able to pull a number of equity and futures data from
> > barchart. It would be for up to 400 different equity or futures tickers.
> >
> > Which option would be the best way to do that? An example would be for
> > futures http://www.barchart.com/quotes/futures/SIH13
> > or http://www.barchart.com/quotes/stocks/AAPL
> >
> > Any information for those two and it would be for a number of items like
> > High, open, low, close, volume just information on those tables.
> >
>

Wed Dec 5, 2012 8:57 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Close isn't in a table, but the others are. For example:

=0+smfGetTagContent("http://www.barchart.com/quotes/stocks/AAPL
","span",-1,"id=""dtaLast""")
=RCHGetTableCell("http://www.barchart.com/quotes/stocks/AAPL",1,">Stock
Price Quote",">High")

On Wed, Dec 5, 2012 at 7:54 PM, T <thomas777crown@yahoo.com> wrote:

>
> I'm fairly new to this. I looked up the documentation. I was able to get
> retrieve some items but I can't seem to retrieve the high, open, low, close
> and volume with RCHGetTableCell for
> http://www.barchart.com/quotes/stocks/AAPL
>

Wed Dec 5, 2012 10:38 pm (PST) . Posted by:

"T" thomas777crown

Thanks, just one more question how do I get it too look at a cell instead. Instead of just writing in the ticker I do I get it to look at a certain cell where the ticker will be.

=RCHGetTableCell("http://www.barchart.com/quotes/stocks/",1,">Stock
> Price Quote",">High")

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Close isn't in a table, but the others are. For example:
>
> =0+smfGetTagContent("http://www.barchart.com/quotes/stocks/AAPL
> ","span",-1,"id=""dtaLast""")
> =RCHGetTableCell("http://www.barchart.com/quotes/stocks/AAPL",1,">Stock
> Price Quote",">High")
>
> On Wed, Dec 5, 2012 at 7:54 PM, T <thomas777crown@...> wrote:
>
> >
> > I'm fairly new to this. I looked up the documentation. I was able to get
> > retrieve some items but I can't seem to retrieve the high, open, low, close
> > and volume with RCHGetTableCell for
> > http://www.barchart.com/quotes/stocks/AAPL
> >
>

Wed Dec 5, 2012 4:56 pm (PST) . Posted by:

"lawrence.leesh" lawrence.leesh

Is there an update to the SMF Addin to allow downloading of 848 Zacks rank? I don't think it is the symbol problem. They symbols that I could get for 848 are now not possible to download.

Another ticker that seems to have the same problem is 13888 analyst price target.

thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. When I try to access the web page for POOSF in FireFox, I get an
> error with the following message:
>
> *"Firefox has detected that the server is redirecting the request for this
> address in a way that will never complete."*
>
> Note the "never complete" part there -- that could be why the add-in is
> hanging. It's constantly being redirected in a way that the request can
> never get the web page.
>
> On Mon, Dec 3, 2012 at 8:59 PM, carmine288 <carmine.nicoletta@...>wrote:
>
> > After the latest element defininition update, Excel hangs trying to pull
> > the "848 - Zacks Rank" for ticker "POOSF" for me. Anyone else?
> >
>

Wed Dec 5, 2012 5:25 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

See recent messages on Zacks and a recent file upload for updates on Zacks
element definitions.

On Wed, Dec 5, 2012 at 5:56 PM, lawrence.leesh <lawrence.leesh@yahoo.com>wrote:

> Is there an update to the SMF Addin to allow downloading of 848 Zacks
> rank? I don't think it is the symbol problem. They symbols that I could get
> for 848 are now not possible to download.
>
> Another ticker that seems to have the same problem is 13888 analyst price
> target.
>
Diposting oleh EXCEL FEED LEARNING di 22.38

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)