4 New Messages
Digest #2506
Messages
Tue Feb 12, 2013 7:21 am (PST) . Posted by:
"freddie_carroll" freddie_carroll
does the RCH code 1285 still work? I get N/A for every stock symbol I tried. I've entered
=RCHGetElementNumber(A3,1285)
where A3 contains the stock symbol
in a spreadsheet with other SMF Add-In functions that work.
thanks,
Freddie
=RCHGetElementNumbe
where A3 contains the stock symbol
in a spreadsheet with other SMF Add-In functions that work.
thanks,
Freddie
Tue Feb 12, 2013 7:33 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Yahoo doesn't show the date on the sourced web page unless earnings are in
the near future. For example:
http://finance.yahoo.com/q/ae?s=AVA
On Tue, Feb 12, 2013 at 6:35 AM, freddie_carroll
freddie@the-carrolls.org >wrote:
> does the RCH code 1285 still work? I get N/A for every stock symbol I
> tried. I've entered
>
> =RCHGetElementNumber(A3,1285)
>
> where A3 contains the stock symbol
>
> in a spreadsheet with other SMF Add-In functions that work.
>
the near future. For example:
http://finance.
On Tue, Feb 12, 2013 at 6:35 AM, freddie_carroll
freddie@the-
> does the RCH code 1285 still work? I get N/A for every stock symbol I
> tried. I've entered
>
> =RCHGetElementNumbe
>
> where A3 contains the stock symbol
>
> in a spreadsheet with other SMF Add-In functions that work.
>
Tue Feb 12, 2013 7:22 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Because Yahoo is no longer licensed to carry Dow Jones index quotes on
their CSV files.
You could probably use the RCHGetTableCell() function to grab it from other
sources that display the quotes on a web page.
On Tue, Feb 12, 2013 at 5:39 AM, rjemery7 rjemery@gmail.com > wrote:
>
> Why is it certain RCHYetYahooHistory() calls fail? For example,
>
> =RCHGetYahooHistory("^DJI";,2012,1,31,2012,1,31,,"c",0) and
> =RCHGetYahooHistory("^DJI";,2013,1,31,2013,1,31,,"c",0)
>
> both return nothing.
>
> What other resources (finance.google.com?) exist for extracting the same
> information? What would be the command to use?
>
their CSV files.
You could probably use the RCHGetTableCell(
sources that display the quotes on a web page.
On Tue, Feb 12, 2013 at 5:39 AM, rjemery7 rjemery@gmail.
>
> Why is it certain RCHYetYahooHistory(
>
> =RCHGetYahooHistory
> =RCHGetYahooHistory
>
> both return nothing.
>
> What other resources (finance.google.
> information? What would be the command to use?
>
Tue Feb 12, 2013 7:44 am (PST) . Posted by:
"Clay" ultralonox
Hello Matthew. After 3 years of manually entering data into Excel 2011 on my desktop Imac, I went out and purchased VMware Fusion from the VMWare website, Windows 7 from the local market, and Excel from the Microsoft website. The smf addin and RCH formulas work perfectly and it cuts my work time for evaluating ~ 100 stocks to done-in-an-hour. Easily worth the expense.
Thankful for Randy's work and documentation,
Clay
Thankful for Randy's work and documentation,
Clay
Tidak ada komentar:
Posting Komentar