Jumat, 10 Oktober 2014

[smf_addin] Digest Number 3204

6 Messages

Digest #3204

Messages

Thu Oct 9, 2014 4:27 am (PDT) . Posted by:

bushpilote

Thanks for sharing digsupply. I've had some problems running all four spreadsheets and hope you can help me figure out what I'm doing wrong.


System: Excel 2007, windows vista and latest smf- add in


1) Dividend History and Earnings From Zachs Spreadsheets
I get incomplete data after removing the root directory of the add in from the formulas. In aapl, for example the payable dates and announcement data disappear.
Double checked to ensure that in removing the root directory reference the formulas where not changed.
Do I need a subscription to the data source for both dividend and earnings history?




2) Candlestick spreadsheet:
Change in ticker gets me a vba error
"Compile error; Method or data member not found"...
"with .PlotArea.Format.Fill ..ForeColor.Brightness=0" highlighted


3) Real Time Google spreadsheet
Scale macro results in vba error:
" ActiveSheet.Shapes.Range(Array("Chart 1", "Scroll Bar 1", "Scroll Bar 2")).Align msoAlignRights, msoFalse"



Thu Oct 9, 2014 8:33 am (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/A-1 REAL TIME GOOGLE WITH CHARTOct-09 3 08 48.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : A1-Realtime For 1 to 60 days with chart From Google

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/A-1%20REAL%20TIME%20GOOGLE%20WITH%20CHARTOct-09%203%2008%2048.xlsm

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

digsupply <picsound@gmail.com>

Thu Oct 9, 2014 3:25 pm (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/10 year model - GuruFocus - All Types.xlsx
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : 10 Year financial data from GF, updated

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/10%20year%20model%20-%20GuruFocus%20-%20All%20Types.xlsx

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

hamishthedenizen <dan-carroll@yahoo.com>

Thu Oct 9, 2014 3:27 pm (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/10 year model - GuruFocus - Non-Financials Only.xlsx
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : 10 Years of Financials for non-Financial companies only. Updated for minor changes in GF

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/10%20year%20model%20-%20GuruFocus%20-%20Non-Financials%20Only.xlsx

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

hamishthedenizen <dan-carroll@yahoo.com>

Thu Oct 9, 2014 4:11 pm (PDT) . Posted by:

digsupply

As regards to your first question, I would like you to go to topic 26834, a conversation with Randy who helped me with these spreadsheets. Please read the whole topic, maybe it will help you find the mistake. There you will find an attachment dated September 4, called Dividends Zacks, pls download it and try it. If you still have problems I could try to send you a copy in a zipped file.

As regards to #3, I have just upload it a modified version, called:


A-1 REAL TIME GOOGLE WITH CHARTOct-09 3 08 48.xlsm
Try that one to see if the problem is resolved



As regards to the candlestick, I don' know what may be causing that.


Thu Oct 9, 2014 8:11 pm (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/A-4-Candlestick Chart with Scroll Bars v4 Oct-10 04 14.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : Candlestick Chart with Scroll Bars data yahoo & Finviz

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/A-4-Candlestick%20Chart%20with%20Scroll%20Bars%20%20v4%20Oct-10%2004%2014.xlsm

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

digsupply <picsound@gmail.com>

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar