Hi Randy,
I understand this is not a RCH code question, but could you help or show me a
way to learn how to create this code:

Say, I have a bunch of data in an Access 2010 file (each record uses the ticker
as the primary key).  And I would have a  calculated target price in an Access
file for IBM (IBM is in column titled Ticker, and its target price is in column
titled TargetPX).

From a Excel cell, I create a code similar to RCHGetElementNumber to get that
target price into a cell from that Access file?

Thanks again for your helps!

Tim

Sorry, I have no solution. I was able to do the first part, meaning import the
ReportID and ControlID. However, that seems irrelevant since I can't get the
second URL to work and when I tested, I can't even open the website in Internet
Explorer, only in Firefox. So I have no way of getting the data, using the
add-in or my own code.

If I come up with a solution, I will post it here but it does not look like I
will.

Regards,
Tom

--- In smf_addin@yahoogroups.com, Imran Naqvi <naqviimran@...> wrote:
>
> Tom,
>
> You said u have been able to accomplish it with you own code. Can you please
> share it with me?
>
> Thanks.
>
> On Tue, Feb 1, 2011 at 10:37 AM, Randy Harmelink <rharmelink@...>wrote:
>
> >
> >
> > I"m not working on it, because the add-in can't access the data. Nor do I
> > know enough about how ASP pages work.
> >
> >
> > On Mon, Jan 31, 2011 at 9:40 PM, Imran Naqvi <naqviimran@...> wrote:
> >
> >>
> >> So what is the solution to this problem? Won't I able be able to extract
> >> the figures from the power exchange website?
> >>
> >> Please do something people. It is very important for my project. I would
> >> be very thankful to you guys.
> >>
> >>
> >
> >
>
>
>
> --
> Ali Imran Naqvi
> 9327016964
>
> "Smooth sea never makes a skillful mariner"
>

As always, thank you, Randy!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, but it's been well over a decade since I've used Access...
>
> On Tue, Feb 1, 2011 at 6:59 AM, timdbui <timdbui@...> wrote:
>
> > Hi Randy,
> > I understand this is not a RCH code question, but could you help or show me
> > a way to learn how to create this code:
> >
> > Say, I have a bunch of data in an Access 2010 file (each record uses the
> > ticker as the primary key).  And I would have a  calculated target price in
> > an Access file for IBM (IBM is in column titled Ticker, and its target price
> > is in column titled TargetPX).
> >
> > From a Excel cell, I create a code similar to RCHGetElementNumber to get
> > that target price into a cell from that Access file?
> >
>

Hi folks,

I just recently have updated my Financial Statement Spreadsheet for
2011.  Feel free to download it from
http://members.cox.net/gfullmer/FS2011.  It costs $15 on Lulu but for my
friends and relatives $0. I have used it for the last 10 years, with
mods, and it has been very helpful in getting me out of the rat race.
However, please don't distribute it.

When you first load it with Excel (it has been tested with 2003 and 2007
Excel) it will ask for the FS2010 file from last year.  If you didn't
use last year's ignore the message, but if you did, make sure it is in
the same directory.

Purpose: The purpose of this Financial Spreadsheet is to provide an
individual the means to budget and track one's financial condition on
one page. Unfortunately some of the better personal financial packages
(Money, Quicken) do not allow k...ind of Financial Statement that
provides a snapshot of the cashflow and tracking of it from month to
month, and way to track financial indicators beside net worth. This
provides a Rich Dad (www.richdad.com) compatible view. However, most of
the financial software packages don't define assets and liabilities like
Kiyosaki does. That is assets put money in your pocket and liabilities
take money out of your pocket. This spreadsheet uses those definitions.

First go to the instructions page.  Any feedback or enhancement
suggestions would be appreciate.

May you have a happy and most prosperou$ New Year,
Glen
PS if you find it useful and worth much more that the $15 please feel
free to pay for it at:

http://www.lulu.com/product/file-download/financial-statement-spreadsheet/147304\
35

--
Glen Fullmer, gfullmer@...,  http://members.cox.net/gfullmer
---
http://personalcashflow.blogspot.com - cash flow blog
http://www.alreadytoharvest.com - historical novel
http://www.youtube.com/gfullmer - fractal Movies
"True love doesn't want anything" - Eckhardt Tolle
"Charity doesn't think about itself" - St. Paul
"all things whatsoever ye would that men
   should do to you, do ye even so to them" - Jesus
---

Try symbol PLDDX, pimco low duration, the spreadsheet reports:

52 wk low:  10.27
52 wk High: 11.45

morningstar reports:

52 wk low:   10.27
52 wk High:  10.77

* the 52 wk high #'s are different?



--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> As mentioned in the documentation, you can find out the source or URL of an
> element with:
>
> =RCHGetElementNumber("Source",33)
> =RCHGetElementNumber("Web Page",33)
>
> I'm surprised you get any data at all for mutual funds for that element,
> since it is from a STOCK page on MSN. As far as I know, their mutual fund
> data is provided by Morningstar. I think most other web sources will also
> ultimately get their data from MorningStar. What kind of wrong numbers are
> you seeing?
>
> I tried a few mutual funds and they seemed OK. It does appear the hi/low are
> not adjusted for dividends. You could always extract the 52-week hi and low
> from Yahoo using the smfPricesBetween() function, which would adjust prices
> for dividends.
>
> On Fri, Jan 14, 2011 at 1:21 PM, Rene Reyna <rr76012@...> wrote:
>
> >
> > I use Rchgetelementnumber(a1,33) and (a1,34) to get mutual fund 52 week
> > highs & lows. However I have noticed the numbers are wrong, frequently. Do
> > you know a more reliable way to get mutual fund 52 week highs & lows?
> >
> > Also what is the web site this rchgetelementnumber (a1,33) getting these
> > numbers? I want to avoid that website for future mutual fund 52 week
> > highs/lows.
> >
>

Sorry.  That is http://members.cox.net/gfullmer/FS2011.xls

On Tue, 2011-02-01 at 11:23 -0700, Glen Fullmer wrote:

> 2011. Feel free to download it from
> http://members.cox.net/gfullmer/FS2011.

--
Glen Fullmer, gfullmer@...,  http://members.cox.net/gfullmer
---
http://personalcashflow.blogspot.com - cash flow blog
http://www.alreadytoharvest.com - historical novel
http://www.youtube.com/gfullmer - fractal Movies
"True love doesn't want anything" - Eckhardt Tolle
"Charity doesn't think about itself" - St. Paul
"all things whatsoever ye would that men
   should do to you, do ye even so to them" - Jesus
---

I am trying to bring in Morningstar Cloed End Fund Data,
for example at: http://cef.morningstar.com/quote?t=IGA,

I am trying to bring in the Morningstar Catagory, which in this case is "World
Stock" which below a heading "Morningstar Category IGA"

These are several other data points below the headings on the page.
Any ideas?

Thanks! I've set up a sheet using smfGetCSVFile.  It works great!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you search the message archives of the group for "unicorn", you'll find a
> number of messages on the topic.
>
> On Sat, Jan 29, 2011 at 7:38 AM, griffinms <griffinms@...> wrote:
>
> > Specifically, I am trying to automate downloading NASDAQ 52 week highs and
> > lows.  They are already in TXT and CSV files.
> >
>

Awesome.  Thanks for the help.


--- In smf_addin@yahoogroups.com, "bizmark_ee" <markpadden@...> wrote:
>
> After the market closes (4pm ET), I am able to pull in after-hours prices by
using:
>
> smfGetTagContent("http://finance.yahoo.com/q?s=GOOG","span",1,"After
Hours:","")
>
>
> It works fine.  But when I try to do the same for pre-market prices (before
9:30am ET), and use:
>
> smfGetTagContent("http://finance.yahoo.com/q?s=GOOG","span",1,"Pre-Market
Real-Time:","")
>
> it always returns an error, even when the web page show a valid pre-market
price.  I replaced "After Hours:" with "Pre-Market Real-Time:" because that is
what is shown on the web page pre-market.  [You cannot verify this right now
(Fri afternoon), but rather have to wait until 8am on Monday].
>
> In any case, if someone can point me to what I am doing wrong, it would be
greatly appreciated.
>

Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I don't actually see the category listed on the page you cited, although it
> is within the content of the web page (probably hidden when first visiting
> the page?). Try:
>
> =RCHGetTableCell("http://cef.morningstar.com/quote?t=IGA",1,">MorningStar
> Category",,,,1)
>
> On Tue, Feb 1, 2011 at 1:13 PM, Steven <stevenletzer@...> wrote:
>
> > I am trying to bring in Morningstar Cloed End Fund Data,
> > for example at: http://cef.morningstar.com/quote?t=IGA,
> >
> > I am trying to bring in the Morningstar Catagory, which in this case is
> > "World Stock" which below a heading "Morningstar Category IGA"
> >
> > These are several other data points below the headings on the page.
> > Any ideas?
> >
>

Hi Randy/Tom,

The file developed by Tom has been working smoothly, but a while ago
it shows #VALUE! error.

The website of the exchange is working fine.

I have attached the file. Please help.

--
Ali Imran Naqvi
9327016964

"Smooth sea never makes a skillful mariner"

Maybe you guys can help me get started. I downloaded the toteboard.net company
comparison however it is not updating anything etc. it just shows #NAME?... any
idea how to get this working?! So confused.

Thanks in advance.

It opens fine on my computer. If you are using Excel 2010, restart the workbook
and when it opens, click to Enable Editing if prompting.
Since you are using Now() to refresh the URL, you should press F9 to update it.
Pressing "Refresh URL" will also work (if macros and editing is enabled) since
when the macro runs it recalculates the workbook at the end, which is the same
as pressing F9. However, if editing is NOT enabled, pressing "Refresh URL" will
most likely throw a runtime error since it won't find the named range that the
macro is changing the data in.


--- In smf_addin@yahoogroups.com, Imran Naqvi <naqviimran@...> wrote:
>
> Hi Randy/Tom,
>
> The file developed by Tom has been working smoothly, but a while ago
> it shows #VALUE! error.
>
> The website of the exchange is working fine.
>
> I have attached the file. Please help.
>
> --
> Ali Imran Naqvi
> 9327016964
>
> "Smooth sea never makes a skillful mariner"
>

While I make no promise to keep the workbook "working", one thing to keep in
mind when asking for help is that I am based in the US. Your first question
today was asked at 1 am my time and the second (repeated) one at 5 am. It is
unlikely that I will be available to respond to any questions between 11 pm and
8 am EST.

--- In smf_addin@yahoogroups.com, Imran Naqvi <naqviimran@...> wrote:
>
> Isn't anyone there to help?
>
> On Wed, Feb 2, 2011 at 11:50 AM, Imran Naqvi <naqviimran@...> wrote:
>
> >
> >  [Attachment(s) <#12de508691a735cd_TopText> from Imran Naqvi included
> > below]
> >
> > Hi Randy/Tom,
> >
> > The file developed by Tom has been working smoothly, but a while ago
> > it shows #VALUE! error.
> >
> > The website of the exchange is working fine.
> >
> > I have attached the file. Please help.
> >
> > --
> > Ali Imran Naqvi
> > 9327016964
> >
> > "Smooth sea never makes a skillful mariner"
> >
> >
>
>
>
> --
> Ali Imran Naqvi
> 9327016964
>
> "Smooth sea never makes a skillful mariner"
>