12 New Messages
Digest #2390
Messages
Sat Nov 3, 2012 7:17 am (PDT) . Posted by:
"lexstar" lexstar
I haven't tried the immediate smfForceRecalculation yet. But, if I try enough times (many many times) at manual calculation (SHIFT+F9), sometimes it'll work, but then I can't save the file (due to some error msgs).
All links are resolved as far as I know.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Have you tried an immediate smfForceRecalculation? Same results, or does it
> then update?
>
> No unresolved links, right?
>
> On Fri, Nov 2, 2012 at 8:31 PM, lexstar <lexstar@...> wrote:
>
> > Didn't matter what time of the day it is. I've tried at various times,
> > and it still doesn't work.
> >
> > I just don't get it.
> >
>
All links are resolved as far as I know.
--- In smf_addin@yahoogrou
>
> Have you tried an immediate smfForceRecalculati
> then update?
>
> No unresolved links, right?
>
> On Fri, Nov 2, 2012 at 8:31 PM, lexstar <lexstar@...
>
> > Didn't matter what time of the day it is. I've tried at various times,
> > and it still doesn't work.
> >
> > I just don't get it.
> >
>
Sat Nov 3, 2012 7:50 am (PDT) . Posted by:
"Ron Spruell" hashky
As I understand it <Shift-F9> only recalculates the Active Worksheet. If you already have the needed data stored in Excel, it will NOT retrieve new data from the Internet.
If you have a Worksheet with a single ticker and you change the ticker <Shift-F9> will retrieve the new data from the Internet.
I can't double check that right now, because the market is closed.
SMFForceRecalculation retrieves new data for all open Workbooks.
I am sure if this is wrong, Randy will correct me.
Ron Spruell
>________________________________
> From: lexstar <lexstar@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Saturday, November 3, 2012 9:17 AM
>Subject: [smf_addin] Re: smfPricesBetween()
>
>
>
>I haven't tried the immediate smfForceRecalculation yet. But, if I try enough times (many many times) at manual calculation (SHIFT+F9), sometimes it'll work, but then I can't save the file (due to some error msgs).
>
>All links are resolved as far as I know.
>
>--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>>
>> Have you tried an immediate smfForceRecalculation? Same results, or does it
>> then update?
>>
>> No unresolved links, right?
>>
>> On Fri, Nov 2, 2012 at 8:31 PM, lexstar <lexstar@...> wrote:
>>
>> > Didn't matter what time of the day it is. I've tried at various times,
>> > and it still doesn't work.
>> >
>> > I just don't get it.
>> >
>>
>
>
>
>
>
If you have a Worksheet with a single ticker and you change the ticker <Shift-F9> will retrieve the new data from the Internet.
I can't double check that right now, because the market is closed.
SMFForceRecalculati
I am sure if this is wrong, Randy will correct me.
Ron Spruell
>___________
> From: lexstar <lexstar@yahoo.
>To: smf_addin@yahoogrou
>Sent: Saturday, November 3, 2012 9:17 AM
>Subject: [smf_addin] Re: smfPricesBetween(
>
>
>
>I haven't tried the immediate smfForceRecalculati
>
>All links are resolved as far as I know.
>
>--- In smf_addin@yahoogrou
>>
>> Have you tried an immediate smfForceRecalculati
>> then update?
>>
>> No unresolved links, right?
>>
>> On Fri, Nov 2, 2012 at 8:31 PM, lexstar <lexstar@...
>>
>> > Didn't matter what time of the day it is. I've tried at various times,
>> > and it still doesn't work.
>> >
>> > I just don't get it.
>> >
>>
>
>
>
>
>
Sat Nov 3, 2012 1:37 pm (PDT) . Posted by:
"mrc" stevenorris_mss
I searched posts first byt didn't see anything on this, apologies if it has alraeday been answered.
windows RT seems to be a version of windows 8, offered on the lightest laptops/tablets
Thanks Randy for all your hard work, it saves me a lot of work.
windows RT seems to be a version of windows 8, offered on the lightest laptops/tablets
Thanks Randy for all your hard work, it saves me a lot of work.
Sat Nov 3, 2012 2:50 pm (PDT) . Posted by:
"Don Goyette" disabledfella
Thank you for your quick reply, Randy! That works great and I learned how one more function works.
-Don
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, November 01, 2012 12:45 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] smfGetTagContent Question
On Wed, Oct 31, 2012 at 9:41 PM, disabledfella <don@donandcarla.com > wrote:
Right now, I'm working through the RCHGetHTMLTable-Template-MSN-Annual-Financials.xls example. All of the formulas were calling the function at "C:\<add-in...>" instead of "C:\Program Files\<add-in...>", which is where your instructions told us to place it.
The location error is an unfortunate reality -- see the "Location error" item in the LINKS area of the group.
Once I got that figured out and changed, I wanted to add a look-up function to get the name of the company from the webpage to verify that the right page was being read. The size of the page is over 300K and the company name is located about half-way down, in the following div ...
<div class="cnex">
<h1 class="cn" title="CYS Investments Inc">
<a href="http://investing.money.msn.com/investments/company-report/?symbol=cys ">CYS Investments Inc</a>
</h1>
<span class="ex">(NYSE: CYS)</span>
</div>
The code I'm currently using is ...
=IF(Ticker="None"," ",smfGetTagContent("http://investing.money.msn.com/investments/stock-income-statement/?symbol= "&Ticker,"h1",0,"/company-report/?symbol="))
... but it's returning "CYS Investments Inc</a>", which includes the closing href anchor tag.
Is there a more efficient/correct way to get the company name from the HTML shown above, so that the </a> tag is not part of the returned string? I've tried dozens of possible combinations, but most of them display "ERROR" in the cell.
I would have just used:
=smfGetTagContent("http://investing.money.msn.com/investments/stock-income-statement/?symbol=CYS ","a",-1,"/company-report/?symbol=")
In general, a "0" value in the smfGetTagContent() formula has no meaning. It really says "take everything after the end of the current HTML tag to the end of requested tag".
Is it possible to extract the name from the following HTML? ...
"<h1 class="cn" title="CYS Investments Inc">"
If you something returning that string in cell C17, you'd extract it with:
=smfStrExtr(C17,"title=""","""")
-Don
From: smf_addin@yahoogrou
Sent: Thursday, November 01, 2012 12:45 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] smfGetTagContent Question
On Wed, Oct 31, 2012 at 9:41 PM, disabledfella <don@donandcarla.
Right now, I'm working through the RCHGetHTMLTable-
The location error is an unfortunate reality -- see the "Location error" item in the LINKS area of the group.
Once I got that figured out and changed, I wanted to add a look-up function to get the name of the company from the webpage to verify that the right page was being read. The size of the page is over 300K and the company name is located about half-way down, in the following div ...
<div class="cnex"
<h1 class="cn" title="CYS Investments Inc">
<a href="http://investing.
</h1>
<span class="ex">(
</div>
The code I'm currently using is ...
=IF(Ticker="
... but it's returning "CYS Investments Inc</a>", which includes the closing href anchor tag.
Is there a more efficient/correct way to get the company name from the HTML shown above, so that the </a> tag is not part of the returned string? I've tried dozens of possible combinations, but most of them display "ERROR" in the cell.
I would have just used:
=smfGetTagContent(
In general, a "0" value in the smfGetTagContent(
Is it possible to extract the name from the following HTML? ...
"<h1 class="cn" title="CYS Investments Inc">"
If you something returning that string in cell C17, you'd extract it with:
=smfStrExtr(
Sat Nov 3, 2012 5:31 pm (PDT) . Posted by:
"corbanbates" corbanbates
Hey Randy,
First off, thank you so much for all that you do. I messaged you a few years ago asking about this and I'm just wondering if anything has changed.
I manually type into my spreadsheet over 500 banks' information from the FDIC website. Specifically their Net Loans & Leases, Loan Loss Allowance, Total Deposits, and Noncurrent loans and leases. This obviously takes FOREVER.
I'm just hoping there has been a new development where I could just automatically pull this data from the FDIC website. Or does anyone know any other place to pull this data from that could update automatically? Thanks!
Corban
First off, thank you so much for all that you do. I messaged you a few years ago asking about this and I'm just wondering if anything has changed.
I manually type into my spreadsheet over 500 banks' information from the FDIC website. Specifically their Net Loans & Leases, Loan Loss Allowance, Total Deposits, and Noncurrent loans and leases. This obviously takes FOREVER.
I'm just hoping there has been a new development where I could just automatically pull this data from the FDIC website. Or does anyone know any other place to pull this data from that could update automatically? Thanks!
Corban
Sat Nov 3, 2012 6:40 pm (PDT) . Posted by:
"rex" bios007a
corbanbates <corbanbates@yahoo.com > [2012-11-03 17:30]:
>I'm just hoping there has been a new development where I could just automatically pull this data from the FDIC website. Or does anyone know any other place to pull this data from that could update automatically? Thanks!
A URL would be helpful to assess the feasibility of screen-scraping the
site.
>I'm just hoping there has been a new development where I could just automatically pull this data from the FDIC website. Or does anyone know any other place to pull this data from that could update automatically? Thanks!
A URL would be helpful to assess the feasibility of screen-scraping the
site.
Sat Nov 3, 2012 6:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sample URL?
On Sat, Nov 3, 2012 at 5:31 PM, corbanbates <corbanbates@yahoo.com > wrote:
>
> First off, thank you so much for all that you do. I messaged you a few
> years ago asking about this and I'm just wondering if anything has changed.
>
> I manually type into my spreadsheet over 500 banks' information from the
> FDIC website. Specifically their Net Loans & Leases, Loan Loss Allowance,
> Total Deposits, and Noncurrent loans and leases. This obviously takes
> FOREVER.
>
> I'm just hoping there has been a new development where I could just
> automatically pull this data from the FDIC website. Or does anyone know any
> other place to pull this data from that could update automatically? Thanks!
>
On Sat, Nov 3, 2012 at 5:31 PM, corbanbates <corbanbates@
>
> First off, thank you so much for all that you do. I messaged you a few
> years ago asking about this and I'm just wondering if anything has changed.
>
> I manually type into my spreadsheet over 500 banks' information from the
> FDIC website. Specifically their Net Loans & Leases, Loan Loss Allowance,
> Total Deposits, and Noncurrent loans and leases. This obviously takes
> FOREVER.
>
> I'm just hoping there has been a new development where I could just
> automatically pull this data from the FDIC website. Or does anyone know any
> other place to pull this data from that could update automatically? Thanks!
>
Sat Nov 3, 2012 7:14 pm (PDT) . Posted by:
"calhandon" calhandon
Randy is asking for the address of the web page you use. For example: "http://www.somename.com/ "
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Sample URL?
>
> On Sat, Nov 3, 2012 at 5:31 PM, corbanbates <corbanbates@...> wrote:
>
> >
> > First off, thank you so much for all that you do. I messaged you a few
> > years ago asking about this and I'm just wondering if anything has changed.
> >
> > I manually type into my spreadsheet over 500 banks' information from the
> > FDIC website. Specifically their Net Loans & Leases, Loan Loss Allowance,
> > Total Deposits, and Noncurrent loans and leases. This obviously takes
> > FOREVER.
> >
> > I'm just hoping there has been a new development where I could just
> > automatically pull this data from the FDIC website. Or does anyone know any
> > other place to pull this data from that could update automatically? Thanks!
> >
>
--- In smf_addin@yahoogrou
>
> Sample URL?
>
> On Sat, Nov 3, 2012 at 5:31 PM, corbanbates <corbanbates@
>
> >
> > First off, thank you so much for all that you do. I messaged you a few
> > years ago asking about this and I'm just wondering if anything has changed.
> >
> > I manually type into my spreadsheet over 500 banks' information from the
> > FDIC website. Specifically their Net Loans & Leases, Loan Loss Allowance,
> > Total Deposits, and Noncurrent loans and leases. This obviously takes
> > FOREVER.
> >
> > I'm just hoping there has been a new development where I could just
> > automatically pull this data from the FDIC website. Or does anyone know any
> > other place to pull this data from that could update automatically? Thanks!
> >
>
Sat Nov 3, 2012 5:42 pm (PDT) . Posted by:
"Don Goyette" disabledfella
Does anyone know if there are Zip files of all the examples and templates,
either by function or a Zip of all files?
I looked in the Files section and could not find any, except for
Documentation, Zipped in 2011.
Thank you,
-Don
either by function or a Zip of all files?
I looked in the Files section and could not find any, except for
Documentation, Zipped in 2011.
Thank you,
-Don
Sat Nov 3, 2012 6:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I wouldn't create them -- it's too easy for such things to be out-of-date.
On Sat, Nov 3, 2012 at 5:40 PM, Don Goyette <don@donandcarla.com > wrote:
>
> Does anyone know if there are Zip files of all the examples and templates,
> either by function or a Zip of all files?****
>
> ** **
>
> I looked in the Files section and could not find any, except for
> Documentation, Zipped in 2011.****
>
>
>
On Sat, Nov 3, 2012 at 5:40 PM, Don Goyette <don@donandcarla.
>
> Does anyone know if there are Zip files of all the examples and templates,
> either by function or a Zip of all files?****
>
> ** **
>
> I looked in the Files section and could not find any, except for
> Documentation, Zipped in 2011.****
>
>
>
Sat Nov 3, 2012 7:13 pm (PDT) . Posted by:
"bozo" calhandon
Okay, thanks Randy.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Saturday, November 03, 2012 7:50 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Zip file for Examples & Templates?
I wouldn't create them -- it's too easy for such things to be out-of-date.
On Sat, Nov 3, 2012 at 5:40 PM, Don Goyette <don@donandcarla.com > wrote:
Does anyone know if there are Zip files of all the examples and templates, either by function or a Zip of all files?
I looked in the Files section and could not find any, except for Documentation, Zipped in 2011.
From: smf_addin@yahoogrou
Sent: Saturday, November 03, 2012 7:50 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Zip file for Examples & Templates?
I wouldn't create them -- it's too easy for such things to be out-of-date.
On Sat, Nov 3, 2012 at 5:40 PM, Don Goyette <don@donandcarla.
Does anyone know if there are Zip files of all the examples and templates, either by function or a Zip of all files?
I looked in the Files section and could not find any, except for Documentation, Zipped in 2011.
Sat Nov 3, 2012 8:06 pm (PDT) . Posted by:
"drsues02" drsues02
Here is the website in question:
http://www.cpordevises.com/gold/quotations/rates?day=31&month=10&year=2012
I'd like to pull information for several different items in the table (for example: Lingot, Lingotin oR ® 10g, Krugerrand Sud Afrique, etc).
I'd like to enter in a long series of dates in Excel in Column A, with the different items in columns B, C, D, etc - and have it pull in the info automatically.
Basically, I'm trying to re-create the charts on the Graphics page, but with the actual data:
http://www.cpordevises.com/gold/expertise-value/ingots-coins-quotation/lingot
http://www.cpordevi
I'd like to pull information for several different items in the table (for example: Lingot, Lingotin oR ® 10g, Krugerrand Sud Afrique, etc).
I'd like to enter in a long series of dates in Excel in Column A, with the different items in columns B, C, D, etc - and have it pull in the info automatically.
Basically, I'm trying to re-create the charts on the Graphics page, but with the actual data:
http://www.cpordevi
Tidak ada komentar:
Posting Komentar