Selasa, 14 Juli 2015

[smf_addin] Digest Number 3455

6 Messages

Digest #3455

Messages

Mon Jul 13, 2015 6:24 am (PDT) . Posted by:

toantranvnpt

I am trying to download MSFT (Microsoft) for my work



I saw Investing Sidekick - Stock Reports for DIY Investors https://investingsidekick.com/


https://investingsidekick.com/

Investing Sidekick - Stock Reports for DIY Investors https://investingsidekick.com/ Get access to fundamental stock analysis and stock reports on thousands of US listed stocks. Our stock valuation spreadsheets work in Excel and Googl...



View on investingsidekick.com https://investingsidekick.com/
Preview by Yahoo




I amtrying to do a spreedsheet like that, based on SMF Add-In, but I do not know where to start the work.


Can anyone help me a basic start


Regards


Mon Jul 13, 2015 8:11 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Start by reading the documentation. Then build a list of the elements you need. Layout the format for the spreadsheet.
Then search the element definition file for the best fit.

Don't try to do it all at once. Code a few simple elements and build on it.

You have not provided enough info for anyone to help you.
But if you look thru the excel files and templates I think you might be surprised to find they already exist.
Just not in the exact format you might want.


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 13, 2015 4:24 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] I am trying to download MSFT (Microsoft) for my work


I am trying to download MSFT (Microsoft) for my work

I saw Investing Sidekick - Stock Reports for DIY Investors <https://investingsidekick.com/>


<https://investingsidekick.com/> image
<https://investingsidekick.com/> Investing Sidekick - Stock Reports for DIY Investors
Get access to fundamental stock analysis and stock reports on thousands of US listed stocks. Our stock valuation spreadsheets work in Excel and Googl...


<https://investingsidekick.com/> View on investingsidekick.com
Preview by Yahoo



I amtrying to do a spreedsheet like that, based on SMF Add-In, but I do not know where to start the work.

Can anyone help me a basic start

Regards


Mon Jul 13, 2015 8:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The MSN elements are now all obsolete, because MSN designed their website
late last year and dropped almost every data item from their web pages.

Building something like those reports would be a major task. And I'm not
sure it would be worth it. Why PRESENT such data in EXCEL, when you can
just go to web pages to see it presented that way? It's just too much data
to be of much value. You need to condense it down to the few items that are
of particular interest to you. Try to get it to a one page display. You can
always add hyperlinks to the web pages if you want to see more details.

As Kermit suggested, you may want to look at some of the templates. They
have a lot of raw data presentation, so you can cut and paste the data
items you want to pick up.

Note that you may have unresolved links, because of how EXCEL handles
workbooks saved by someone else with a different setup. You can use the
smfFixLinks macro that is within the add-in to automatically clean up any
unresolved links from location errors.

On Mon, Jul 13, 2015 at 1:24 AM, toantranvnpt@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I am trying to download MSFT (Microsoft) for my work
>
> I saw Investing Sidekick - Stock Reports for DIY Investors
> <https://investingsidekick.com/>
> [image: image] <https://investingsidekick.com/>
> Investing Sidekick - Stock Reports for DIY Investors
> <https://investingsidekick.com/>
> Get access to fundamental stock analysis and stock reports on thousands of
> US listed stocks. Our stock valuation spreadsheets work in Excel and
> Googl...
> View on investingsidekick.com <https://investingsidekick.com/>
> Preview by Yahoo
>
>
> I amtrying to do a spreedsheet like that, based on SMF Add-In, but I do
> not know where to start the work.
>
> Can anyone help me a basic start
>
>

Mon Jul 13, 2015 7:50 am (PDT) . Posted by:

sabmarwan

Hi, I am trying to use the Google Finance workbooks Add-in on a Windows 8 computer with Office 2007 but I just receive error messages. I use the same spreadsheet on a Windows 7 computer and it works fine.


Is there something particular that I should do to make it work on Windows 8?


Thanks very much

Mon Jul 13, 2015 8:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Some people that were getting errors found the AdvFN fix also fixed the
Google problem:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464

I think it's because of Google changing from "http:" to "https:", which
causes a redirection to occur.

For example:

=RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
=RCHGetTableCell("https://www.google.com/finance?q=MMM",1,">P/E")

If you need the fix, the first formula above will give an error result and
the second will return the P/E value.

On Mon, Jul 13, 2015 at 7:38 AM, mmmscoool@... wrote:

> Hi, I am trying to use the Google Finance workbooks Add-in on a Windows
> 8 computer with Office 2007 but I just receive error messages. I use the
> same spreadsheet on a Windows 7 computer and it works fine.
>
> Is there something particular that I should do to make it work on Windows
> 8?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar