4 Messages
Digest #4290
Messages
Sat Jan 13, 2018 3:08 am (PST) . Posted by:
steve.bogart
Here are two sites to check out: https://www.alphavantage.co/ https://www.alphavantage.co/
https://www.quandl.com/ https://www.quandl.com/
https://www.quandl.com/ https://www.quandl.com/
Sat Jan 13, 2018 3:38 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Some demos of using the SMF add-in to grab data from Alphaadvantage:
Batch current Quotes (only last prices and volume):
=smfGetCSVFile("
https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES&symbols=MSFT,FB,AAPL&apikey=demo&datatype=csv
")
Daily adjusted historical quotes:
=smfGetCSVFile("https://www.alphavantage.co/query?
function=TIME_SERIES_DAILY_ADJUSTED&symbol=MSFT&apikey=demo&datatype=csv")
Weekly adjusted historical quotes:
=smfGetCSVFile("
https://www.alphavantage.co/query?function=TIME_SERIES_WEEKLY_ADJUSTED&symbol=MSFT&apikey=demo&datatype=csv
")
Monthly adjusted historical quotes:
=smfGetCSVFile("
https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY_ADJUSTED&symbol=MSFT&apikey=demo&datatype=csv
")
Note those are just "demo" URLs -- if you want to use other ticker symbols,
you'd need to get your own "apikey" from them:
https://www.alphavantage.co/support/#api-key
On Sat, Jan 13, 2018 at 4:07 AM, stevebogart44@
...
wrote:
>
> Here are two sites to check out:
>
> https://www.alphavantage.co/https://www.quandl.com/
>
>
>
Batch current Quotes (only last prices and volume):
=smfGetCSVFile("
https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES&symbols=MSFT,FB,AAPL&apikey=demo&datatype=csv
")
Daily adjusted historical quotes:
=smfGetCSVFile("https://www.alphavantage.co/query?
function=TIME_SERIES_DAILY_ADJUSTED&symbol=MSFT&apikey=demo&datatype=csv")
Weekly adjusted historical quotes:
=smfGetCSVFile("
https://www.alphavantage.co/query?function=TIME_SERIES_WEEKLY_ADJUSTED&symbol=MSFT&apikey=demo&datatype=csv
")
Monthly adjusted historical quotes:
=smfGetCSVFile("
https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY_ADJUSTED&symbol=MSFT&apikey=demo&datatype=csv
")
Note those are just "demo" URLs -- if you want to use other ticker symbols,
you'd need to get your own "apikey" from them:
https://www.alphavantage.co/support/#api-key
On Sat, Jan 13, 2018 at 4:07 AM, stevebogart44@
...
wrote:
>
> Here are two sites to check out:
>
> https://www.alphavantage.co/https://www.quandl.com/
>
>
>
Sat Jan 13, 2018 3:13 pm (PST) . Posted by:
rimanda1
Apologies for lack of clarity.
Yes I can (and always do) login to Morning Star using the Excel WEB Query Dialog. By changing pages, I meant clicking on the menu Morning Star web site option Portfolio whilst still in the WEB query dialog.
This morning, to verify my situation, I followed the following process:
1. Open a new instance of Excel and created a blank worksheet
2. Array entered the following formula ensuring I had included sufficient columns to display 10 years data:
=smfGetCSVFile("http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=" & A1 & "&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw")
3. Activated the Excel Web Query dialog and logged into Morning Star. I waited until the "login" link had changed to "logout" to ensure I was in fact logged in
3. Closed the WEB query dialog and verified that only 5 years of data was displayed
4. Ran the smfForceReculation macro, but still only 5 years data was displayed.
If you follow a similar process, do you get back 10 years data?
I am using version 2.1.2017.11.04 as defined by the constant kVersion
Yes I can (and always do) login to Morning Star using the Excel WEB Query Dialog. By changing pages, I meant clicking on the menu Morning Star web site option Portfolio whilst still in the WEB query dialog.
This morning, to verify my situation, I followed the following process:
1. Open a new instance of Excel and created a blank worksheet
2. Array entered the following formula ensuring I had included sufficient columns to display 10 years data:
=smfGetCSVFile("http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=" & A1 & "&reportType=
3. Activated the Excel Web Query dialog and logged into Morning Star. I waited until the "login" link had changed to "logout" to ensure I was in fact logged in
3. Closed the WEB query dialog and verified that only 5 years of data was displayed
4. Ran the smfForceReculation macro, but still only 5 years data was displayed.
If you follow a similar process, do you get back 10 years data?
I am using version 2.1.2017.11.
Sat Jan 13, 2018 3:46 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Nothing would change immediately in the worksheet after step (3), but
should have after step (4).
Seems to be working fine here. What do you get with:
=RCHGetWebData("
http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=MMM&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw
","December",100)
=smfGetTagContent("http://financials.morningstar.com/ratios/r.html?t=MMM
","div",-1,"Welcome")
Have you converted to their beta site?
Can you attach a worksheet with just those functions in it?
On Sat, Jan 13, 2018 at 4:13 PM, rimanda1@
...
wrote:
>
> Apologies for lack of clarity.
>
> Yes I can (and always do) login to Morning Star using the Excel WEB Query
> Dialog. By changing pages, I meant clicking on the menu Morning Star web
> site option Portfolio whilst still in the WEB query dialog.
>
> This morning, to verify my situation, I followed the following process:
> 1. Open a new instance of Excel and created a blank worksheet
> 2. Array entered the following formula ensuring I had included sufficient
> columns to display 10 years data:
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/ReportProcess4CSV.html?t=" & A1 & "&reportType=is&period=12&
> dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw")
> 3. Activated the Excel Web Query dialog and logged into Morning Star. I
> waited until the "login" link had changed to "logout" to ensure I was in
> fact logged in
> 3. Closed the WEB query dialog and verified that only 5 years of data was
> displayed
> 4. Ran the smfForceReculation macro, but still only 5 years data was
> displayed.
>
> If you follow a similar process, do you get back 10 years data?
> I am using version 2.1.2017.11.04 as defined by the constant kVersion
>
>
should have after step (4).
Seems to be working fine here. What do you get with:
=RCHGetWebData("
http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=MMM&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw
","December",100)
=smfGetTagContent("http://financials.morningstar.com/ratios/r.html?t=MMM
","div",-1,"Welcome")
Have you converted to their beta site?
Can you attach a worksheet with just those functions in it?
On Sat, Jan 13, 2018 at 4:13 PM, rimanda1@
...
wrote:
>
> Apologies for lack of clarity.
>
> Yes I can (and always do) login to Morning Star using the Excel WEB Query
> Dialog. By changing pages, I meant clicking on the menu Morning Star web
> site option Portfolio whilst still in the WEB query dialog.
>
> This morning, to verify my situation, I followed the following process:
> 1. Open a new instance of Excel and created a blank worksheet
> 2. Array entered the following formula ensuring I had included sufficient
> columns to display 10 years data:
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/ReportProcess4
> dataType=A&order=
> 3. Activated the Excel Web Query dialog and logged into Morning Star. I
> waited until the "login" link had changed to "logout" to ensure I was in
> fact logged in
> 3. Closed the WEB query dialog and verified that only 5 years of data was
> displayed
> 4. Ran the smfForceReculation macro, but still only 5 years data was
> displayed.
>
> If you follow a similar process, do you get back 10 years data?
> I am using version 2.1.2017.11.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar