5 Messages
Digest #4576
1b
Re: smfGetYahooPortfolioView multiple occurrences of the same ticker by "Randy Harmelink" rharmelink
Messages
Sun Jul 14, 2019 3:23 pm (PDT) . Posted by:
lewglenn
Randy,
I just went to the website and downloaded the latest add-in (2.1.2018.01.24). After I installed it and ran my code to check on the version I got:
Stock Market Functions add-in, Version 2.1.2017.11.08 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
Any idea as to what I did wrong?
I just went to the website and downloaded the latest add-in (2.1.2018.01.
Stock Market Functions add-in, Version 2.1.2017.11.
Any idea as to what I did wrong?
Sun Jul 14, 2019 4:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you exit EXCEL before updating the XLA file? Add-ins are only loaded
when EXCEL starts up.
Otherwise, did you update the XLA in the correct folder?
On Sun, Jul 14, 2019 at 3:26 PM lewglenn@... wrote:
>
> I just went to the website and downloaded the latest add-in
> (2.1.2018.01.24). After I installed it and ran my code to check on the
> version I got:
> Stock Market Functions add-in, Version 2.1.2017.11.08 (C:\Program
> Files\SMF Add-in; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
>
> Any idea as to what I did wrong?
>
>
>
when EXCEL starts up.
Otherwise, did you update the XLA in the correct folder?
On Sun, Jul 14, 2019 at 3:26 PM lewglenn@... wrote:
>
> I just went to the website and downloaded the latest add-in
> (2.1.2018.01.
> version I got:
> Stock Market Functions add-in, Version 2.1.2017.11.
> Files\SMF Add-in; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
>
> Any idea as to what I did wrong?
>
>
>
Sun Jul 14, 2019 9:35 pm (PDT) . Posted by:
turley.muller
I recommend using the WORKDAY(start date, +/- workdays, exclude dates) function to find the calendar date that was x number (50) of trading days ago.
You can reference a range of dates when the market was closed on weekday, i.e. holidays and on one-offs like John McCain memorial etc. Thats the way to do it if you require having exactly (x) number of trading days. Applying a factor will be inconsistent over time as your look=back period moves over ranges where there were, 1, or 2, 3, or none- weekdays when market was not open. I keep a separate spreadsheet with a list of all those dates that I can quickly copy and paste into the file I am using,
You can reference a range of dates when the market was closed on weekday, i.e. holidays and on one-offs like John McCain memorial etc. Thats the way to do it if you require having exactly (x) number of trading days. Applying a factor will be inconsistent over time as your look=back period moves over ranges where there were, 1, or 2, 3, or none- weekdays when market was not open. I keep a separate spreadsheet with a list of all those dates that I can quickly copy and paste into the file I am using,
Mon Jul 15, 2019 1:25 am (PDT) . Posted by:
"George Warriner" georgeawarriner
Randy, I have never written to you before but this may interest you. For most users this will be a free service, and with your skills you can add the API to your products.
https://www.tiingo.com/
https://api.tiingo.com/
* "JSON - The data is returned in the JSON data structure. This format allows the most flexibility as we can append meta data as well as debugging data. The downside to this data type is that it requires more bandwidth, which means it may be slower since more data has to be downloaded and parsed by the client side.
* CSV - This is a "bare-bones" data return type that is often 4-5x faster than JSON. The data is returned in comma-separated-format, which is helpful when importing the data in spreadsheet programs like Excel. "
I am now running, "Ultimate Excel Stock Quotes Downloader<http://ultimatestockdownloader.com/>". As a rank armature this provides all I need.
I hope you and your fellow members will at least have a look at its potential.
Regards…George A Warriner
https://www.tiingo.com/
https://api.tiingo.com/
* "JSON - The data is returned in the JSON data structure. This format allows the most flexibility as we can append meta data as well as debugging data. The downside to this data type is that it requires more bandwidth, which means it may be slower since more data has to be downloaded and parsed by the client side.
* CSV - This is a "bare-bones" data return type that is often 4-5x faster than JSON. The data is returned in comma-separated-format, which is helpful when importing the data in spreadsheet programs like Excel. "
I am now running, "Ultimate Excel Stock Quotes Downloader<http://ultimatestockdownloader.com/>". As a rank armature this provides all I need.
I hope you and your fellow members will at least have a look at its potential.
Regards…George A Warriner
Mon Jul 15, 2019 1:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Something like this works fine for me:
=smfGetCSVFile("
https://api.tiingo.com/tiingo/daily/AAPL/prices?startDate=2012-1-1&endDate=2016-1-1&format=csv
")
But it does require a login. EXCEL prompts me for the login on the first
attempt to get historical quotes
On Mon, Jul 15, 2019 at 1:25 AM George Warriner georgeawarriner@... wrote:
>
> Randy, I have never written to you before but this may interest you. For
> most users this will be a free service, and with your skills you can add
> the API to your products.
>
>
>
> https://www.tiingo.com/
>
>
>
> https://api.tiingo.com/
>
>
>
> - "*JSON* - The data is returned in the JSON data structure.. This
> format allows the most flexibility as we can append meta data as well as
> debugging data. The downside to this data type is that it requires more
> bandwidth, which means it may be slower since more data has to be
> downloaded and parsed by the client side.
> - *CSV* - This is a "bare-bones" data return type that is often 4-5x
> faster than JSON. The data is returned in comma-separated-format, which is
> helpful when importing the data in spreadsheet programs like Excel. "
>
> I am now running, "Ultimate Excel Stock Quotes Downloader
> <http://ultimatestockdownloader.com/>". As a rank armature this provides
> all I need.
>
> I hope you and your fellow members will at least have a look at its
> potential.
>
> Regards…George A Warriner
>
>
>
>
=smfGetCSVFile("
https://api.tiingo.com/tiingo/daily/AAPL/prices?startDate=2012-1-1&endDate=2016-1-1&format=csv
")
But it does require a login. EXCEL prompts me for the login on the first
attempt to get historical quotes
On Mon, Jul 15, 2019 at 1:25 AM George Warriner georgeawarriner@... wrote:
>
> Randy, I have never written to you before but this may interest you. For
> most users this will be a free service, and with your skills you can add
> the API to your products.
>
>
>
> https://www.tiingo.com/
>
>
>
> https://api.tiingo.com/
>
>
>
> - "*JSON* - The data is returned in the JSON data structure.. This
> format allows the most flexibility as we can append meta data as well as
> debugging data. The downside to this data type is that it requires more
> bandwidth, which means it may be slower since more data has to be
> downloaded and parsed by the client side.
> - *CSV* - This is a "bare-bones" data return type that is often 4-5x
> faster than JSON. The data is returned in comma-separated-format, which is
> helpful when importing the data in spreadsheet programs like Excel. "
>
> I am now running, "Ultimate Excel Stock Quotes Downloader
> <http://ultimatestockdownloader.com/>". As a rank armature this provides
> all I need.
>
> I hope you and your fellow members will at least have a look at its
> potential.
>
> Regards…George A Warriner
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar