EXCEL Stock Market Functions Add-in Group

15 New Messages

Digest #2869

Different Server ? by ronaldj309

Re: Different Server ? by "Randy Harmelink" rharmelink

Re: Different Server ? by ronaldj309

2.1

smfForceRecalculation by alanmoore1966

2.2

Re: smfForceRecalculation by "Kermit W. Prather" kermitpra

2.3

Re: smfForceRecalculation by alanmoore1966

2.4

Re: smfForceRecalculation by "Randy Harmelink" rharmelink

2.5

Re: smfForceRecalculation by "Kermit W. Prather" kermitpra

Re: GuruFocus.com 10-Y Financials AAPL by codyklein

Instruction of smfConvert(smfGetTagContent) by holmberg_tommy

Re: Instruction of smfConvert(smfGetTagContent) by "Randy Harmelink" rharmelink

Working on php version of SMF by "PeteA" option2z

Re: Working on php version of SMF by "Randy Harmelink" rharmelink

Re: Working on php version of SMF by "rex" bios007a

Re: Working on php version of SMF by "Kermit W. Prather" kermitpra

Messages

1a

I am using =RCHGetYahooHistory($A$1,,,,,,,,,,,0) as an array entered function in EXCEL 2010. I have the smfForceRecalculation macro installed. Normally all works Ok. I click on the button to run the smfForceRecalculation macro and the spreadsheet is updated with the latest Yahoo data (for SPY in this case). Now and then it doesn't update, and if I use IE to go to http://finance.yahoo.com/q/hp?s=SPY+Historical+Prices http://finance.yahoo.com/q/hp?s=SPY+Historical+Prices
I see the latest data. For example, today the latest data is as of 11/21/2013, but in EXCEL the latest I get is 11/20/2013.
I have seen various posts concerning not all servers being updated. I am in Spain which may complicate this. It's 11:38AM here which is 5:38AM EST.. Too early? Usually it works by now.
Any suggestions ?
Any suggestions?

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

1b

Re: Different Server ?

Fri Nov 22, 2013 3:03 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Make sure you have your Internet Options set to always get fresh web
content (see the second smfForceRecalculation item in the LINKS area of the
group for more info).

On Fri, Nov 22, 2013 at 3:40 AM, <ronaldj309@cox.net> wrote:

> I am using =RCHGetYahooHistory($A$1,,,,,,,,,,,0) as an array entered
> function in EXCEL 2010. I have the smfForceRecalculation macro installed.
> Normally all works Ok. I click on the button to run the
> smfForceRecalculation macro and the spreadsheet is updated with the latest
> Yahoo data (for SPY in this case). Now and then it doesn't update, and if
> I use IE to go to http://finance.yahoo.com/q/hp?s=SPY+Historical+Prices
>
> I see the latest data. For example, today the latest data is as
> of 11/21/2013, but in EXCEL the latest I get is 11/20/2013.
> I have seen various posts concerning not all servers being updated. I am
> in Spain which may complicate this. It's 11:38AM here which is 5:38AM
> EST.. Too early? Usually it works by now.
>
> Any suggestions ?
>

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

1c

Re: Different Server ?

Fri Nov 22, 2013 5:13 am (PST) . Posted by:

ronaldj309

Thanks. Tried a variety of things: Restart, setting internet options and finally updated to the latest version of the add-in. Now is working. Changing the version may have been it. Then again maybe just the passage of time. Was using Ver1-1.2012-02-02. Sorry for the bother

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Make sure you have your Internet Options set to always get fresh web content (see the second smfForceRecalculation item in the LINKS area of the group for more info).
On Fri, Nov 22, 2013 at 3:40 AM, <ronaldj309@... mailto:ronaldj309@...> wrote:
I am using =RCHGetYahooHistory($A$1,,,,,,,,,,,0) as an array entered function in EXCEL 2010. I have the smfForceRecalculation macro installed. Normally all works Ok. I click on the button to run the smfForceRecalculation macro and the spreadsheet is updated with the latest Yahoo data (for SPY in this case). Now and then it doesn't update, and if I use IE to go to http://finance.yahoo.com/q/hp?s=SPY+Historical+Prices http://finance.yahoo.com/q/hp?s=SPY+Historical+Prices
I see the latest data. For example, today the latest data is as of 11/21/2013, but in EXCEL the latest I get is 11/20/2013.
I have seen various posts concerning not all servers being updated. I am in Spain which may complicate this. It's 11:38AM here which is 5:38AM EST.. Too early? Usually it works by now.
Any suggestions ?

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

2.1 smfForceRecalculation

Fri Nov 22, 2013 7:05 am (PST) . Posted by:

alanmoore1966

What am I missing? I simple what to add a button and assign smfForceRecalculation to update all reference in my spread sheet? After a great deal of reading I am unable to make smfForceRecalculation work. Can someone point me in the right direction?

Regards
Ronnie Moore

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

2.2 Re: smfForceRecalculation

Fri Nov 22, 2013 7:24 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

You might click on Excel help and enter Add to Quick access bar. This gives you a lot to choose from. I selected the link below. But there are many more helpful articles.

I always start with Excel help – I find it very helpful as it does not limit the help to Microsoft, thank god.

http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html

But here are several more useful links:

ALL SITES| <http://office.microsoft.com/client/searchresults.aspx?NS=EXCEL&VERSION=12&LCID=1033&SYSLCID=1033&UILCID=1033&Query=add%20to%20quick%20access%20bar&Scope=HP%2CHA%2CRZ%2CFX%2CXT> TRUSTED SITES
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HA012330439990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Organize quick file access by using the My Places bar
ArticleYou likely have one or more folders where you store files of certain types, and you often need to find or store files in these folders. You can use the My Place...
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102325049990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> A visual introduction to the 2007 Office release
Article2007 Microsoft Office System Plain & Simple By Jerry Joyce and Marianne Moon Jerry Joyce has been the technical editor on numerous books published by Microsoft ...
<http://office.microsoft.com/redir/RZ101482529990.aspx?client=1&Ver=12&NS=EXCEL&lc=en%2DUS&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Up to speed with the 2007 Office system
TrainingOverview Get an introduction to the new look in familiar programs of the 2007 Microsoft Office system. Then try out the changes with a hands-on test drive. Aft...
<http://office.microsoft.com/redir/RZ100621039990.aspx?client=1&Ver=12&NS=EXCEL&lc=en%2DUS&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Up to speed with Excel 2007
TrainingOverview Get a hands-on introduction to the new look of Microsoft Office Excel 2007, and see how to do what you're used to doing in Excel as you get up to spee...
<http://spreadsheets.about.com/od/excelformatting/qt/090906-excel-autoformat-button.htm> Excel Toolbar - Excel Quick Access Toolbar
LinkThe Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the autoformat button to the Quick ...
<http://spreadsheets.about.com/od/excelformatting/qt/090906-excel-autoformat-button.htm> spreadsheets.about.com
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HP100074629990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Add, change, or remove error bars in a chart
ArticleIn Excel, Outlook, PowerPoint, or Word 2007, you can format (add, change or remove) error bars in a chart.
<http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html> Excel 2007 : adding custom button to quick access toolbar
LinkI just entered the world of excel 2007 (and win7) kicking and screaming. I have a macro that I want to add as a button on the quick access toolbar.
<http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html> www.excelforum.com
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HP100074609990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Add or remove series lines, drop lines, high-low lines, or up-down bars in a chart
ArticleIn Excel, you can add predefined series lines, drop lines, high-low lines and up-down bars to make a specific charts (such as 2-D stacked bar and column charts,...
<http://www.excelforum.com/excel-general/759579-excel-2007-adding-advanced-options-in-excel-2007-to-a-quick-access-toolbar.html> Excel 2007 : Adding Advanced Options in Excel 2007 to a Quick ...
LinkIn Excel 2007, is it possible to add Advanced Options (Office Button/Excel Options/Advanced, Editing options) to a Quick Access Toolbar? I'm particularly intere...
<http://www.excelforum.com/excel-general/759579-excel-2007-adding-advanced-options-in-excel-2007-to-a-quick-access-toolbar.html> www.excelforum.com
<http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html> How to Add an Excel 2007 Macro to the Quick Access Toolbar ...
LinkYou can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button. This provides quicker acces...
<http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html> www.dummies.com
<http://www.msoffice-tutorial-training.com/customize-quick-access-toolbar.html> Customize Quick Access Toolbar | Add commands to the Quick ...
LinkHow you can quickly customize quick access toolbar by adding a command button for easy accessibility? "Guide to Customize Quick Access Toolbar in Microsoft Exce...
<http://www.msoffice-tutorial-training.com/customize-quick-access-toolbar.html> www.msoffice-tutorial-training.com
<http://www.dummies.com/how-to/content/customizing-the-excel-2007-quick-access-toolbar.html> Customizing the Excel 2007 Quick Access Toolbar - For Dummies
LinkThe Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use o...
<http://www.dummies.com/how-to/content/customizing-the-excel-2007-quick-access-toolbar.html> www.dummies.com
<https://askdrexel.drexel.edu/app/answers/detail/a_id/2539/~/how-to%3A-add-command-to-quick-access-toolbar-in-excel-2007> How to: Add command to Quick Access toolbar in Excel 2007.
LinkAnswers others found helpful. How to: Turn on mini toolbar in Excel 2007. How to: Add the Run command to the Start menu in Windows Vista. How to: Customize snip...
<https://askdrexel.drexel.edu/app/answers/detail/a_id/2539/~/how-to:-add-command-to-quick-access-toolbar-in-excel-2007> askdrexel.drexel.edu
<http://tipsindeed.com/excel/customize-quick-access-toolbar-in-excel-2007.html> Customize Quick Access Toolbar - Excel 2007 Microsoft Office ...
LinkExcel 2007 comes with the feature to customize the Quick Access Toolbar. Quick Access Toolbar contains set of commands which is indepedent of the tabs that are ...
<http://tipsindeed.com/excel/customize-quick-access-toolbar-in-excel-2007.html> tipsindeed.com
<http://www.vtc.com/products/MicrosoftExcel2007/IntroductiontoExcel2007/66923> Microsoft Excel 2007, Using the Quick Access Toolbar
LinkVTC tutorials, VTC Player - Microsoft Excel 2007, Using the Quick Access Toolbar
<http://www.vtc.com/products/MicrosoftExcel2007/IntroductiontoExcel2007/66923> www.vtc.com
<http://www.spreadsheetshoppe.com/add-add-in-to-quick-access-toolbar.html> Add Excel Add-In to Quick Access Toolbar - SpreadsheetShoppe
LinkAfter you've saved the add-in to your computer (click here for instructions Excel 2003 or Excel 2007/2010). You can add the add-in to your quick access toolbar ...
<http://www.spreadsheetshoppe.com/add-add-in-to-quick-access-toolbar.html> www.spreadsheetshoppe.com

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of alanmoore1966@yahoo.com
Sent: Friday, November 22, 2013 9:44 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] smfForceRecalculation

What am I missing? I simple what to add a button and assign smfForceRecalculation to update all reference in my spread sheet? After a great deal of reading I am unable to make smfForceRecalculation work. Can someone point me in the right direction?

Regards
Ronnie Moore

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

2.3 Re: smfForceRecalculation

Fri Nov 22, 2013 8:19 am (PST) . Posted by:

alanmoore1966

Thanks for the attempt Kermit but that came nowhere close to answering the question I asked. It is not about adding a button, it was about using the hidden smfForceRecalculation macro. I have since figured out the solution.

When assigning a macro to a button I was mistakenly creating a macro and trying to call the smfForceRecalculation macro from within. Turns out all I needed to do was enter smfForceRecalculation in the macro name field and select OK.

---In smf_addin@yahoogroups.com, <kermitp@...> wrote:

You might click on Excel help and enter Add to Quick access bar. This gives you a lot to choose from. I selected the link below. But there are many more helpful articles.

I always start with Excel help – I find it very helpful as it does not limit the help to Microsoft, thank god.

http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html

But here are several more useful links:

ALL SITES|TRUSTED SITES http://office.microsoft.com/client/searchresults.aspx?NS=EXCEL&VERSION=12&LCID=1033&SYSLCID=1033&UILCID=1033&Query=add%20to%20quick%20access%20bar&Scope=HP%2CHA%2CRZ%2CFX%2CXT
Organize quick file access by using the My Places bar http://office.microsoft.com/client/helppreview.aspx?AssetId=HA012330439990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5
ArticleYou likely have one or more folders where you store files of certain types, and you often need to find or store files in these folders. You can use the My Place...
A visual introduction to the 2007 Office release http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102325049990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5
Article2007 Microsoft Office System Plain & Simple By Jerry Joyce and Marianne Moon Jerry Joyce has been the technical editor on numerous books published by Microsoft ...
Up to speed with the 2007 Office system http://office.microsoft.com/redir/RZ101482529990.aspx?client=1&Ver=12&NS=EXCEL&lc=en%2DUS&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5
TrainingOverview Get an introduction to the new look in familiar programs of the 2007 Microsoft Office system. Then try out the changes with a hands-on test drive. Aft...
Up to speed with Excel 2007 http://office.microsoft.com/redir/RZ100621039990.aspx?client=1&Ver=12&NS=EXCEL&lc=en%2DUS&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5
TrainingOverview Get a hands-on introduction to the new look of Microsoft Office Excel 2007, and see how to do what you're used to doing in Excel as you get up to spee...
Excel Toolbar - Excel Quick Access Toolbar http://spreadsheets.about.com/od/excelformatting/qt/090906-excel-autoformat-button.htm
LinkThe Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the autoformat button to the Quick ...
spreadsheets.about.com http://spreadsheets.about.com/od/excelformatting/qt/090906-excel-autoformat-button.htm
Add, change, or remove error bars in a chart http://office.microsoft.com/client/helppreview.aspx?AssetId=HP100074629990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5
ArticleIn Excel, Outlook, PowerPoint, or Word 2007, you can format (add, change or remove) error bars in a chart.
Excel 2007 : adding custom button to quick access toolbar http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html
LinkI just entered the world of excel 2007 (and win7) kicking and screaming. I have a macro that I want to add as a button on the quick access toolbar.
www.excelforum.com http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html
Add or remove series lines, drop lines, high-low lines, or up-down bars in a chart http://office.microsoft.com/client/helppreview.aspx?AssetId=HP100074609990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5
ArticleIn Excel, you can add predefined series lines, drop lines, high-low lines and up-down bars to make a specific charts (such as 2-D stacked bar and column charts,...
Excel 2007 : Adding Advanced Options in Excel 2007 to a Quick ... http://www.excelforum.com/excel-general/759579-excel-2007-adding-advanced-options-in-excel-2007-to-a-quick-access-toolbar.html
LinkIn Excel 2007, is it possible to add Advanced Options (Office Button/Excel Options/Advanced, Editing options) to a Quick Access Toolbar? I'm particularly intere...
www.excelforum.com http://www.excelforum.com/excel-general/759579-excel-2007-adding-advanced-options-in-excel-2007-to-a-quick-access-toolbar.html
How to Add an Excel 2007 Macro to the Quick Access Toolbar ... http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html
LinkYou can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button. This provides quicker acces...
www.dummies.com http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html
Customize Quick Access Toolbar | Add commands to the Quick ... http://www.msoffice-tutorial-training.com/customize-quick-access-toolbar.html
LinkHow you can quickly customize quick access toolbar by adding a command button for easy accessibility? "Guide to Customize Quick Access Toolbar in Microsoft Exce...
www.msoffice-tutorial-training.com http://www.msoffice-tutorial-training.com/customize-quick-access-toolbar.html
Customizing the Excel 2007 Quick Access Toolbar - For Dummies http://www.dummies.com/how-to/content/customizing-the-excel-2007-quick-access-toolbar.html
LinkThe Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use o...
www.dummies.com http://www.dummies.com/how-to/content/customizing-the-excel-2007-quick-access-toolbar.html
How to: Add command to Quick Access toolbar in Excel 2007. https://askdrexel.drexel.edu/app/answers/detail/a_id/2539/~/how-to%3A-add-command-to-quick-access-toolbar-in-excel-2007
LinkAnswers others found helpful. How to: Turn on mini toolbar in Excel 2007. How to: Add the Run command to the Start menu in Windows Vista. How to: Customize snip...
askdrexel.drexel.edu https://askdrexel.drexel.edu/app/answers/detail/a_id/2539/~/how-to:-add-command-to-quick-access-toolbar-in-excel-2007
Customize Quick Access Toolbar - Excel 2007 Microsoft Office ... http://tipsindeed.com/excel/customize-quick-access-toolbar-in-excel-2007.html
LinkExcel 2007 comes with the feature to customize the Quick Access Toolbar. Quick Access Toolbar contains set of commands which is indepedent of the tabs that are ...
tipsindeed.com http://tipsindeed.com/excel/customize-quick-access-toolbar-in-excel-2007.html
Microsoft Excel 2007, Using the Quick Access Toolbar http://www.vtc.com/products/MicrosoftExcel2007/IntroductiontoExcel2007/66923
LinkVTC tutorials, VTC Player - Microsoft Excel 2007, Using the Quick Access Toolbar
www.vtc.com http://www.vtc.com/products/MicrosoftExcel2007/IntroductiontoExcel2007/66923
Add Excel Add-In to Quick Access Toolbar - SpreadsheetShoppe http://www.spreadsheetshoppe.com/add-add-in-to-quick-access-toolbar.html
LinkAfter you've saved the add-in to your computer (click here for instructions Excel 2003 or Excel 2007/2010). You can add the add-in to your quick access toolbar ...
www.spreadsheetshoppe.com http://www.spreadsheetshoppe.com/add-add-in-to-quick-access-toolbar.html

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of alanmoore1966@...
Sent: Friday, November 22, 2013 9:44 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] smfForceRecalculation

What am I missing? I simple what to add a button and assign smfForceRecalculation to update all reference in my spread sheet? After a great deal of reading I am unable to make smfForceRecalculation work. Can someone point me in the right direction?

Regards
Ronnie Moore

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

2.4 Re: smfForceRecalculation

Fri Nov 22, 2013 10:57 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Glad you got it resolved.

The macro isn't "hidden". It's just that EXCEL has no way set up to show
macros that exists within add-ins. That is, alt+F8 doesn't have an option
to show the add-in macros, just those in "open workbooks".

On Fri, Nov 22, 2013 at 9:19 AM, <alanmoore1966@yahoo.com> wrote:

> Thanks for the attempt Kermit but that came nowhere close to answering
> the question I asked. It is not about adding a button, it was about using
> the hidden smfForceRecalculation macro. I have since figured out the
> solution.
>
> When assigning a macro to a button I was mistakenly creating a macro and
> trying to call the smfForceRecalculation macro from within. Turns out all I
> needed to do was enter smfForceRecalculation in the macro name field and
> select OK.
>

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

2.5 Re: smfForceRecalculation

Fri Nov 22, 2013 3:07 pm (PST) . Posted by:

"Kermit W. Prather" kermitpra

Really, it works for me. I added a button in the upper left corner of excel for the forcerecal, update links, and updatedownloadtable.

Makes it really handy as there are the 3 functions I use the most.

Anyway, glad you figured it out.

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of alanmoore1966@yahoo.com
Sent: Friday, November 22, 2013 11:20 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RE: smfForceRecalculation

Thanks for the attempt Kermit but that came nowhere close to answering the question I asked. It is not about adding a button, it was about using the hidden smfForceRecalculation macro. I have since figured out the solution.

When assigning a macro to a button I was mistakenly creating a macro and trying to call the smfForceRecalculation macro from within. Turns out all I needed to do was enter smfForceRecalculation in the macro name field and select OK.

---In smf_addin@yahoogroups.com, <kermitp@...> wrote:
You might click on Excel help and enter Add to Quick access bar. This gives you a lot to choose from. I selected the link below. But there are many more helpful articles.

I always start with Excel help – I find it very helpful as it does not limit the help to Microsoft, thank god.

http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html

But here are several more useful links:

ALL SITES| <http://office.microsoft.com/client/searchresults.aspx?NS=EXCEL&VERSION=12&LCID=1033&SYSLCID=1033&UILCID=1033&Query=add%20to%20quick%20access%20bar&Scope=HP%2CHA%2CRZ%2CFX%2CXT> TRUSTED SITES
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HA012330439990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Organize quick file access by using the My Places bar
ArticleYou likely have one or more folders where you store files of certain types, and you often need to find or store files in these folders. You can use the My Place...
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102325049990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> A visual introduction to the 2007 Office release
Article2007 Microsoft Office System Plain & Simple By Jerry Joyce and Marianne Moon Jerry Joyce has been the technical editor on numerous books published by Microsoft ...
<http://office.microsoft.com/redir/RZ101482529990.aspx?client=1&Ver=12&NS=EXCEL&lc=en%2DUS&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Up to speed with the 2007 Office system
TrainingOverview Get an introduction to the new look in familiar programs of the 2007 Microsoft Office system. Then try out the changes with a hands-on test drive. Aft...
<http://office.microsoft.com/redir/RZ100621039990.aspx?client=1&Ver=12&NS=EXCEL&lc=en%2DUS&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Up to speed with Excel 2007
TrainingOverview Get a hands-on introduction to the new look of Microsoft Office Excel 2007, and see how to do what you're used to doing in Excel as you get up to spee...
<http://spreadsheets.about.com/od/excelformatting/qt/090906-excel-autoformat-button.htm> Excel Toolbar - Excel Quick Access Toolbar
LinkThe Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the autoformat button to the Quick ...
<http://spreadsheets.about.com/od/excelformatting/qt/090906-excel-autoformat-button.htm> spreadsheets.about.com
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HP100074629990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Add, change, or remove error bars in a chart
ArticleIn Excel, Outlook, PowerPoint, or Word 2007, you can format (add, change or remove) error bars in a chart.
<http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html> Excel 2007 : adding custom button to quick access toolbar
LinkI just entered the world of excel 2007 (and win7) kicking and screaming. I have a macro that I want to add as a button on the quick access toolbar.
<http://www.excelforum.com/excel-general/716055-excel-2007-adding-custom-button-to-quick-access-toolbar.html> www.excelforum.com
<http://office.microsoft.com/client/helppreview.aspx?AssetId=HP100074609990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=136a3839%2Deb09%2D4d85%2Dac0b%2Db7ab06d3e2c5> Add or remove series lines, drop lines, high-low lines, or up-down bars in a chart
ArticleIn Excel, you can add predefined series lines, drop lines, high-low lines and up-down bars to make a specific charts (such as 2-D stacked bar and column charts,...
<http://www.excelforum.com/excel-general/759579-excel-2007-adding-advanced-options-in-excel-2007-to-a-quick-access-toolbar.html> Excel 2007 : Adding Advanced Options in Excel 2007 to a Quick ...
LinkIn Excel 2007, is it possible to add Advanced Options (Office Button/Excel Options/Advanced, Editing options) to a Quick Access Toolbar? I'm particularly intere...
<http://www.excelforum.com/excel-general/759579-excel-2007-adding-advanced-options-in-excel-2007-to-a-quick-access-toolbar.html> www.excelforum.com
<http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html> How to Add an Excel 2007 Macro to the Quick Access Toolbar ...
LinkYou can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button. This provides quicker acces...
<http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html> www.dummies.com
<http://www.msoffice-tutorial-training.com/customize-quick-access-toolbar.html> Customize Quick Access Toolbar | Add commands to the Quick ...
LinkHow you can quickly customize quick access toolbar by adding a command button for easy accessibility? "Guide to Customize Quick Access Toolbar in Microsoft Exce...
<http://www.msoffice-tutorial-training.com/customize-quick-access-toolbar.html> www.msoffice-tutorial-training.com
<http://www.dummies.com/how-to/content/customizing-the-excel-2007-quick-access-toolbar.html> Customizing the Excel 2007 Quick Access Toolbar - For Dummies
LinkThe Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use o...
<http://www.dummies.com/how-to/content/customizing-the-excel-2007-quick-access-toolbar.html> www.dummies.com
<https://askdrexel.drexel.edu/app/answers/detail/a_id/2539/~/how-to%3A-add-command-to-quick-access-toolbar-in-excel-2007> How to: Add command to Quick Access toolbar in Excel 2007.
LinkAnswers others found helpful. How to: Turn on mini toolbar in Excel 2007. How to: Add the Run command to the Start menu in Windows Vista. How to: Customize snip...
<https://askdrexel.drexel.edu/app/answers/detail/a_id/2539/~/how-to:-add-command-to-quick-access-toolbar-in-excel-2007> askdrexel.drexel.edu
<http://tipsindeed.com/excel/customize-quick-access-toolbar-in-excel-2007.html> Customize Quick Access Toolbar - Excel 2007 Microsoft Office ...
LinkExcel 2007 comes with the feature to customize the Quick Access Toolbar. Quick Access Toolbar contains set of commands which is indepedent of the tabs that are ...
<http://tipsindeed.com/excel/customize-quick-access-toolbar-in-excel-2007.html> tipsindeed.com
<http://www.vtc.com/products/MicrosoftExcel2007/IntroductiontoExcel2007/66923> Microsoft Excel 2007, Using the Quick Access Toolbar
LinkVTC tutorials, VTC Player - Microsoft Excel 2007, Using the Quick Access Toolbar
<http://www.vtc.com/products/MicrosoftExcel2007/IntroductiontoExcel2007/66923> www.vtc.com
<http://www.spreadsheetshoppe.com/add-add-in-to-quick-access-toolbar.html> Add Excel Add-In to Quick Access Toolbar - SpreadsheetShoppe
LinkAfter you've saved the add-in to your computer (click here for instructions Excel 2003 or Excel 2007/2010). You can add the add-in to your quick access toolbar ...
<http://www.spreadsheetshoppe.com/add-add-in-to-quick-access-toolbar.html> www.spreadsheetshoppe.com

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of alanmoore1966@...
Sent: Friday, November 22, 2013 9:44 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] smfForceRecalculation

What am I missing? I simple what to add a button and assign smfForceRecalculation to update all reference in my spread sheet? After a great deal of reading I am unable to make smfForceRecalculation work. Can someone point me in the right direction?

Regards
Ronnie Moore

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

3a

Re: GuruFocus.com 10-Y Financials AAPL

Fri Nov 22, 2013 7:33 am (PST) . Posted by:

codyklein

It's a glitch, if you contact them they fix it pretty fast. In the future click on contact us at the bottom of the page, also attach a screenshot.

---In smf_addin@yahoogroups.com, <dan-carroll@...> wrote:

I've only seen it on AAPL so far, no problem on other stocks. Are folks getting it for other tickers?

---In smf_addin@yahoogroups.com, <tmallen2@...> wrote:

Yes I viewed it in my browser. I get the same thing. Hopefully it is temporary or I need to program another site for all my financials. :(

--- In smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Have you tried viewing it with your browser? When I go to 10-year
> financials on AAPL, it says it requires a premium membership. It's either a
> temporary glitch, or you guys have been using the pages so much, they
> decided to put it under the premium membership umbrella (i.e. just the
> first of many to go that route)...
>
> Only time will tell which.
>
>
> On Thu, Nov 21, 2013 at 8:06 AM, ridgebacksexcel <tmallen2@...>wrote:
>
> > Does anyone here know why AAPL is not showing in the 10-Y Financials on
> > GuruFocus.com? It says "cached" and then displays a trial membership.
> >
> > All the other stocks I track seem to display fine.
> >
>

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

4a

Instruction of smfConvert(smfGetTagContent)

Fri Nov 22, 2013 8:04 am (PST) . Posted by:

holmberg_tommy

Hi Randy,

I need to admit that l didn't fully catch up the instructions that you last time gave me.

To collect all the needed information only from one location and instead of using Reuters and FT at the same time, I have been trying get EPS (TTM) from Reuters but with poor results. This has to do with the fact that I don't fully understand what I should put in the formula.

Formula that brings price is following:

=smfConvertData(smfGetTagContent("http://www.reuters.com/finance/stocks/overview?symbol="&E5;"span";2;"sectionQuoteDetail"))

How should I change it to collect EPS and what is the meaning of the "span" at the middle? it seems that last item is the div class but for EPS's case I not sure what to put in there.

- Tommy

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

4b

Re: Instruction of smfConvert(smfGetTagContent)

Fri Nov 22, 2013 8:10 am (PST) . Posted by:

"Randy Harmelink" rharmelink

From the documentation:

*Tag * = The type of tag to retrieve content from -- "table", "td", "li",
"span", etc.

However, since the data you want is in a table, you can just use the much
simpler:

=RCHGetTableCell("http://www.reuters.com/finance/stocks/overview?symbol="&C3,1,">EPS
(TTM)")

The search string to use is whatever you think will stay unique enough to
position the function for the data extraction.

On Fri, Nov 22, 2013 at 9:04 AM, <holmberg_tommy@yahoo.com> wrote:

>
> I need to admit that l didn't fully catch up the instructions that you
> last time gave me.
>
> To collect all the needed information only from one location and instead
> of using Reuters and FT at the same time, I have been trying get EPS (TTM)
> from Reuters but with poor results. This has to do with the fact that I
> don't fully understand what I should put in the formula.
>
> Formula that brings price is following:
>
> =smfConvertData(smfGetTagContent("
> http://www.reuters.com/finance/stocks/overview?symbol=
> "&E5;"span";2;"sectionQuoteDetail"))
>
> How should I change it to collect EPS and what is the meaning of the
> "span" at the middle? it seems that last item is the div class but for
> EPS's case I not sure what to put in there.
>
>

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

5a

Working on php version of SMF

Fri Nov 22, 2013 10:31 am (PST) . Posted by:

"PeteA" option2z

Hi All,

I'm starting work on building pieces of a baby version of Randy's
magnificent SMF. Has anyone done anything like that? (I hate re-inventing
wheels). If so might you share your efforts? My first shot at it gets some
YAHOO data and presents a buy day signal to my TtP-S group.it looks like
this: http://www.ttp-s.com/php/ttpBuyDayR.php

Why do this? Because I need server-side (runs on server instead of
workstation) functionality.

I appreciate any ideas or sharing of your work.

Randy, if you think back to how all of this started, what would be your 1st,
2nd and 3rd pieces?

Thanks,

Thanks,
Pete A
<http://www.sundognorth.com/TtP-S/>

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

5b

Re: Working on php version of SMF

Fri Nov 22, 2013 11:05 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Did you look at the jivedata.com resource mentioned earlier this week? It
may have some of what you want.

Also, be sure that PHP can do what you need. I used to grab AdvFN web pages
with PHP, but AdvFN changed something that stopped the PHP process from
being able to grab their source code. I'm no PHP expert, so I didn't have
any luck getting it fixed.

As far as the top three, RCHGetYahooQuotes(), RCHGetYahooHistory(), and
RCHGetTableCell(). smfGetTagContent() would give you more capability than
RCHGetTableCell().

But, basically, a CSV file converter and a web page extraction tool.

With JiveData.com, a JSON file conversion/extraction is needed. An XML
extractor would also be helpful, although I've been able to use
smfGetTagContent() for most of that type of data.

On Fri, Nov 22, 2013 at 11:30 AM, PeteA <optionzz@gmail.com> wrote:

>
> I'm starting work on building pieces of a baby version of Randy's
> magnificent SMF. Has anyone done anything like that? (I hate
> re-inventing wheels). If so might you share your efforts? My first shot
> at it gets some YAHOO data and presents a buy day signal to my TtP-S
> group…it looks like this: http://www.ttp-s.com/php/ttpBuyDayR.php
>
>
>
> Why do this? Because I need server-side (runs on server instead of
> workstation) functionality.
>
>
>
> I appreciate any ideas or sharing of your work.
>
>
>
> Randy, if you think back to how all of this started, what would be your 1
> st, 2nd and 3rd pieces?
>
>
>

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

5c

Re: Working on php version of SMF

Fri Nov 22, 2013 3:09 pm (PST) . Posted by:

"rex" bios007a

PeteA <optionzz@gmail.com> [2013-11-22 10:31]:
> I'm starting work on building pieces of a baby version of Randy's
> magnificent SMF. Has anyone done anything like that? (I hate
> re-inventing wheels). If so might you share your efforts? My first shot
> at it gets some YAHOO data and presents a buy day signal to my TtP-S
> group…it looks like this: [3]http://www.ttp-s.com/php/ttpBuyDayR.php

Hi Pete,

Why PHP? As I'm sure you know, a hasty choice of language may cause
big problems later if it turns out to be poorly suited to the overall
task. Your TtP-S does some things that are in the realm of computational
finance, and PHP is utterly unsuited for that field. Why choose a language
that may make it easy to gather data at the cost of crippling development
of TtP-S?

As you know, I've essentially duplicated the functionality of TtP-S
using R. Unlike PHP, R is suited for computational finance due to
the many free finance packages available for it (R currently has ~4,800
free packages available, at least dozens of which are useful for
computational finance). For example, getting the data required to
test for buy signals is trivially easy with the quantmod package (and
several others). Mailing the alerts is also easy.

Duplicating some of the other functionalities of Randy's SMF in R
would not be so easy, but there are a number of R packages for web
scraping (e.g., RCurl), so you wouldn't be starting from scratch.

http://www.programmingr.com/content/webscraping-using-readlines-and-rcurl/

It's when you get into processing the data that R leaves PHP in the dust.
For example, TtP-S uses Hoadley's add-in to estimate sell targets. This
calculation can be done in R with no proprietary add-in. And so it goes...
many things that are difficult with PHP/Excel are easy with R packages.

You are already somewhat familiar with R. I'm baffled by you turning
to PHP for a task that is easy in R.

-rex
--
Those who forget the pasta are condemed to reheat it.

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

5d

Re: Working on php version of SMF

Fri Nov 22, 2013 3:09 pm (PST) . Posted by:

"Kermit W. Prather" kermitpra

Have you tried Google drive?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of PeteA
Sent: Friday, November 22, 2013 1:31 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Working on php version of SMF

Hi All,

I'm starting work on building pieces of a baby version of Randy's
magnificent SMF. Has anyone done anything like that? (I hate re-inventing
wheels). If so might you share your efforts? My first shot at it gets some
YAHOO data and presents a buy day signal to my TtP-S group.it looks like
this: http://www.ttp-s.com/php/ttpBuyDayR.php

Why do this? Because I need server-side (runs on server instead of
workstation) functionality.

I appreciate any ideas or sharing of your work.

Randy, if you think back to how all of this started, what would be your 1st,
2nd and 3rd pieces?

Thanks,

Thanks,
Pete A
<http://www.sundognorth.com/TtP-S/>