4 Messages
Digest #4608
Messages
Thu Aug 29, 2019 6:24 am (PDT) . Posted by:
ajtalukdar
Hi Randy,
Now that Advfn has put quarterly and annual financial data behind a subscription, can you plan to add CSIMarket as a data source in the SMF Add in for this purpose?
I had a look at https://csimarket.com/stocks/income.php?code=MMM&annual https://csimarket.com/stocks/income.php?code=MMM&annual and it seems to display financial data (Income Statement/Balance Sheet) similar to Advfn. This would be quite helpful for those of us who were relying on Advfn historical financial data and are now left high and dry.
Now that Advfn has put quarterly and annual financial data behind a subscription, can you plan to add CSIMarket as a data source in the SMF Add in for this purpose?
I had a look at https://csimarket.com/stocks/income.php?code=MMM&annual https://csimarket.com/stocks/income.php?code=MMM&annual and it seems to display financial data (Income Statement/Balance Sheet) similar to Advfn. This would be quite helpful for those of us who were relying on Advfn historical financial data and are now left high and dry.
Thu Aug 29, 2019 8:42 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I doubt that will happen. I always hated that AdvFN was so difficult to get
historical data from, because they did it on multiple pages. It required me
to write a special function to retrieve the data.
And these days, my time is limited. It's one reason I pay for the GuruFocus
subscription. To make the retrieval easier. But I also don't use financial
data as much as I used to.
On Thu, Aug 29, 2019 at 6:24 AM ajtalukdar@... wrote:
>
> Now that Advfn has put quarterly and annual financial data behind a
> subscription, can you plan to add CSIMarket as a data source in the SMF Add
> in for this purpose?
>
> I had a look at https://csimarket.com/stocks/income.php?code=MMM&annual and
> it seems to display financial data (Income Statement/Balance Sheet) similar
> to Advfn. This would be quite helpful for those of us who were relying on
> Advfn historical financial data and are now left high and dry.
>
>
>
historical data from, because they did it on multiple pages. It required me
to write a special function to retrieve the data.
And these days, my time is limited. It's one reason I pay for the GuruFocus
subscription. To make the retrieval easier. But I also don't use financial
data as much as I used to.
On Thu, Aug 29, 2019 at 6:24 AM ajtalukdar@... wrote:
>
> Now that Advfn has put quarterly and annual financial data behind a
> subscription, can you plan to add CSIMarket as a data source in the SMF Add
> in for this purpose?
>
> I had a look at https://csimarket.com/stocks/income.php?code=MMM&annual and
> it seems to display financial data (Income Statement/Balance Sheet) similar
> to Advfn. This would be quite helpful for those of us who were relying on
> Advfn historical financial data and are now left high and dry.
>
>
>
Thu Aug 29, 2019 2:44 pm (PDT) . Posted by:
nautilustech
I've array-entered this formula: =smfPricesByDates("AAPL",K2:K34) where K2 & K34 are the beginning & ending dates of the range. Press Crtl-Shift-Enter. All I get is one price throughout the range which is the closing price in the last cell K34.
What in the world am I doing wrong?
Many thanks.
What in the world am I doing wrong?
Many thanks.
Thu Aug 29, 2019 5:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The function returns a row of data, so you're telling it to copy the one
price down the column. But that should have been copying down the price for
the date in the K2 cell, not the K34 cell? That's what I see.
Instead, try:
=TRANSPOSE(smfPricesByDates("AAPL",K2:K34))
On Thu, Aug 29, 2019 at 2:44 PM nautilustech@... wrote:
> I've array-entered this formula: =smfPricesByDates("AAPL",K2:K34) where
> K2 & K34 are the beginning & ending dates of the range. Press
> Crtl-Shift-Enter. All I get is one price throughout the range which is the
> closing price in the last cell K34.
>
> What in the world am I doing wrong?
>
> Many thanks.
>
>
price down the column. But that should have been copying down the price for
the date in the K2 cell, not the K34 cell? That's what I see.
Instead, try:
=TRANSPOSE(smfPrice
On Thu, Aug 29, 2019 at 2:44 PM nautilustech@
> I've array-entered this formula: =smfPricesByDates(
> K2 & K34 are the beginning & ending dates of the range. Press
> Crtl-Shift-Enter. All I get is one price throughout the range which is the
> closing price in the last cell K34.
>
> What in the world am I doing wrong?
>
> Many thanks.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar