Closed pympk closed 1 year ago
I have exactly the same problem and it started today
using v 5.0.1.8 on windows 7 machine with the same result, windows 10 machine has same problem. sent an email to Adrian for help. Waiting for response
I got "Could not get cookie" in the Status panel using v5 and v6 version. Maybe yahoo changed something today.
same here .
+1, glad I'm not alone. Win-11, V.6.0.0 64bit
Still same problem. 4/29/22 8:30 MDT
still same problem @ 11:11 est FYI
Got the following message from Adrian;
Hi,
I'm aware of the problem, and it looks like it's caused by a protocol change on Yahoo's side.
I won't be able to look into it at this time however but I will continue monitoring the situation and will let you know when/if there is a change.
Best regards,
Adrian
Thanks Adrian!
same here. hope can be fixed soon, thank you Adrian
same problem here.
Hi the quantmod package in R had the exact same problem, and it was just fixed yesterday. Maybe this can help to solve the issue: https://github.com/joshuaulrich/quantmod/issues/358
don't know if this helps but in looking at headers in Yahoo historical data the following exists
Date | Open | High | Low | Close* | Adj Close** | Volume -- | -- | -- | -- | -- | -- | -- could the field "Adj Close**" be causing a problem?quantmod package in R
could you give me info on"quantmod" package in R . Im not an expert as u can tell.
Thanks
Here is a summary: https://cran.r-project.org/web/packages/quantmod/quantmod.pdf
Any update?
Same error message here since Friday. Another program I was using that provided updates via Yahoo is also not working
Could you please tell me what program and is there anything that will provide txt data until yloader gets fixed.
thanks
Ben Wilks
On Mon, May 2, 2022 at 12:42 PM pstenson @.***> wrote:
Same error message here since Friday. Another program I was using that provided updates via Yahoo is also not working
— Reply to this email directly, view it on GitHub https://github.com/adrianmichel/yloader/issues/16#issuecomment-1115108285, or unsubscribe https://github.com/notifications/unsubscribe-auth/AY6EBN5H7RMUAWHSRFGNYPDVIAAWTANCNFSM5UTXY6KQ . You are receiving this because you commented.Message ID: @.***>
Hi, bought a power license for 10$ a month here, and I'm super happy with it:
https://api.tiingo.com/about/pricing
Then you can call the API from any language that you want, and gets the EOD price data.
Tiingo looks great. Could Yloader not use this as an alternative source to Yahoo?
I know this is open source, but the total lack of attention, outlook or even commentary by the developer is somewhat disheartening. This program has been a daily stock in my work for years now. Sad to see it this way.
I for one would be willing to send Adrian a reasonable Paypal reward payment if YLoader was fixed. Perhaps if others committed to do so, he would be sufficiently motivated.
This needs to have more than one developer maintaining it. This is open source, right. The community could fund anyone with a knowledge of APIs to fix this. Especially since as per one of the above posts, the fix seems to be fairly straightforward if you know Code.
Any luck on "Could not get cookie" error yet?
Agree
On Fri, May 6, 2022, 3:19 AM dgarrard @.***> wrote:
I for one would be willing to send Adrian a reasonable Paypal reward payment if YLoader was fixed. Perhaps if others committed to do so, he would be sufficiently motivated.
— Reply to this email directly, view it on GitHub https://github.com/adrianmichel/yloader/issues/16#issuecomment-1119328201, or unsubscribe https://github.com/notifications/unsubscribe-auth/AY6EBN6TTMGNFXMTFJ6M4W3VITBWJANCNFSM5UTXY6KQ . You are receiving this because you commented.Message ID: @.***>
Agree
On Fri, May 6, 2022, 3:59 AM peter-lernyx @.***> wrote:
This needs to have more than one developer maintaining it. This is open source, right. The community could fund anyone with a knowledge of APIs to fix this. Especially since as per one of the above posts, the fix seems to be fairly straightforward if you know Code.
— Reply to this email directly, view it on GitHub https://github.com/adrianmichel/yloader/issues/16#issuecomment-1119356791, or unsubscribe https://github.com/notifications/unsubscribe-auth/AY6EBNYAOUDITEHXYVERBZDVITGPLANCNFSM5UTXY6KQ . You are receiving this because you commented.Message ID: @.***>
still same problem @ 11:11 est FYI
Got the following message from Adrian;
Hi,
I'm aware of the problem, and it looks like it's caused by a protocol change on Yahoo's side.
I won't be able to look into it at this time however but I will continue monitoring the situation and will let you know when/if there is a change.
Best regards,
Adrian
the following gets yahoo quotes but still need to get yloader up and running.
http://www.ashkon.com/downloader.html
anyone have additional info.
thanks.
Ben Wilks
I am facing same issue , I have created a program in python using yFinance and now i am able to get quotes same as Yloader.
Same problem as everyone, the cookies error. I wrote a very simple python routine to download Yahoo history for a list (text file) of any number of symbols for any date period as far back as Yahoo can go. Feel free to use it and improve it. It doesn't run quite as fast as yloader, but it works well for me.
FYI, I have been using an old (excellent) charting software called "Wall Street Analyzer", which also wasn't working due to this problem. It gets quotes from a website (neuralstockmarket.com), which serves quotes from Yahoo to a specially modified version of WSA. The neuralstockmarket.com has just fixed this Yahoo problem so it is possible to repair. You can find out more about WSA at groups.io/g/Wall-Street-Analyzer.
www.lathuy.com where apparently WSA is being maintained is offline. Can WSA also export data or is this a one way street?
As I said, you must get a specially modified version of WSA, check out neuralstockmarket.com. You must register to get it. As far as export goes, the WSA has an export function which doesn't work, but I have written "report" function which performs the export. It writes to a html file which can be then copied and pasted into a spreadsheet. A little round-about, but it works. Much easier to use yloader!
Huge thanks CodeInMyDreams! Perfect. Typed in the code, fixed the typos, 2 minutes later all running smooth with a solution that I can fix myself if it breaks.
@CodeInMyDreams I'm a trader, not a coder, I know this must sound kinda lazy, trust me it isn't. Is there an ascii version of this code? I have never written a single line in Python, I am concerned if I start typing this off the jpeg, there is so much room for error and I won't be able to find the bug. I would have to copy paste it and then run it.
Huge thanks CodeInMyDreams! Perfect. Typed in the code, fixed the typos, 2 minutes later all running smooth with a solution that I can fix myself if it breaks.
@AnilVithal Do you mind sharing the edited code?
There's an Excel sheet that will download all the data you need and export to a CSV file that's just been updated (2nd May) and is free.... However, for some reason, the first line of data is written in a different date format to the rest of the historic data. I've contacted the author of the sheet but he hasn't responded. If someone could change it so the date format is consistent and repost it for download, perhaps that'll be a good temporary solution if you normally download LOTS of data.
https://investexcel.net/multiple-stock-quote-downloader-for-excel/
thank you for the post. It worked for me. I did not have the problem of the first line date format . My csv file had 2 header lines (which I deleted so I could use the csv file in the next step.)
On Wed, 18 May 2022 03:37:05 -0700, you wrote:
There's an Excel sheet that will download all the data you need and export to a CSV file that's just been updated (2nd May) and is free.... However, for some reason, the first line of data is written in a different date format to the rest of the historic data. I've contacted the author of the sheet but he hasn't responded. If someone could change it so the date format is consistent and repost it for download, perhaps that'll be a good temporary solution if you normally download LOTS of data.
https://investexcel.net/multiple-stock-quote-downloader-for-excel/
@CodeInMyDreams I'm a trader, not a coder, I know this must sound kinda lazy, trust me it isn't. Is there an ascii version of this code? I have never written a single line in Python, I am concerned if I start typing this off the jpeg, there is so much room for error and I won't be able to find the bug. I would have to copy paste it and then run it.
I have the same problem. can u help?
There's an Excel sheet that will download all the data you need and export to a CSV file that's just been updated (2nd May) and is free.... However, for some reason, the first line of data is written in a different date format to the rest of the historic data. I've contacted the author of the sheet but he hasn't responded. If someone could change it so the date format is consistent and repost it for download, perhaps that'll be a good temporary solution if you normally download LOTS of data.
https://investexcel.net/multiple-stock-quote-downloader-for-excel/
I am getting a 'type invalid' error 13 message. I am assuming this is to do with date formats. My Excel is German, any idea how to fromulate the date so that VBA will accept it?
Not al all. Here you go. Remember to install pandas and yfinance if you don’t already have it.
import pandas as pd
import yfinance as yf
pd.set_option("display.max_rows",None)
pd.set_option("display.max_columns",None)
pd.set_option("display.width",None)
print("Create a text file containing a list of the symbols you want to download,\none symbol per line, not case sensitive.\n")
inputPath = "c:\stock\symbols.txt"
s = input("Enter the full symbols list pathname: " + inputPath + " ")
if s != "":
inputPath = s
print("\nCreate a folder to receive the .CSV files from Yahoo.\nlf the folder contains downloaded files, they will be overwritten.\n")
outputPath = "c:\stock\transfer\"
s = input("Fnter the CSV output folder pathname: " + outputPath + " ")
if s != "":
outputPath = s
if outputPath[-1:-1] != "\":
outputPath = outputPath + "\\"
startDate = "2015-01-01"
s = input("Enter the starting date in this format: " + startDate + " ")
if s != "":
startDate = s
endDate = "2022-12-31"
s = input("Enter the ending date in this format: " + endDate + " ")
if s != "":
endDate = s
f = open(inputPath,"r")
tickers = pd.Series(f)
for ticker in tickers.values:
ticker = ticker[0:-1]
df = yf.download(ticker, start = startDate, end = endDate, progress=False)
if df.values.size == 0:
continue
print(ticker)
df.to_csv(outputPath + ticker + ".csv")
From: peter-lernyx @.> Sent: 18-May-22 3:56 AM To: adrianmichel/yloader @.> Cc: AnilVithal @.>; Mention @.> Subject: Re: [adrianmichel/yloader] Error message: Could not get cookie (Issue #16)
Huge thanks CodeInMyDreams! Perfect. Typed in the code, fixed the typos, 2 minutes later all running smooth with a solution that I can fix myself if it breaks.
@AnilVithal https://github.com/AnilVithal Do you mind sharing the edited code?
—
Not al all. Here you go. Remember to install pandas and yfinance if you don’t already have it. import pandas as pd import ....
So friendly, thank you very much. :-)
Ooh lucky you ;) Glad it worked for you. I live in the UK so I wonder why there's a date format problem in Excel for me.
Ooh lucky you ;) Glad it worked for you. I live in the UK so I wonder why there's a date format problem in Excel for me.
You're referring to the Bulk Stock Quote Downloader spreadsheet? I am experiencing this, is this what you have?:
Εxcellent.
Could the files have the following format?
RIP, yloader!
Too bad, seems like the fix should be easy
There's an Excel sheet that will download all the data you need and export to a CSV file that's just been updated (2nd May) and is free.... However, for some reason, the first line of data is written in a different date format to the rest of the historic data. I've contacted the author of the sheet but he hasn't responded. If someone could change it so the date format is consistent and repost it for download, perhaps that'll be a good temporary solution if you normally download LOTS of data.
https://investexcel.net/multiple-stock-quote-downloader-for-excel/
To peter-lernyx and anyone else noticing the first (or last) date format issue in the https://investexcel.net/multiple-stock-quote-downloader-for-excel/ ticker worksheets...
I have sent the following to the sheet's author for his validation and incorporation should he see fit.
I believe that this is caused by a miscalculation in determining the last row just prior to the format set in the DownloadData sub. Specifically: lastRow = Sheets(stockTicker).UsedRange.Row – 2 + Sheets(stockTicker).UsedRange.Rows.Count
should be lastRow = Sheets(stockTicker).UsedRange.Row – 1 + Sheets(stockTicker).UsedRange.Rows.Count
It's an easy change if you want to try.
To peter-lernyx and anyone else noticing the first (or last) date format issue in the https://investexcel.net/multiple-stock-quote-downloader-for-excel/ ticker worksheets...
I have sent the following to the sheet's author for his validation and incorporation should he see fit.
I believe that this is caused by a miscalculation in determining the last row just prior to the format set in the DownloadData sub. Specifically: lastRow = Sheets(stockTicker).UsedRange.Row – 2 + Sheets(stockTicker).UsedRange.Rows.Count
should be lastRow = Sheets(stockTicker).UsedRange.Row – 1 + Sheets(stockTicker).UsedRange.Rows.Count
It's an easy change if you want to try.
* Open the spreadsheet * Enable the Developer option in the ribbon if it's not there and click on it. * Click on Visual Basic * Locate the above code line (about 50 lines into the DownloadData subroutine) and fix it.
Nice catch, you got it man. Your mod works like a charm. If you put Today()+1 in the end date, you even get today's up-to-date quote in the correct format.
anyone have a modified version available, my copy rejects my attempts because of some visual basic problem.
I am grateful for this spreadsheet but waiting until the next morning to get yesterdays final quote gets old.
On Fri, 10 Jun 2022 01:03:53 -0700, you wrote:
To peter-lernyx and anyone else noticing the first (or last) date format issue in the https://investexcel.net/multiple-stock-quote-downloader-for-excel/ ticker worksheets...
I have sent the following to the sheet's author for his validation and incorporation should he see fit.
I believe that this is caused by a miscalculation in determining the last row just prior to the format set in the DownloadData sub. Specifically: lastRow = Sheets(stockTicker).UsedRange.Row 2 + Sheets(stockTicker).UsedRange.Rows.Count
should be lastRow = Sheets(stockTicker).UsedRange.Row 1 + Sheets(stockTicker).UsedRange.Rows.Count
It's an easy change if you want to try.
* Open the spreadsheet * Enable the Developer option in the ribbon if it's not there and click on it. * Click on Visual Basic * Locate the above code line (about 50 lines into the DownloadData subroutine) and fix it.
Nice catch, you got it man. Your mod works like a charm. If you put Today()+1 in the end date, you even get today's up-to-date quote in the correct format.
Wow! I'm going to give this a go. Thank you.
On Fri, 10 Jun 2022 at 09:03, peter-lernyx @.***> wrote:
To peter-lernyx and anyone else noticing the first (or last) date format issue in the https://investexcel.net/multiple-stock-quote-downloader-for-excel/ ticker worksheets...
I have sent the following to the sheet's author for his validation and incorporation should he see fit.
I believe that this is caused by a miscalculation in determining the last row just prior to the format set in the DownloadData sub. Specifically: lastRow = Sheets(stockTicker).UsedRange.Row – 2 + Sheets(stockTicker).UsedRange.Rows.Count
should be lastRow = Sheets(stockTicker).UsedRange.Row – 1 + Sheets(stockTicker).UsedRange.Rows.Count
It's an easy change if you want to try.
Open the spreadsheet
Enable the Developer option in the ribbon if it's not there and click on it.
Click on Visual Basic
Locate the above code line (about 50 lines into the DownloadData subroutine) and fix it.
Nice catch, you got it man. Your mod works like a charm. If you put Today()+1 in the end date, you even get today's up-to-date quote in the correct format.
[image: grafik] https://user-images.githubusercontent.com/75390480/173020123-3212084c-6dd2-4c4b-be95-084acb8c7b14.png
— Reply to this email directly, view it on GitHub https://github.com/adrianmichel/yloader/issues/16#issuecomment-1152088257, or unsubscribe https://github.com/notifications/unsubscribe-auth/AZHC2G3763FPIHAPD6DOB5DVOLZGVANCNFSM5UTXY6KQ . You are receiving this because you commented.Message ID: @.***>
anyone have a modified version available, my copy rejects my attempts because of some visual basic problem. I am grateful for this spreadsheet but waiting until the next morning to get yesterdays final quote gets old. On Fri, 10 Jun 2022 01:03:53 -0700, you wrote: …
To peter-lernyx and anyone else noticing the first (or last) date format issue in the https://investexcel.net/multiple-stock-quote-downloader-for-excel/ ticker worksheets... > > I have sent the following to the sheet's author for his validation and incorporation should he see fit. > > I believe that this is caused by a miscalculation in determining the last row just prior to the format set in the DownloadData sub. Specifically: lastRow = Sheets(stockTicker).UsedRange.Row � 2 + Sheets(stockTicker).UsedRange.Rows.Count > > should be lastRow = Sheets(stockTicker).UsedRange.Row � 1 + Sheets(stockTicker).UsedRange.Rows.Count > > It's an easy change if you want to try. > > Open the spreadsheet > > Enable the Developer option in the ribbon if it's not there and click on it. > > Click on Visual Basic > > Locate the above code line (about 50 lines into the DownloadData subroutine) and fix it. Nice catch, you got it man. Your mod works like a charm. If you put Today()+1 in the end date, you even get today's up-to-date quote in the correct format.
Look for this line in visual basic editor. Replace 'January' in the original version with whatever word is 'January in your own language. See whether that solves it.
I got "Could not get cookie" in the Status panel using v5 and v6 version. Maybe yahoo changed something today.