Thank you. It worked. Have a Happy Holiday.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> RCHGetTableCell("http://www.zacks.com/stock/quote/~~~~~/detailed-estimate",1,"Next
> Earnings")
>
> You just need to replace the ticker symbol in the original formula, without
> cell references, with five tilda characters. You can't use cell references
> in formulas for the smfUpdateDownloadTable process.
>
> On Wed, Dec 12, 2012 at 7:51 AM, bob_cutillo <jbkbob@...> wrote:
>
> > I have updated the smf-elements-6.txt file. I can get an individual cell
> > to work hardcoding the url bug don't know how to do it using
> > smfUpdateDownloadTable.
> >
> > 1 cell I can use =RCHGetTableCell("
> > http://www.zacks.com/stock/quote/MMM/detailed-estimate",1,"Next
> > Earnings") which returns 01-24-2013.
> >
> > How can I code this column for smfUpdateDownloadTable where ticker is in
> > column B?
> > I tried RCHGetTableCell("http://www.zacks.com/stock/quote/t=~~~~~"&"/detailed-estimate",1,"Next
> > Earnings")
> >
> > How can I get this to work? Thank you.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2a

Re: 120 Day Moving Average

Thu Dec 13, 2012 4:58 am (PST) . Posted by:

"Filipe Gardete" fgardete

Go to www.zonafinanceira.com<http://www.zonafinanceira.com> , select TechnicalAnalysis page and pick "Simple Moving Average".

The site is under construction but I found that it has already a lot of Technical Analysis Models (excel files with vba code) for free download.

See for yourself. Check TechnicalAnalysis page.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of malramsay
Sent: quinta-feira, 13 de Dezembro de 2012 10:16
To: smf_addin@yahoogroups.com
Subject: [smf_addin] 120 Day Moving Average

Hi all,

Does anyone know somewhere to get the 120 day moving average of a US stock? I'd rather not have to retrieve the stock history and calculate it myself as I'm dealing with a large number of stocks.

Thanks for your help,
Malcolm

A informação contida neste e-mail e os ficheiros anexos são confidenciais e deverão ser lidos única e exclusivamente pelo indivíduo ou entidade a quem são dirigidos. Se recebeu esta comunicação por erro, por favor, informe de imediato o remetente e apague a mensagem e os ficheiros anexos sem os ler, copiar, gravar, distribuir ou divulgar ou fazer qualquer outro uso da informação sem o consentimento da Cimpor. O correio electrónico via Internet não permite assegurar a confidencialidade ou a correcta recepção das mensagens, pelo que a Cimpor não assume qualquer responsabilidade por possíveis danos causados.

The information contained in this communication is confidential, may be privileged and is intended for the exclusive use of the above named addressee. If you receive this communication in error, please notify the sender immediately and delete it, and all its attached documents. If you are not the intended recipient, you are expressly prohibited from reading, copying, distributing, disseminating or, in any other way, using any of the information without the Cimpor consent. Please note that Internet e-mail guarantees neither the confidentiality nor the proper receipt of the message sent, so that Cimpor shall not be liable for any damages caused.

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2b

Re: 120 Day Moving Average

Thu Dec 13, 2012 5:12 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Are you married to the 120 day? FinViz has 20, 50, and 200. You can even
screen there and export the data (with or without the add-in). See the
LINKS area of the Yahoo group for info on retrieving data in bulk from
FinViz.

The BarChart screener allows screening on 5-, 20-, 100-, and 200-day moving
averages, and the results can be exported to EXCEL:

http://www.barchart.com/my/screener/stock.php

On Thu, Dec 13, 2012 at 3:16 AM, malramsay <malramsay@yahoo.com> wrote:

> Hi all,
>
> Does anyone know somewhere to get the 120 day moving average of a US
> stock? I'd rather not have to retrieve the stock history and calculate it
> myself as I'm dealing with a large number of stocks.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2c

Re: 120 Day Moving Average

Thu Dec 13, 2012 5:35 am (PST) . Posted by:

"malramsay" malramsay

Thanks, that's an interesting site.

Rather than downloading all the dates and having Excel calculate it for me, I was hoping to just be able to pluck the already calculated value off a webpage somewhere. Hmmm.

--- In smf_addin@yahoogroups.com, Filipe Gardete <fgardete@...> wrote:
>
> Go to www.zonafinanceira.com<http://www.zonafinanceira.com> , select TechnicalAnalysis page and pick "Simple Moving Average".
>
> The site is under construction but I found that it has already a lot of Technical Analysis Models (excel files with vba code) for free download.
>
> See for yourself. Check TechnicalAnalysis page.
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of malramsay
> Sent: quinta-feira, 13 de Dezembro de 2012 10:16
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] 120 Day Moving Average
>
>
>
> Hi all,
>
> Does anyone know somewhere to get the 120 day moving average of a US stock? I'd rather not have to retrieve the stock history and calculate it myself as I'm dealing with a large number of stocks.
>
> Thanks for your help,
> Malcolm
>
>
> A informação contida neste e-mail e os ficheiros anexos são confidenciais e deverão ser lidos única e exclusivamente pelo indivíduo ou entidade a quem são dirigidos. Se recebeu esta comunicação por erro, por favor, informe de imediato o remetente e apague a mensagem e os ficheiros anexos sem os ler, copiar, gravar, distribuir ou divulgar ou fazer qualquer outro uso da informação sem o consentimento da Cimpor. O correio electrónico via Internet não permite assegurar a confidencialidade ou a correcta recepção das mensagens, pelo que a Cimpor não assume qualquer responsabilidade por possíveis danos causados.
>
> The information contained in this communication is confidential, may be privileged and is intended for the exclusive use of the above named addressee. If you receive this communication in error, please notify the sender immediately and delete it, and all its attached documents. If you are not the intended recipient, you are expressly prohibited from reading, copying, distributing, disseminating or, in any other way, using any of the information without the Cimpor consent. Please note that Internet e-mail guarantees neither the confidentiality nor the proper receipt of the message sent, so that Cimpor shall not be liable for any damages caused.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2d

Re: 120 Day Moving Average

Thu Dec 13, 2012 5:37 am (PST) . Posted by:

"malramsay" malramsay

Hi. Thanks for your response.

Unfortunately I am tied to 120 day. I'd found FinViz & Barchart but had noted that there was no 120 day on either. Hopefully I can find the value somewhere else I'll have to calculate it myself.

Cheers.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Are you married to the 120 day? FinViz has 20, 50, and 200. You can even
> screen there and export the data (with or without the add-in). See the
> LINKS area of the Yahoo group for info on retrieving data in bulk from
> FinViz.
>
> The BarChart screener allows screening on 5-, 20-, 100-, and 200-day moving
> averages, and the results can be exported to EXCEL:
>
> http://www.barchart.com/my/screener/stock.php
>
> On Thu, Dec 13, 2012 at 3:16 AM, malramsay <malramsay@...> wrote:
>
> > Hi all,
> >
> > Does anyone know somewhere to get the 120 day moving average of a US
> > stock? I'd rather not have to retrieve the stock history and calculate it
> > myself as I'm dealing with a large number of stocks.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

3a

Morningstar Closed End Fund Data

Thu Dec 13, 2012 11:10 am (PST) . Posted by:

"jhfrazer@ymail.com" jhfrazer@ymail.com

Randy,

For a long time I used your =RCHGetTableCell function to extract certain data from Morningstar.com Closedend fund data pages. For example if you enter AFB in the quote window of morningstar.com the data for AllianceBernstein Nat Muni Inc Commonwill be displayed. I used your function to extract "total leverage ratio", "Last actual Discount", "6-month Avg. Discount" and "Total Dist. Rate".

With what I understand are changes to the morningstr pages I am now unable to extract anything from these pages which are slightly different for closed end funds.

How might I access this data now?

One more thing..please be gentle, I'm probably the oldest guy in the forum and not as technical as I would like.

Best,

John

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

3b

Re: Morningstar Closed End Fund Data

Thu Dec 13, 2012 1:26 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The bad news -- unfortunately it's another web page that Morningstar is
dynamically generating, so there are no longer any tables of data in the
source code of the web page for the add-in to extract.

HOWEVER, the good news -- I did find a source page that the data comes from
that they use to dynamically load the web page from. For example, to get
the "Total Leverage Ratio":

=RCHGetTableCell("
http://cef.morningstar.com/cef-header?returnType=html&t=AFB",6,"Total
Leverage",,,,1,"</table")

That sourced web page appears to have all the data items you mention. I'm
assuming the formula above is similar to what you were using, other than
the URL...

On Thu, Dec 13, 2012 at 12:10 PM, jhfrazer@ymail.com <jhfrazer@ymail.com>wrote:

>
> For a long time I used your =RCHGetTableCell function to extract certain
> data from Morningstar.com Closedend fund data pages. For example if you
> enter AFB in the quote window of morningstar.com the data for
> AllianceBernstein Nat Muni Inc Commonwill be displayed. I used your
> function to extract "total leverage ratio", "Last actual Discount",
> "6-month Avg. Discount" and "Total Dist. Rate".
>
> With what I understand are changes to the morningstr pages I am now unable
> to extract anything from these pages which are slightly different for
> closed end funds.
>
> How might I access this data now?
>
> One more thing..please be gentle, I'm probably the oldest guy in the forum
> and not as technical as I would like.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

4a

Re: Changing the Frequency in smfGetEconData

Thu Dec 13, 2012 12:29 pm (PST) . Posted by:

"fythras" fythras

Yeah this is true. Thank you! I've changed it around some. I want to update the econ data every time the workbook opens. I've forgotten some of my VBA code...if I want to call your function smfGetEconData from inside a sub...how do I do this. I was trying some stuff but the editor wasn't recognizing it.

Thank you for your help!

Justin

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> When I look at the file I uploaded a few years ago, the "unrate" series was
> only offered monthly:
>
> http://finance.groups.yahoo.com/group/smf_addin/files/Requested%20Samples/St-Louis-Fed-Econ-Files-Series-IDs.html
>
> Also, several people over on TMF compiled this list of FRED data:
>
> http://dl.dropbox.com/u/45054803/FRED%20Complete%20Database.xls
>
> It could be that with the FRED Add-in, they expanded the available data
> series. This is the file that the smfGetEconData() function accesses:
>
> https://research.stlouisfed.org/fred2/data/unrate.txt
>
> I don't use the FRED data myself, so I really haven't looked at it much
> since 2009.
>
> But, in terms of getting the annual data using smfGetEconData(), couldn't
> you get each year-end value from the monthly file? For example:
>
> =smfGetEconData("unrate",DATE(2010,12,1))
> =smfGetEconData("unrate",DATE(2011,12,1))
>
> You could easily create a series of dates to use as cell references.
>
> On Tue, Dec 11, 2012 at 10:22 AM, fythras <fythras@...> wrote:
>
> > Hi Guys,
> >
> > I've been using this whole add-in for a few years...it is really amazing.
> > Anyway, I'm having some trouble with the smfGetEconData. I want to change
> > the frequency of a SeriesID and I'm not sure how to do it within the
> > function. I work around my problem by using the FRED Add-In, I download
> > lets say the Series ID "unrate", the monthly US unemployment rate. The
> > data comes in monthly so after it is downloaded to the spreadsheet, a few
> > rows down from the Series ID I change the "M" to "A" and "Update" the
> > results. Doing this changes the monthly unemployment rate to an annual
> > unemployment rate. Then I just use VLookup to get the unemployment rate I
> > want...etc
> >
> > So after all that rambling, in short: how can I just do this using the
> > smfGetEconData function?
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

4b

Re: Changing the Frequency in smfGetEconData

Thu Dec 13, 2012 1:28 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

If you want to use add-in functions within your own VBA code, you need to
set the add-in as a reference library for the VBA project (> Tools >
References).

On Thu, Dec 13, 2012 at 1:29 PM, fythras <fythras@yahoo.com> wrote:

> Yeah this is true. Thank you! I've changed it around some. I want to
> update the econ data every time the workbook opens. I've forgotten some of
> my VBA code...if I want to call your function smfGetEconData from inside a
> sub...how do I do this. I was trying some stuff but the editor wasn't
> recognizing it.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

4c

Re: Changing the Frequency in smfGetEconData

Thu Dec 13, 2012 2:30 pm (PST) . Posted by:

"fythras" fythras

Ah yes! Thank you.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you want to use add-in functions within your own VBA code, you need to
> set the add-in as a reference library for the VBA project (> Tools >
> References).
>
> On Thu, Dec 13, 2012 at 1:29 PM, fythras <fythras@...> wrote:
>
> > Yeah this is true. Thank you! I've changed it around some. I want to
> > update the econ data every time the workbook opens. I've forgotten some of
> > my VBA code...if I want to call your function smfGetEconData from inside a
> > sub...how do I do this. I was trying some stuff but the editor wasn't
> > recognizing it.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

5a

ADX, +DMI, -DMI

Thu Dec 13, 2012 1:26 pm (PST) . Posted by:

"Stock Jock" stockjocktrader

Randy,

You have a great Excel addin. I noticed that you have some of the
common indicators in you code.

Case "ADL": GoTo TA_ADL
Case "ATR": GoTo TA_ATR
Case "CCI": GoTo TA_CCI
Case "EMA": GoTo TA_EMA
Case "MACD": GoTo TA_MACD
Case "OBV": GoTo TA_OBV
Case "ROC": GoTo TA_ROC
Case "RSI": GoTo TA_RSI
Case "SMA": GoTo TA_SMA
Case "STO": GoTo TA_STO

I was wondering if you have any plans to include the ADX, +DMI, -DMI?

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

5b

Re: ADX, +DMI, -DMI

Thu Dec 13, 2012 1:29 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I stopped development of that function when I found out about the free
TA-Lib add-in. I decided there was no reason to reinvent the wheel when it
was free elsewhere.

On Thu, Dec 13, 2012 at 1:19 PM, Stock Jock <stockjocktrader@yahoo.com>wrote:

>
> You have a great Excel addin. I noticed that you have some of the
> common indicators in you code.
>
> Case "ADL": GoTo TA_ADL
> Case "ATR": GoTo TA_ATR
> Case "CCI": GoTo TA_CCI
> Case "EMA": GoTo TA_EMA
> Case "MACD": GoTo TA_MACD
> Case "OBV": GoTo TA_OBV
> Case "ROC": GoTo TA_ROC
> Case "RSI": GoTo TA_RSI
> Case "SMA": GoTo TA_SMA
> Case "STO": GoTo TA_STO
>
> I was wondering if you have any plans to include the ADX, +DMI, -DMI?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

5c

Re: ADX, +DMI, -DMI

Thu Dec 13, 2012 3:32 pm (PST) . Posted by:

"Frank kirk" nautilustech

Pardon my ignorance, but what is the TA-lib add-in? Many thanks.

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

5d

Re: ADX, +DMI, -DMI

Thu Dec 13, 2012 4:04 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Check out the LINKS area of the group for a message with information about
it...

On Thu, Dec 13, 2012 at 4:32 PM, Frank kirk <nautilustech@yahoo.com> wrote:

>
> Pardon my ignorance, but what is the TA-lib add-in? Many thanks.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

6 Data Sources

Thu Dec 13, 2012 6:09 pm (PST) . Posted by:

"Stock Jock" stockjocktrader

Randy,

In looking at your code and the reference files, am I
correct to think that the addin can get data from more sources than just
from Yahoo Finance and all of them are EOD data only?