I have contacted tech support via chat, but don't have the right solution so far. On other platforms, it is possible to connect to free End of Day data feeds like Yahoo indexes. I have found through help with tech support that some things are available that follow the S&P500, like SPY for example, but the quality of the data is low (ie the open is always zero). SPY is also a poor proxy of the S&P500 as it is not linearly correlated (not that you have to know what that means). The "Free Quotes" feed gives all the regular listed stocks, but not the S&P. I have tried the following symbols but they all fail: $SPX, SPX, $INX, .INX, ^GSPC.
The question is, how can I get a good EOD data feed for the S&P500? I know how to get it through imports, but I have already done that and it is not what I want. I want to every day get the EOD update automatically. I also know I can pay through the nose, but this is not premium data for trading. It is for overall market analysis. I have the data I need from my broker for trading and then this is ancillary data for market review.
I have considered doing something like the following, but it is a hack. I can run a chart off of SPY, but read my S&P500 data from my own source and replace the SPY data with my data in CalcBar. The SPY data gives me the call-backs to CalcBar, but that is its only purpose in this case. Is there a better way than this?
Free Quotes for S&P500 [SOLVED]
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Free Quotes for S&P500
Hi Tradetree
Check this address: http://pages.swcp.com/stocks/#historical%20data
Maybe it helps you.
Regards
MaRCHeW
Check this address: http://pages.swcp.com/stocks/#historical%20data
Maybe it helps you.
Regards
MaRCHeW
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: Free Quotes for S&P500
tradetree,
With FreeQuotes you can get data only for the symbols that have the option Historical prices->Download to Spreadsheet on their webpage.
You can get the data from one of the supported data providers:
https://www.multicharts.com/market-data-feeds/
If you have in Metastock - you can load it into MultiCharts. Here how to do that.
If you have the data in ASCII file you can import it or read directly from the file using ASCII mapping.
With FreeQuotes you can get data only for the symbols that have the option Historical prices->Download to Spreadsheet on their webpage.
You can get the data from one of the supported data providers:
https://www.multicharts.com/market-data-feeds/
If you have in Metastock - you can load it into MultiCharts. Here how to do that.
If you have the data in ASCII file you can import it or read directly from the file using ASCII mapping.
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Free Quotes for S&P500
tradetree,
With FreeQuotes you can get data only for the symbols that have the option Historical prices->Download to Spreadsheet on their webpage.
You can get the data from one of the supported data providers:
https://www.multicharts.com/market-data-feeds/
If you have in Metastock - you can load it into MultiCharts. Here how to do that.
If you have the data in ASCII file you can import it or read directly from the file using ASCII mapping.
And yahoo has this here for the S&P500:
http://finance.yahoo.com/q/hp?s=%5EGSPC ... cal+Prices
But it does not work in Quote Manager! I am not looking for ASCII mapping, because then I have to map every day. I want to auto-update from yahoo through FreeQuotes. Every other platform supports an EOD S&P500 feed. Can Multicharts?
- JoshM
- Posts: 2195
- Joined: 20 May 2011
- Location: The Netherlands
- Has thanked: 1544 times
- Been thanked: 1565 times
- Contact:
Re: Free Quotes for S&P500
ASCII mapping settings are remembered, though you do need to update the source file each day (or use a script for that).(...) I am not looking for ASCII mapping, because then I have to map every day.(....)
(Just saying as a side note)
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Free Quotes for S&P500
Hey Josh,ASCII mapping settings are remembered, though you do need to update the source file each day (or use a script for that).(...) I am not looking for ASCII mapping, because then I have to map every day.(....)
(Just saying as a side note)
What kind of script? Do you mean one of those scripts that remember key strokes to the GUI? I have tried those and they are not that reliable. I don't know of an API for MC to tell it to update through software? If so, that would be great. I'd love to be able to auto-load data into MC.
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: Free Quotes for S&P500
Please specify what does not work exactly. I am able to receive S&P500 (^GSPC) data from Free Quotes for the symbol added manually:And yahoo has this here for the S&P500:
http://finance.yahoo.com/q/hp?s=%5EGSPC ... cal+Prices
But it does not work in Quote Manager!
- Attachments
-
- ^GSPC.png
- (31.15 KiB) Downloaded 1550 times
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Free Quotes for S&P500
Henry,
Today it works for me as well! I have no idea what happened. Perhaps yahoo finance was having trouble and it was a coincidence with when I first tried it. Anyway, thanks for the help.
Today it works for me as well! I have no idea what happened. Perhaps yahoo finance was having trouble and it was a coincidence with when I first tried it. Anyway, thanks for the help.
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Free Quotes for S&P500
Looks like I resolved this topic prematurely. I was able to load data once, but now it is stuck on 1/7/2014 as the last day. I tried going into the quote manager and "Loading" but it still only went to 1/7/2014. Being that it is now after close of market on 1/9/2014 there should be at least the 1/8/2014 bar available. On the Yahoo site it shows the 1/8/2014 information ready for download. I also tried opening a new chart and still only got up to 1/7/2014 for daily bars. Any ideas?
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: Free Quotes for S&P500
In MultiCharts please go to File tab->Preferences->Data server mode;Looks like I resolved this topic prematurely. I was able to load data once, but now it is stuck on 1/7/2014 as the last day. I tried going into the quote manager and "Loading" but it still only went to 1/7/2014. Being that it is now after close of market on 1/9/2014 there should be at least the 1/8/2014 bar available. On the Yahoo site it shows the 1/8/2014 information ready for download. I also tried opening a new chart and still only got up to 1/7/2014 for daily bars. Any ideas?
Make sure you are in online mode, "download missing historical data" is enabled.
After that is done - reload your chart (View tab->Reload / press Ctrl+R).
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Free Quotes for S&P500
Yes reload works. Does that mean that the only way to get daily update of bars is to go to each chart and perform a "reload" on a daily basis?
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: Free Quotes for S&P500
That is correct. Free Quotes is not a data provider with an API that MultiCharts can subscribe for contiguous data access. Free Quotes data is accessed by downloading an excel file from the website and parsing it. If you need to get the new bars - you need to reload your chart.Yes reload works. Does that mean that the only way to get daily update of bars is to go to each chart and perform a "reload" on a daily basis?
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Free Quotes for S&P500
Ok, could you check with your software team and see if there is any type of programmatic way to start the reload? All I need is a way to initiate the "reload" from an indicator or signal. I realize this is a long shot, but clearly there is already code in place to take action when the "reload" is done from Ctrl-R. I just need to mimic that action.That is correct. Free Quotes is not a data provider with an API that MultiCharts can subscribe for contiguous data access. Free Quotes data is accessed by downloading an excel file from the website and parsing it. If you need to get the new bars - you need to reload your chart.
- JoshM
- Posts: 2195
- Joined: 20 May 2011
- Location: The Netherlands
- Has thanked: 1544 times
- Been thanked: 1565 times
- Contact:
Re: Free Quotes for S&P500 [SOLVED]
See CommandLine and how that can be used to reload a chart. The MultiCharts .NET equivalent to CommandLine() is, as far as I know:Ok, could you check with your software team and see if there is any type of programmatic way to start the reload? All I need is a way to initiate the "reload" from an indicator or signal. I realize this is a long shot, but clearly there is already code in place to take action when the "reload" is done from Ctrl-R. I just need to mimic that action.
Code: Select all
ChartCommands.CommandLine("command");
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Free Quotes for S&P500
Josh,See CommandLine and how that can be used to reload a chart. The MultiCharts .NET equivalent to CommandLine() is, as far as I know:Ok, could you check with your software team and see if there is any type of programmatic way to start the reload? All I need is a way to initiate the "reload" from an indicator or signal. I realize this is a long shot, but clearly there is already code in place to take action when the "reload" is done from Ctrl-R. I just need to mimic that action.Code: Select all
ChartCommands.CommandLine("command");
I think this is exactly what I need. I'll try it out!
Re: Free Quotes for S&P500
I understand this is old thread but wondering how to ensure daily update of free quotes data feed.
Using multicharts powerlanguage, would adding this at end of script reload data in full on daily basis with addition of latest day bar?
If BarNumber <>BarNumber[1] then CommandLine(".rld");
Using multicharts powerlanguage, would adding this at end of script reload data in full on daily basis with addition of latest day bar?
If BarNumber <>BarNumber[1] then CommandLine(".rld");
- Polly MultiCharts
- Posts: 206
- Joined: 20 Jul 2022
- Has thanked: 1 time
- Been thanked: 56 times
Re: Free Quotes for S&P500
Hello boup09,
No, the historical bar will not appear on the chart. "BarNumber <>BarNumber[1]" will work for each bar.
We’d recommend using ComputerDateTime and RecalcLastBarAfter for your purpose.
You might check this sample for reference:
No, the historical bar will not appear on the chart. "BarNumber <>BarNumber[1]" will work for each bar.
We’d recommend using ComputerDateTime and RecalcLastBarAfter for your purpose.
You might check this sample for reference:
Code: Select all
if (currentbar = 1) then
value1 = dayofweekfromdatetime(computerdatetime);
RecalcLastBarAfter(600);
if (value1 <> dayofweekfromdatetime(computerdatetime))
then CommandLine(".rld");