Avoid Alphabetical order on python finance download
I am downloading data from yahoo finance, and it is being downloaded order alphabetically. Not like I send the list. How can avoid this?
STOCKS= ['^TNX', '^VIX', 'SPY', 'QQQ', 'DIA', '^FTSE', '^GDAXI', '^HSI', '^N225',
'XLC', 'XLY', 'XLP', 'XLE', 'XLF', 'XLV', 'XLI', 'XLB', 'XLRE', 'XLK', 'XLU',
'USO', 'GLD', 'SIL', 'CPER', 'PALL', 'LIT', 'URA', 'REMX', 'OYB', 'CORN', 'CANE', 'TAGS', 'WEAT']
start_date = '2016-06-01'
end_date = '2018-06-01'
extras_data = fyf.download(STOCKS, start_date, end_date)['Close']
print(extras_data)
what came back:
CANE CORN ... ^TNX ^VIX
Date ...
2016-05-31 11.50 22.139999 ... 1.834 14.190000
2016-06-01 11.56 22.610001 ... 1.846 14.200000
2016-06-02 11.85 22.549999 ... 1.811 13.630000
2016-06-03 12.13 22.760000 ... 1.704 13.470000
The columns are order alphabetically, I want to respect the list order.
python yahoo-finance
asked Nov 23 '18 at 11:45
FedeFede
71131533
add a comment |
I am downloading data from yahoo finance, and it is being downloaded order alphabetically. Not like I send the list. How can avoid this?
STOCKS= ['^TNX', '^VIX', 'SPY', 'QQQ', 'DIA', '^FTSE', '^GDAXI', '^HSI', '^N225',
'XLC', 'XLY', 'XLP', 'XLE', 'XLF', 'XLV', 'XLI', 'XLB', 'XLRE', 'XLK', 'XLU',
'USO', 'GLD', 'SIL', 'CPER', 'PALL', 'LIT', 'URA', 'REMX', 'OYB', 'CORN', 'CANE', 'TAGS', 'WEAT']
start_date = '2016-06-01'
end_date = '2018-06-01'
extras_data = fyf.download(STOCKS, start_date, end_date)['Close']
print(extras_data)
what came back:
CANE CORN ... ^TNX ^VIX
Date ...
2016-05-31 11.50 22.139999 ... 1.834 14.190000
2016-06-01 11.56 22.610001 ... 1.846 14.200000
2016-06-02 11.85 22.549999 ... 1.811 13.630000
2016-06-03 12.13 22.760000 ... 1.704 13.470000
The columns are order alphabetically, I want to respect the list order.
python yahoo-finance
asked Nov 23 '18 at 11:45
FedeFede
71131533
add a comment |
I am downloading data from yahoo finance, and it is being downloaded order alphabetically. Not like I send the list. How can avoid this?
STOCKS= ['^TNX', '^VIX', 'SPY', 'QQQ', 'DIA', '^FTSE', '^GDAXI', '^HSI', '^N225',
'XLC', 'XLY', 'XLP', 'XLE', 'XLF', 'XLV', 'XLI', 'XLB', 'XLRE', 'XLK', 'XLU',
'USO', 'GLD', 'SIL', 'CPER', 'PALL', 'LIT', 'URA', 'REMX', 'OYB', 'CORN', 'CANE', 'TAGS', 'WEAT']
start_date = '2016-06-01'
end_date = '2018-06-01'
extras_data = fyf.download(STOCKS, start_date, end_date)['Close']
print(extras_data)
what came back:
CANE CORN ... ^TNX ^VIX
Date ...
2016-05-31 11.50 22.139999 ... 1.834 14.190000
2016-06-01 11.56 22.610001 ... 1.846 14.200000
2016-06-02 11.85 22.549999 ... 1.811 13.630000
2016-06-03 12.13 22.760000 ... 1.704 13.470000
The columns are order alphabetically, I want to respect the list order.
python yahoo-finance
asked Nov 23 '18 at 11:45
FedeFede
71131533
I am downloading data from yahoo finance, and it is being downloaded order alphabetically. Not like I send the list. How can avoid this?
STOCKS= ['^TNX', '^VIX', 'SPY', 'QQQ', 'DIA', '^FTSE', '^GDAXI', '^HSI', '^N225',
'XLC', 'XLY', 'XLP', 'XLE', 'XLF', 'XLV', 'XLI', 'XLB', 'XLRE', 'XLK', 'XLU',
'USO', 'GLD', 'SIL', 'CPER', 'PALL', 'LIT', 'URA', 'REMX', 'OYB', 'CORN', 'CANE', 'TAGS', 'WEAT']
start_date = '2016-06-01'
end_date = '2018-06-01'
extras_data = fyf.download(STOCKS, start_date, end_date)['Close']
print(extras_data)
what came back:
CANE CORN ... ^TNX ^VIX
Date ...
2016-05-31 11.50 22.139999 ... 1.834 14.190000
2016-06-01 11.56 22.610001 ... 1.846 14.200000
2016-06-02 11.85 22.549999 ... 1.811 13.630000
2016-06-03 12.13 22.760000 ... 1.704 13.470000
The columns are order alphabetically, I want to respect the list order.
python yahoo-finance
python yahoo-finance
asked Nov 23 '18 at 11:45
FedeFede
71131533
asked Nov 23 '18 at 11:45
FedeFede
71131533
asked Nov 23 '18 at 11:45
FedeFede
71131533
asked Nov 23 '18 at 11:45
FedeFede
71131533
asked Nov 23 '18 at 11:45
FedeFede
71131533
71131533
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
This is how I would do it.
"your code here"
#after pulling the data from fyf. This will check what
#actual stocks were pulled and put it in a list
sorted_columns = [STOCK for STOCK in STOCKS if STOCK in extras_data.columns]
#then I use those columns to re-sort the dataframe from fyf
print(extras_data.loc[:,sorted_columns])
#or you can store it back to itself
extras_data = extras_data.loc[:,sorted_columns]
answered Nov 23 '18 at 12:24
fcsrfcsr
638413
thats work perfectly
– Fede
Nov 23 '18 at 14:09
add a comment |
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53446114%2favoid-alphabetical-order-on-python-finance-download%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This is how I would do it.
"your code here"
#after pulling the data from fyf. This will check what
#actual stocks were pulled and put it in a list
sorted_columns = [STOCK for STOCK in STOCKS if STOCK in extras_data.columns]
#then I use those columns to re-sort the dataframe from fyf
print(extras_data.loc[:,sorted_columns])
#or you can store it back to itself
extras_data = extras_data.loc[:,sorted_columns]
answered Nov 23 '18 at 12:24
fcsrfcsr
638413
thats work perfectly
– Fede
Nov 23 '18 at 14:09
add a comment |
This is how I would do it.
"your code here"
#after pulling the data from fyf. This will check what
#actual stocks were pulled and put it in a list
sorted_columns = [STOCK for STOCK in STOCKS if STOCK in extras_data.columns]
#then I use those columns to re-sort the dataframe from fyf
print(extras_data.loc[:,sorted_columns])
#or you can store it back to itself
extras_data = extras_data.loc[:,sorted_columns]
answered Nov 23 '18 at 12:24
fcsrfcsr
638413
thats work perfectly
– Fede
Nov 23 '18 at 14:09
add a comment |
This is how I would do it.
"your code here"
#after pulling the data from fyf. This will check what
#actual stocks were pulled and put it in a list
sorted_columns = [STOCK for STOCK in STOCKS if STOCK in extras_data.columns]
#then I use those columns to re-sort the dataframe from fyf
print(extras_data.loc[:,sorted_columns])
#or you can store it back to itself
extras_data = extras_data.loc[:,sorted_columns]
answered Nov 23 '18 at 12:24
fcsrfcsr
638413
This is how I would do it.
"your code here"
#after pulling the data from fyf. This will check what
#actual stocks were pulled and put it in a list
sorted_columns = [STOCK for STOCK in STOCKS if STOCK in extras_data.columns]
#then I use those columns to re-sort the dataframe from fyf
print(extras_data.loc[:,sorted_columns])
#or you can store it back to itself
extras_data = extras_data.loc[:,sorted_columns]
answered Nov 23 '18 at 12:24
fcsrfcsr
638413
answered Nov 23 '18 at 12:24
fcsrfcsr
638413
answered Nov 23 '18 at 12:24
fcsrfcsr
638413
answered Nov 23 '18 at 12:24
fcsrfcsr
638413
638413
thats work perfectly
– Fede
Nov 23 '18 at 14:09
add a comment |
thats work perfectly
– Fede
Nov 23 '18 at 14:09
thats work perfectly
– Fede
Nov 23 '18 at 14:09
thats work perfectly
– Fede
Nov 23 '18 at 14:09
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53446114%2favoid-alphabetical-order-on-python-finance-download%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
