Messages In This Digest (15 Messages)
- 1a.
- Re: Trading Economics From: mconsidine_1999
- 1b.
- Re: Trading Economics From: famwencong@gmail.com
- 2a.
- Re: Help for newbie !! From: Ioannis K
- 2b.
- Re: Help for newbie !! From: Randy Harmelink
- 3a.
- Historical and Real Time Pricing From: thomas91112
- 3b.
- Re: Historical and Real Time Pricing From: Randy Harmelink
- 3c.
- Re: Historical and Real Time Pricing From: Michael Thomas
- 3d.
- Re: Historical and Real Time Pricing From: Randy Harmelink
- 3e.
- Re: Historical and Real Time Pricing From: Michael Thomas
- 3f.
- Re: Historical and Real Time Pricing From: Randy Harmelink
- 4a.
- Hi Randy, excellent work! Genious! I however would like to ask some From: famwencong@gmail.com
- 4b.
- Re: Hi Randy, excellent work! Genious! I however would like to ask s From: Randy Harmelink
- 4c.
- Re: Hi Randy, excellent work! Genious! I however would like to ask s From: famwencong@gmail.com
- 5a.
- Smartmoney data From: CheeseMan
- 5b.
- Re: Smartmoney data From: Randy Harmelink
Messages
- 1a.
-
Re: Trading Economics
Posted by: "mconsidine_1999" matt@considine.net mconsidine_1999
Sat Dec 10, 2011 7:38 am (PST)
That chart appears to live at
http://www.tradingeconomics. com/charts/ china-imports. png
HTH,
Matt
--- In smf_addin@yahoogroups.com , "newengwongpeggy" <tong82@...> wrote:
>
> Hi Randy,
>
> Possible to download the data from the charts?
>
> http://www.tradingeconomics. com/china/ imports
>
> thx
>
- 1b.
-
Re: Trading Economics
Posted by: "famwencong@gmail.com" famwencong@gmail.com kennethfam
Sat Dec 10, 2011 5:34 pm (PST)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Nope. Not with the add-in.
>
> On Fri, Dec 9, 2011 at 7:48 AM, newengwongpeggy <tong82@...> wrote:
>
> >
> > Possible to download the data from the charts?
> >
> > http://www.tradingeconomics. com/china/ imports
> >
>
get FRED
- 2a.
-
Re: Help for newbie !!
Posted by: "Ioannis K" john_koufos@yahoo.com sohalbiest
Sat Dec 10, 2011 7:54 am (PST)
So it would just be:
=RCHGetElementNumber(Ticker; 5316)
...provided you have a cell named "Ticker" in the workbook.
Ok so far so good ...But it returns error or returns 0 (the symbol i hve put in the function to return when error ) Where can I pull actual prices from ?
How can I pull prices fron the web page ?
Thanks For the patiens !!!
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, December 9, 2011 9:47 AM
Subject: Re: [smf_addin] Help for newbie !!
On Fri, Dec 9, 2011 at 12:34 AM, sohalbiest <john_koufos@yahoo.com > wrote:
>I am interested in downloading specific data from yahoo.finance. for example quarterly eps .
>
>What is the exact cintax for doing that using rch.get.element.number ?
>
>is it something like ...
>
>='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions .xla'!RCHGetElem entNumber( Ticker; 5316)
>
See the documentation for the function in the "Documentation" folder of the files area. You DON'T want the file path on the front of the function -- check out the "Location Error" item in the "Links" area of the group, where there are tips and FAQs related to the add-in. If you have a file path in front of the function, it means EXCEL was not able to resolve the link, so you need to do it manually.
So it would just be:
=RCHGetElementNumber(Ticker; 5316)
...provided you have a cell named "Ticker" in the workbook.
Do I have to do anything else or I just drop that to the excel cell ?
>
For the most part, the add-in is user-defined functions. Some need to be array-entered, if they can return a range of data -- how to do that is described in the documentation of those functions.
Can that be updated by using web data refresh button ?
>
No. They are functions, not web queries. In general, the best way to update the add-in functions is to use the smfForceRecalculation macro -- info on it can be found in the "Links" area of the group.
- 2b.
-
Re: Help for newbie !!
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 10, 2011 8:04 am (PST)
Take a look at the AdvFN entry in the "Links" area of the group. It may
solve your "Error" returned value.
To get stock quotes, use the RCHGetYahooQuotes() function.
On Sat, Dec 10, 2011 at 8:54 AM, Ioannis K <john_koufos@yahoo.com > wrote:
>
> So it would just be:
>
> =RCHGetElementNumber(Ticker; 5316)
>
> ...provided you have a cell named "Ticker" in the workbook.
>
> Ok so far so good ...But it returns error or returns 0 (the symbol i hve
> put in the function to return when error ) Where can I pull actual prices
> from ?
>
> How can I pull prices fron the web page ?
>
>
- 3a.
-
Historical and Real Time Pricing
Posted by: "thomas91112" thomas91112@yahoo.com thomas91112
Sat Dec 10, 2011 11:14 am (PST)
Have a column of (i) historical month end dates and (ii) todays date at the bottom. This way I can see price trends historically and updated through todays most recent activity. Next to the date column will be displayed for each date the High, Low, Close and for todays value it will be the most recent quote. Thought about trying to combine GetYahooHistory with GetYahooQuote but am not sure given the array nature of YahooHistory if this will work. What are your thoughts?
- 3b.
-
Re: Historical and Real Time Pricing
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 10, 2011 11:21 am (PST)
Why not just use the RCHGetYahooHistory() function using a monthly time
frame?
On Sat, Dec 10, 2011 at 12:13 PM, thomas91112 <thomas91112@yahoo.com > wrote:
> Have a column of (i) historical month end dates and (ii) todays date at
> the bottom. This way I can see price trends historically and updated
> through todays most recent activity. Next to the date column will be
> displayed for each date the High, Low, Close and for todays value it will
> be the most recent quote. Thought about trying to combine GetYahooHistory
> with GetYahooQuote but am not sure given the array nature of YahooHistory
> if this will work. What are your thoughts?
>
- 3c.
-
Re: Historical and Real Time Pricing
Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112
Sat Dec 10, 2011 11:26 am (PST)
I can get month end values that way but how about for todays real time quote?YahooHistory will display values as of the last trading day but not todays real time values which is why I was trying to work in YahooQuote.
--- On Sat, 12/10/11, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Historical and Real Time Pricing
To: smf_addin@yahoogroups.com
Date: Saturday, December 10, 2011, 11:21 AM
Why not just use the RCHGetYahooHistory() function using a monthly time frame?
On Sat, Dec 10, 2011 at 12:13 PM, thomas91112 <thomas91112@yahoo.com > wrote:
Have a column of (i) historical month end dates and (ii) todays date at the bottom. This way I can see price trends historically and updated through todays most recent activity. Next to the date column will be displayed for each date the High, Low, Close and for todays value it will be the most recent quote. Thought about trying to combine GetYahooHistory with GetYahooQuote but am not sure given the array nature of YahooHistory if this will work. What are your thoughts?
- 3d.
-
Re: Historical and Real Time Pricing
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 10, 2011 12:32 pm (PST)
As long as you're signed up for the real-time quotes on Yahoo, and logged
in with IE, RCHGetYahooQuotes() should get you the real-time quote.
On Sat, Dec 10, 2011 at 12:26 PM, Michael Thomas <thomas91112@yahoo.com >wrote:
>
> I can get month end values that way but how about for todays real time
> quote?YahooHistory will display values as of the last trading day but not
> todays real time values which is why I was trying to work in YahooQuote.
>
- 3e.
-
Re: Historical and Real Time Pricing
Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112
Sat Dec 10, 2011 1:45 pm (PST)
Right, but if I have a column array of YahooHistory how can I insert YahooQuote into the array and have it apply only when a date other than month end appears? For example, thinking of =IF(TODAY()>RCHGETYAHOOHISTO RY(Ticker, ,Start Mo, Start Day,End Yr, End Mo, End Day,,"D"),RCHGETYAH OOQUOTES( Ticker,"ll" ,,NOW()), RCHGETYAHOOHISTO RY(Ticker, Start Yr, Start Mo, Start Day,End Yr, End Mo, End Day,,"C"))
Since YahooHistory only posts as of the most recent trading day end, this test says if the current date is later than the most recent YahooHistory trading day, then retrieve the YahooQuotes value otherwise print the YahooHistory value.
One last cosmetic item, when I input =RCHGetYahooQuotes("GLD" ,"ll",,NOW( )), I get back Dec 9 - <b>166.40</b> . How can I just get the value and nothing else?
Thanks
--- On Sat, 12/10/11, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink
<rharmelink@gmail.com >
Subject: Re: [smf_addin] Historical and Real Time Pricing
To: smf_addin@yahoogroups.com
Date: Saturday, December 10, 2011, 12:32 PM
As long as you're signed up for the real-time quotes on Yahoo, and logged in with IE, RCHGetYahooQuotes() should get you the real-time quote.
On Sat, Dec 10, 2011 at 12:26 PM, Michael Thomas <thomas91112@yahoo.com > wrote:
I can get month end values that way but how about for todays real time quote?YahooHistory will display values as of the last trading day but not todays real time values which is why I was trying to work in YahooQuote.
- 3f.
-
Re: Historical and Real Time Pricing
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 10, 2011 2:02 pm (PST)
You can't insert RCHGetYahooQuotes() into the array. You'd have to do two
separate functions. If you give RCHGetYahooHistory() a beginning date and
ending date (the prior month-end), you'd just need to put the
RCHGetYahooQuotes() function at the end of the RCHGetYahooHistory( )
function. I'd suggest retrieving the adjusted closing prices. Otherwise, a
dividend event could make your historical quotes look strange. For example,
in 2008, some of the ETF's had distributions that exceeded 10%. Some mutual
funds have big ones at year-end as well.
To get the just the price of GLD, you just need to use the correct Yahoo
code -- "l1". That's a lower case letter "L" followed by a number one. Not
two lower case letter "L"s.
On Sat, Dec 10, 2011 at 2:45 PM, Michael Thomas <thomas91112@yahoo.com >wrote:
>
> Right, but if I have a column array of YahooHistory how can I insert
> YahooQuote into the array and have it apply only when a date other than
> month end appears? For example, thinking of
> =IF(TODAY()>RCHGETYAHOOHISTO RY(Ticker, ,Start Mo, Start Day,End Yr, End Mo,
> End
> Day,,"D"),RCHGETYAHOOQUOTES( Ticker,"ll" ,,NOW()), RCHGETYAHOOHISTO RY(Ticker, Start
> Yr, Start Mo, Start Day,End Yr, End Mo, End Day,,"C"))
>
> Since YahooHistory only posts as of the most recent trading day end, this
> test says if the current date is later than the most recent YahooHistory
> trading day, then retrieve the YahooQuotes value otherwise print the
> YahooHistory value.
>
> One last cosmetic item, when I
> input =RCHGetYahooQuotes("GLD","ll" ,,NOW()), I get back Dec 9 -
> <b>166.40</b>. How can I just get the value and nothing else?
>
- 4a.
-
Hi Randy, excellent work! Genious! I however would like to ask some
Posted by: "famwencong@gmail.com" famwencong@gmail.com kennethfam
Sat Dec 10, 2011 5:35 pm (PST)
Hi Randy, excellent work! Genius! I however would like to ask something a little more out of the box.
I understand its not my place to give you suggestions but in your possible future releases of the updated versions, will there be a function for an RSS extraction? Such as company news?
I do not have prior VBA knowledge but am willing to learn if you point me in the direction.
- 4b.
-
Re: Hi Randy, excellent work! Genious! I however would like to ask s
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 10, 2011 7:45 pm (PST)
Doubtful that I would go to an RSS extraction.
To tell the truth, I did some Google searching and got no where. I get
"access denied" with any RSS file I attempt to read with XMLHTTP.
On Sat, Dec 10, 2011 at 6:19 PM, <famwencong@gmail.com > wrote:
> Hi Randy, excellent work! Genius! I however would like to ask something a
> little more out of the box.
>
> I understand its not my place to give you suggestions but in your possible
> future releases of the updated versions, will there be a function for an
> RSS extraction? Such as company news?
>
> I do not have prior VBA knowledge but am willing to learn if you point me
> in the direction.
>
- 4c.
-
Re: Hi Randy, excellent work! Genious! I however would like to ask s
Posted by: "famwencong@gmail.com" famwencong@gmail.com kennethfam
Sat Dec 10, 2011 10:14 pm (PST)
Alight. Thanks. Once again great work :)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Doubtful that I would go to an RSS extraction.
>
> To tell the truth, I did some Google searching and got no where. I get
> "access denied" with any RSS file I attempt to read with XMLHTTP.
>
> On Sat, Dec 10, 2011 at 6:19 PM, <famwencong@...> wrote:
>
> > Hi Randy, excellent work! Genius! I however would like to ask something a
> > little more out of the box.
> >
> > I understand its not my place to give you suggestions but in your possible
> > future releases of the updated versions, will there be a function for an
> > RSS extraction? Such as company news?
> >
> > I do not have prior VBA knowledge but am willing to learn if you point me
> > in the direction.
> >
>
- 5a.
-
Smartmoney data
Posted by: "CheeseMan" jcrenshaw75@yahoo.com jcrenshaw75
Sun Dec 11, 2011 1:04 am (PST)
Hello,
I was wondering if you could add Smart Money fundamental data to the add-in.
Thanks,
Joe
- 5b.
-
Re: Smartmoney data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Dec 11, 2011 1:49 am (PST)
You can use the formulas yourself to get data from SmartMoney. For example:
=RCHGetTableCell("http://www.smartmon ey.com/quote/ ",1,"DividendMMM/?story= keyStatistics
X-Date")
On Sun, Dec 11, 2011 at 2:04 AM, CheeseMan <jcrenshaw75@yahoo.com > wrote:
>
> I was wondering if you could add Smart Money fundamental data to the
> add-in.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar