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"
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.
3) Real Time Google spreadsheet
Scale macro results in vba error:
" ActiveSheet.
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>
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>
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.
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.
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